<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <!-- NewPage --> <html lang="en"> <head> <!-- Generated by javadoc (1.8.0_181) on Thu Sep 20 00:34:31 UTC 2018 --> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JDBCBlobClient (HSQLDB 2.4.0 API)</title> <meta name="date" content="2018-09-20"> <link rel="stylesheet" type="text/css" href="../../../stylesheet.css" title="Style"> <script type="text/javascript" src="../../../script.js"></script> </head> <body> <script type="text/javascript"><!-- try { if (location.href.indexOf('is-external=true') == -1) { parent.document.title="JDBCBlobClient (HSQLDB 2.4.0 API)"; } } catch(err) { } //--> var methods = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10,"i7":10,"i8":10,"i9":10,"i10":10,"i11":10,"i12":10,"i13":10,"i14":10}; var tabs = {65535:["t0","All Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]}; var altColor = "altColor"; var rowColor = "rowColor"; var tableTab = "tableTab"; var activeTableTab = "activeTableTab"; </script> <noscript> <div>JavaScript is disabled on your browser.</div> </noscript> <!-- ========= START OF TOP NAVBAR ======= --> <div class="topNav"><a name="navbar.top"> <!-- --> </a> <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> <a name="navbar.top.firstrow"> <!-- --> </a> <ul class="navList" title="Navigation"> <li><a href="../../../overview-summary.html">Overview</a></li> <li><a href="package-summary.html">Package</a></li> <li class="navBarCell1Rev">Class</li> <li><a href="class-use/JDBCBlobClient.html">Use</a></li> <li><a href="package-tree.html">Tree</a></li> <li><a href="../../../deprecated-list.html">Deprecated</a></li> <li><a href="../../../index-all.html">Index</a></li> <li><a href="../../../help-doc.html">Help</a></li> </ul> </div> <div class="subNav"> <ul class="navList"> <li><a href="../../../org/hsqldb/jdbc/JDBCBlob.html" title="class in org.hsqldb.jdbc"><span class="typeNameLink">Prev Class</span></a></li> <li><a href="../../../org/hsqldb/jdbc/JDBCBlobFile.html" title="class in org.hsqldb.jdbc"><span class="typeNameLink">Next Class</span></a></li> </ul> <ul class="navList"> <li><a href="../../../index.html?org/hsqldb/jdbc/JDBCBlobClient.html" target="_top">Frames</a></li> <li><a href="JDBCBlobClient.html" target="_top">No Frames</a></li> </ul> <ul class="navList" id="allclasses_navbar_top"> <li><a href="../../../allclasses-noframe.html">All Classes</a></li> </ul> <div> <script type="text/javascript"><!-- allClassesLink = document.getElementById("allclasses_navbar_top"); if(window==top) { allClassesLink.style.display = "block"; } else { allClassesLink.style.display = "none"; } //--> </script> </div> <div> <ul class="subNavList"> <li>Summary: </li> <li>Nested | </li> <li>Field | </li> <li><a href="#constructor.summary">Constr</a> | </li> <li><a href="#method.summary">Method</a></li> </ul> <ul class="subNavList"> <li>Detail: </li> <li>Field | </li> <li><a href="#constructor.detail">Constr</a> | </li> <li><a href="#method.detail">Method</a></li> </ul> </div> <a name="skip.navbar.top"> <!-- --> </a></div> <!-- ========= END OF TOP NAVBAR ========= --> <!-- ======== START OF CLASS DATA ======== --> <div class="header"> <div class="subTitle">org.hsqldb.jdbc</div> <h2 title="Class JDBCBlobClient" class="title">Class JDBCBlobClient</h2> </div> <div class="contentContainer"> <ul class="inheritance"> <li>java.lang.Object</li> <li> <ul class="inheritance"> <li>org.hsqldb.jdbc.JDBCBlobClient</li> </ul> </li> </ul> <div class="description"> <ul class="blockList"> <li class="blockList"> <dl> <dt>All Implemented Interfaces:</dt> <dd>java.sql.Blob</dd> </dl> <hr> <br> <pre>public class <span class="typeNameLabel">JDBCBlobClient</span> extends java.lang.Object implements java.sql.Blob</pre> <div class="block">A wrapper for HSQLDB BlobData objects. Instances of this class are returned by calls to ResultSet methods.</div> <dl> <dt><span class="simpleTagLabel">Since:</span></dt> <dd>1.9.0</dd> <dt><span class="simpleTagLabel">Author:</span></dt> <dd>Fred Toussi (fredt@users dot sourceforge.net)</dd> </dl> </li> </ul> </div> <div class="summary"> <ul class="blockList"> <li class="blockList"> <!-- ======== CONSTRUCTOR SUMMARY ======== --> <ul class="blockList"> <li class="blockList"><a name="constructor.summary"> <!-- --> </a> <h3>Constructor Summary</h3> <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation"> <caption><span>Constructors</span><span class="tabEnd"> </span></caption> <tr> <th class="colOne" scope="col">Constructor and Description</th> </tr> <tr class="altColor"> <td class="colOne"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#JDBCBlobClient-org.hsqldb.SessionInterface-org.hsqldb.types.BlobDataID-">JDBCBlobClient</a></span>(org.hsqldb.SessionInterface session, org.hsqldb.types.BlobDataID blob)</code> </td> </tr> </table> </li> </ul> <!-- ========== METHOD SUMMARY =========== --> <ul class="blockList"> <li class="blockList"><a name="method.summary"> <!-- --> </a> <h3>Method Summary</h3> <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation"> <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span></caption> <tr> <th class="colFirst" scope="col">Modifier and Type</th> <th class="colLast" scope="col">Method and Description</th> </tr> <tr id="i0" class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#clearUpdates--">clearUpdates</a></span>()</code> </td> </tr> <tr id="i1" class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#free--">free</a></span>()</code> <div class="block">This method frees the <code>Blob</code> object and releases the resources that it holds.</div> </td> </tr> <tr id="i2" class="altColor"> <td class="colFirst"><code>java.io.InputStream</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#getBinaryStream--">getBinaryStream</a></span>()</code> <div class="block">Retrieves the <code>BLOB</code> value designated by this <code>Blob</code> instance as a stream.</div> </td> </tr> <tr id="i3" class="rowColor"> <td class="colFirst"><code>java.io.InputStream</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#getBinaryStream-long-long-">getBinaryStream</a></span>(long pos, long length)</code> <div class="block">Returns an <code>InputStream</code> object that contains a partial <code>Blob</code> value, starting with the byte specified by pos, which is length bytes in length.</div> </td> </tr> <tr id="i4" class="altColor"> <td class="colFirst"><code>org.hsqldb.types.BlobDataID</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#getBlob--">getBlob</a></span>()</code> </td> </tr> <tr id="i5" class="rowColor"> <td class="colFirst"><code>byte[]</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#getBytes-long-int-">getBytes</a></span>(long pos, int length)</code> <div class="block">Retrieves all or part of the <code>BLOB</code> value that this <code>Blob</code> object represents, as an array of bytes.</div> </td> </tr> <tr id="i6" class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#isClosed--">isClosed</a></span>()</code> </td> </tr> <tr id="i7" class="rowColor"> <td class="colFirst"><code>long</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#length--">length</a></span>()</code> <div class="block">Returns the number of bytes in the <code>BLOB</code> value designated by this <code>Blob</code> object.</div> </td> </tr> <tr id="i8" class="altColor"> <td class="colFirst"><code>long</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#position-java.sql.Blob-long-">position</a></span>(java.sql.Blob pattern, long start)</code> <div class="block">Retrieves the byte position in the <code>BLOB</code> value designated by this <code>Blob</code> object at which <code>pattern</code> begins.</div> </td> </tr> <tr id="i9" class="rowColor"> <td class="colFirst"><code>long</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#position-byte:A-long-">position</a></span>(byte[] pattern, long start)</code> <div class="block">Retrieves the byte position at which the specified byte array <code>pattern</code> begins within the <code>BLOB</code> value that this <code>Blob</code> object represents.</div> </td> </tr> <tr id="i10" class="altColor"> <td class="colFirst"><code>java.io.OutputStream</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#setBinaryStream-long-">setBinaryStream</a></span>(long pos)</code> <div class="block">Retrieves a stream that can be used to write to the <code>BLOB</code> value that this <code>Blob</code> object represents.</div> </td> </tr> <tr id="i11" class="rowColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#setBytes-long-byte:A-">setBytes</a></span>(long pos, byte[] bytes)</code> <div class="block">Writes the given array of bytes to the <code>BLOB</code> value that this <code>Blob</code> object represents, starting at position <code>pos</code>, and returns the number of bytes written.</div> </td> </tr> <tr id="i12" class="altColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#setBytes-long-byte:A-int-int-">setBytes</a></span>(long pos, byte[] bytes, int offset, int len)</code> <div class="block">Writes all or part of the given <code>byte</code> array to the <code>BLOB</code> value that this <code>Blob</code> object represents and returns the number of bytes written.</div> </td> </tr> <tr id="i13" class="rowColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#setWritable-org.hsqldb.jdbc.JDBCResultSet-int-">setWritable</a></span>(<a href="../../../org/hsqldb/jdbc/JDBCResultSet.html" title="class in org.hsqldb.jdbc">JDBCResultSet</a> result, int index)</code> </td> </tr> <tr id="i14" class="altColor"> <td class="colFirst"><code>void</code></td> <td class="colLast"><code><span class="memberNameLink"><a href="../../../org/hsqldb/jdbc/JDBCBlobClient.html#truncate-long-">truncate</a></span>(long len)</code> <div class="block">Truncates the <code>BLOB</code> value that this <code>Blob</code> object represents to be <code>len</code> bytes in length.</div> </td> </tr> </table> <ul class="blockList"> <li class="blockList"><a name="methods.inherited.from.class.java.lang.Object"> <!-- --> </a> <h3>Methods inherited from class java.lang.Object</h3> <code>equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li> </ul> </li> </ul> </li> </ul> </div> <div class="details"> <ul class="blockList"> <li class="blockList"> <!-- ========= CONSTRUCTOR DETAIL ======== --> <ul class="blockList"> <li class="blockList"><a name="constructor.detail"> <!-- --> </a> <h3>Constructor Detail</h3> <a name="JDBCBlobClient-org.hsqldb.SessionInterface-org.hsqldb.types.BlobDataID-"> <!-- --> </a> <ul class="blockListLast"> <li class="blockList"> <h4>JDBCBlobClient</h4> <pre>public JDBCBlobClient(org.hsqldb.SessionInterface session, org.hsqldb.types.BlobDataID blob)</pre> </li> </ul> </li> </ul> <!-- ============ METHOD DETAIL ========== --> <ul class="blockList"> <li class="blockList"><a name="method.detail"> <!-- --> </a> <h3>Method Detail</h3> <a name="length--"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>length</h4> <pre>public long length() throws java.sql.SQLException</pre> <div class="block">Returns the number of bytes in the <code>BLOB</code> value designated by this <code>Blob</code> object.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>length</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>length of the <code>BLOB</code> in bytes</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the length of the <code>BLOB</code></dd> </dl> </li> </ul> <a name="getBytes-long-int-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>getBytes</h4> <pre>public byte[] getBytes(long pos, int length) throws java.sql.SQLException</pre> <div class="block">Retrieves all or part of the <code>BLOB</code> value that this <code>Blob</code> object represents, as an array of bytes.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>getBytes</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>pos</code> - the ordinal position of the first byte in the <code>BLOB</code> value to be extracted; the first byte is at position 1</dd> <dd><code>length</code> - the number of consecutive bytes to be copied</dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>a byte array containing up to <code>length</code> consecutive bytes from the <code>BLOB</code> value designated by this <code>Blob</code> object, starting with the byte at position <code>pos</code></dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code> value</dd> </dl> </li> </ul> <a name="getBinaryStream--"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>getBinaryStream</h4> <pre>public java.io.InputStream getBinaryStream() throws java.sql.SQLException</pre> <div class="block">Retrieves the <code>BLOB</code> value designated by this <code>Blob</code> instance as a stream.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>getBinaryStream</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>a stream containing the <code>BLOB</code> data</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code> value</dd> </dl> </li> </ul> <a name="position-byte:A-long-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>position</h4> <pre>public long position(byte[] pattern, long start) throws java.sql.SQLException</pre> <div class="block">Retrieves the byte position at which the specified byte array <code>pattern</code> begins within the <code>BLOB</code> value that this <code>Blob</code> object represents.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>position</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>pattern</code> - the byte array for which to search</dd> <dd><code>start</code> - the position at which to begin searching; the first position is 1</dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>the position at which the pattern appears, else -1</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code></dd> </dl> </li> </ul> <a name="position-java.sql.Blob-long-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>position</h4> <pre>public long position(java.sql.Blob pattern, long start) throws java.sql.SQLException</pre> <div class="block">Retrieves the byte position in the <code>BLOB</code> value designated by this <code>Blob</code> object at which <code>pattern</code> begins.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>position</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>pattern</code> - the <code>Blob</code> object designating the <code>BLOB</code> value for which to search</dd> <dd><code>start</code> - the position in the <code>BLOB</code> value at which to begin searching; the first position is 1</dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>the position at which the pattern begins, else -1</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code> value</dd> </dl> </li> </ul> <a name="setBytes-long-byte:A-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>setBytes</h4> <pre>public int setBytes(long pos, byte[] bytes) throws java.sql.SQLException</pre> <div class="block">Writes the given array of bytes to the <code>BLOB</code> value that this <code>Blob</code> object represents, starting at position <code>pos</code>, and returns the number of bytes written.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>setBytes</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>pos</code> - the position in the <code>BLOB</code> object at which to start writing</dd> <dd><code>bytes</code> - the array of bytes to be written to the <code>BLOB</code> value that this <code>Blob</code> object represents</dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>the number of bytes written</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code> value</dd> </dl> </li> </ul> <a name="setBytes-long-byte:A-int-int-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>setBytes</h4> <pre>public int setBytes(long pos, byte[] bytes, int offset, int len) throws java.sql.SQLException</pre> <div class="block">Writes all or part of the given <code>byte</code> array to the <code>BLOB</code> value that this <code>Blob</code> object represents and returns the number of bytes written.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>setBytes</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>pos</code> - the position in the <code>BLOB</code> object at which to start writing</dd> <dd><code>bytes</code> - the array of bytes to be written to this <code>BLOB</code> object</dd> <dd><code>offset</code> - the offset into the array <code>bytes</code> at which to start reading the bytes to be set</dd> <dd><code>len</code> - the number of bytes to be written to the <code>BLOB</code> value from the array of bytes <code>bytes</code></dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>the number of bytes written</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code> value</dd> </dl> </li> </ul> <a name="setBinaryStream-long-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>setBinaryStream</h4> <pre>public java.io.OutputStream setBinaryStream(long pos) throws java.sql.SQLException</pre> <div class="block">Retrieves a stream that can be used to write to the <code>BLOB</code> value that this <code>Blob</code> object represents.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>setBinaryStream</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>pos</code> - the position in the <code>BLOB</code> value at which to start writing</dd> <dt><span class="returnLabel">Returns:</span></dt> <dd>a <code>java.io.OutputStream</code> object to which data can be written</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code> value</dd> </dl> </li> </ul> <a name="truncate-long-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>truncate</h4> <pre>public void truncate(long len) throws java.sql.SQLException</pre> <div class="block">Truncates the <code>BLOB</code> value that this <code>Blob</code> object represents to be <code>len</code> bytes in length.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>truncate</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>len</code> - the length, in bytes, to which the <code>BLOB</code> value that this <code>Blob</code> object represents should be truncated</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if there is an error accessing the <code>BLOB</code> value</dd> </dl> </li> </ul> <a name="free--"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>free</h4> <pre>public void free() throws java.sql.SQLException</pre> <div class="block">This method frees the <code>Blob</code> object and releases the resources that it holds. The object is invalid once the <code>free</code> method is called. <p> After <code>free</code> has been called, any attempt to invoke a method other than <code>free</code> will result in a <code>SQLException</code> being thrown. If <code>free</code> is called multiple times, the subsequent calls to <code>free</code> are treated as a no-op. <p></div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>free</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if an error occurs releasing the Blob's resources</dd> <dt><span class="simpleTagLabel">Since:</span></dt> <dd>JDK 1.6, HSQLDB 2.0</dd> </dl> </li> </ul> <a name="getBinaryStream-long-long-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>getBinaryStream</h4> <pre>public java.io.InputStream getBinaryStream(long pos, long length) throws java.sql.SQLException</pre> <div class="block">Returns an <code>InputStream</code> object that contains a partial <code>Blob</code> value, starting with the byte specified by pos, which is length bytes in length.</div> <dl> <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> <dd><code>getBinaryStream</code> in interface <code>java.sql.Blob</code></dd> <dt><span class="paramLabel">Parameters:</span></dt> <dd><code>pos</code> - the offset to the first byte of the partial value to be retrieved. The first byte in the <code>Blob</code> is at position 1</dd> <dd><code>length</code> - the length in bytes of the partial value to be retrieved</dd> <dt><span class="returnLabel">Returns:</span></dt> <dd><code>InputStream</code> through which the partial <code>Blob</code> value can be read.</dd> <dt><span class="throwsLabel">Throws:</span></dt> <dd><code>java.sql.SQLException</code> - if pos is less than 1 or if pos is greater than the number of bytes in the <code>Blob</code> or if pos + length is greater than the number of bytes in the <code>Blob</code></dd> <dt><span class="simpleTagLabel">Since:</span></dt> <dd>JDK 1.6, HSQLDB 2.0</dd> </dl> </li> </ul> <a name="isClosed--"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>isClosed</h4> <pre>public boolean isClosed()</pre> </li> </ul> <a name="getBlob--"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>getBlob</h4> <pre>public org.hsqldb.types.BlobDataID getBlob()</pre> </li> </ul> <a name="setWritable-org.hsqldb.jdbc.JDBCResultSet-int-"> <!-- --> </a> <ul class="blockList"> <li class="blockList"> <h4>setWritable</h4> <pre>public void setWritable(<a href="../../../org/hsqldb/jdbc/JDBCResultSet.html" title="class in org.hsqldb.jdbc">JDBCResultSet</a> result, int index)</pre> </li> </ul> <a name="clearUpdates--"> <!-- --> </a> <ul class="blockListLast"> <li class="blockList"> <h4>clearUpdates</h4> <pre>public void clearUpdates()</pre> </li> </ul> </li> </ul> </li> </ul> </div> </div> <!-- ========= END OF CLASS DATA ========= --> <!-- ======= START OF BOTTOM NAVBAR ====== --> <div class="bottomNav"><a name="navbar.bottom"> <!-- --> </a> <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div> <a name="navbar.bottom.firstrow"> <!-- --> </a> <ul class="navList" title="Navigation"> <li><a href="../../../overview-summary.html">Overview</a></li> <li><a href="package-summary.html">Package</a></li> <li class="navBarCell1Rev">Class</li> <li><a href="class-use/JDBCBlobClient.html">Use</a></li> <li><a href="package-tree.html">Tree</a></li> <li><a href="../../../deprecated-list.html">Deprecated</a></li> <li><a href="../../../index-all.html">Index</a></li> <li><a href="../../../help-doc.html">Help</a></li> </ul> </div> <div class="subNav"> <ul class="navList"> <li><a href="../../../org/hsqldb/jdbc/JDBCBlob.html" title="class in org.hsqldb.jdbc"><span class="typeNameLink">Prev Class</span></a></li> <li><a href="../../../org/hsqldb/jdbc/JDBCBlobFile.html" title="class in org.hsqldb.jdbc"><span class="typeNameLink">Next Class</span></a></li> </ul> <ul class="navList"> <li><a href="../../../index.html?org/hsqldb/jdbc/JDBCBlobClient.html" target="_top">Frames</a></li> <li><a href="JDBCBlobClient.html" target="_top">No Frames</a></li> </ul> <ul class="navList" id="allclasses_navbar_bottom"> <li><a href="../../../allclasses-noframe.html">All Classes</a></li> </ul> <div> <script type="text/javascript"><!-- allClassesLink = document.getElementById("allclasses_navbar_bottom"); if(window==top) { allClassesLink.style.display = "block"; } else { allClassesLink.style.display = "none"; } //--> </script> </div> <div> <ul class="subNavList"> <li>Summary: </li> <li>Nested | </li> <li>Field | </li> <li><a href="#constructor.summary">Constr</a> | </li> <li><a href="#method.summary">Method</a></li> </ul> <ul class="subNavList"> <li>Detail: </li> <li>Field | </li> <li><a href="#constructor.detail">Constr</a> | </li> <li><a href="#method.detail">Method</a></li> </ul> </div> <a name="skip.navbar.bottom"> <!-- --> </a></div> <!-- ======== END OF BOTTOM NAVBAR ======= --> <p class="legalCopy"><small><i>Copyright �� 2001 - 2017 HSQL Development Group.</i></small></p> </body> </html>