File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes Inserting Image into Oracle. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Inserting Image into Oracle." Watch "Inserting Image into Oracle." New topic
Author

Inserting Image into Oracle.

Joseph Hatton
Greenhorn

Joined: Dec 12, 2002
Posts: 20
Since the image is coming in as a byte array, the "insert" statement wouldn't make sense since I am building the SQL String in Java and would make a messy conversion and storing the "image" as blob in the Oracle database.
I am inserting an image in a round-about way.
Here is the code:
//Pass the ResultSet(rs) to this method.
//The sql is "select image from image_table where chgbk_id=12345
try{
BLOB blob = ((OracleResultSet)rs).getBLOB(1);
String imageData = getTransactionData(transIndex).getString(IChgbkModel.IMAGE);
if(imageData==null){
throw new Exception("Image data is null.");
}
ImageModel image = new ImageModel(imageData);
InputStream instream = new ByteArrayInputStream(image.getImageData());
OutputStream outstream = blob.getBinaryOutputStream();
int size = blob.getBufferSize();
byte[] buffer = new byte[size];
int length = -1;

/**
* Use the read() method to read the GIF file to the byte array buffer,
* then use the write() method to write it to the BLOB. When you finish,
* close the input and output streams.
*/
while ((length = instream.read(buffer)) != -1){
outstream.write(buffer, 0, length);
}
instream.close();
outstream.close();
}
catch(Exception exc){
throw new DatasourceException("Error when trying to update Image BLOB data.", exc);
}

When this code is applied to Connection Pooling in WebSphere 4.0.3 server it doesn't like the "OracleResultSet" object I am using. I get this error:
java.lang.ClassCastException: com.ibm.ejs.cm.proxy.ResultSetProxy
Any help would be appreciated.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Inserting Image into Oracle.
 
Similar Threads
Facing problem in loading embadded image from xls sheet into oracle database
ClassCastException when casting my resultset to OracleResultSet
java.sql.sqlexception data size bigger than max size for this type
Reading From a Binary Large Object(BLOB)
uploading image into oracle database through servlet