ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From soussou97 <dbousse...@yahoo.fr>
Subject RE: Scanning byte array
Date Mon, 02 Oct 2006 08:19:53 GMT

Hi Christopher ;

OK for your example but imagined that you do not have of documents but of
data, so firstly  to get the data out of the table as into the example  :
 
connection = this.getConnection(); 
statement = connection.prepareStatement("select data from 
DATASTORE where ID = ?"); 
statement.setObject(1, primaryKey); 
byte[] documentData = null; 
ResultSet result = statement.executeQuery(); 
 if (result.next()) { 
   Data = result.getBytes(1); 
} 

Next you make how to extract the data inside of array (which can be :
integer, string, etc...) ?

Regards;


Christopher.Mathrusse wrote:
> 
> 
> 
> 
> 
> 
> When I was working with Oracle and needed to store XML 
> documents in the database I defined the column type as LONG RAW. Then I
> was able 
> to stream the data into the table by using the following: 
> &nbsp; 
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PreparedStatement 
> statement = connection.prepareStatement("insert into DOCUMENTSTORE 
> values(?,?)"); 
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ByteArrayInputStream 
> stream = new 
> ByteArrayInputStream(documentData); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

> statement.setBinaryStream(1, stream, 
> documentData.length); 
> To get the data out of the&nbsp;table I 
> used the following: 
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connection = 
> this.getConnection(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statement =

> connection.prepareStatement("select DOCUMENT from DOCUMENTSTORE where ID = 
> ?"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statement.setObject(1, 
> primaryKey); 
> &nbsp; 
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;byte[] documentData 
> = null; 
> &nbsp; 
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet result = 
> statement.executeQuery(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if
> (result.next()) 
> { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; documentData
= 
> result.getBytes(1); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
> } 
> &nbsp; 
> &nbsp; 
> 
> 
> From: soussou97 &lt;dboussebha@yahoo.fr&gt; 
> [mailto:soussou97 &lt;dboussebha@yahoo.fr&gt;] Sent: Friday, 
> September 29, 2006 5:16 AM To: 
> user-java@ibatis.apache.org Subject: Scanning byte 
> array 
> Hi; I have a method which return a byte array from a BLOB 
> (Oracle) : public static byte[] getBLOB(int id, Connection conn) throws 
> Exception { ResultSet rs = null; PreparedStatement pstmt = null; 
> String query = "SELECT data FROM Table1 WHERE id = ?"; try { pstmt = 
> conn.prepareStatement(query); pstmt.setInt(1, id); rs = 
> pstmt.executeQuery(); rs.next(); Blob blob = rs.getBlob(1); return 
> blob.getBytes(1, (int) blob.length()); } finally { rs.close(); 
> pstmt.close(); conn.close(); } } } I must to 
> scan the byte array position by position for extracting of the data 
> contained into this array for a display in using a GUI. Which is the best 
> (performance) solution to implemente this ? Regards; -- 
> View this message in context: 
> http://www.nabble.com/Scanning-byte-array-tf2356548.html#a6563833 Sent
> from 
> the iBATIS - User - Java mailing list archive at Nabble.com. 
> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Scanning-byte-array-tf2356548.html#a6597501
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message