position(Blob pattern, long start)

Syntax:

long position(Blob pattern, long start) throws SQLException

Description:

Retrieves the byte position in the BLOB value designated by this Blob object at which pattern begins. The search begins at position start.

Parameters:

pattern

Type: Blob 

the Blob object designating the BLOB value for which to search

start

the position in the BLOB value at which to begin searching; the first position is 1

Returns:

the position at which the pattern begins, else -1

Throws:

SQLException - if a database access error occurs, start < 1, or pattern is null

References:

For more information, reference JDBC documentation for: Blob.position(Blob, long)