Hi,
I have some problems with DBCP in Tomcat 4.1.24 to save something in a BLOB field in
Oracle.
Usually I write this code
String ls_sql_I = "select blobField from table1";
Statement stmt = myConnection.getStatement();
ResultSet rs = prst.executeQuery();
rs.next();
BLOB blob = ((OracleResultSet)rs).getBLOB(1);
FileInputStream inStream = new FileInputStream(file);
OutputStream outStream = blob.getBinaryOutputStream();
int size = blob.getBufferSize();
byte[] buffer = new byte[size];
int length = -1;
while ((length = inStream.read(buffer)) != -1)
outStream.write(buffer, 0, length);
inStream.close();
outStream.close();
but I catch this exception:
java.lang.ClassCastException: org.apache.commons.dbcp.DelegatingResultSet
It's possible to save a blob field in Oracle without OracleResultSet?
Or it's possible to configure Tomcat to use a Oracle DataSource, and not DBCP?
Many thanks in advance,
Marco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
