Folks, all this discussion on BLOBs and slobs (:-) made me check our own
code which uses a BLOB.
Sure enough, it worked with a 2000 character string, but fell over with
the following exception with a 4000 char string.
15:44:28,664 ERROR [DeferredData] Could not create entity
java.sql.SQLException: Io exception: Connection reset
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2061)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at
org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeUpdate(LocalPreparedStatement.java:308)
However, now the connection has been reset, and all further use of it
causes failure.
Q: How can I have JBoss automatically recover from this situation?
Q: Can I manually re-open the connection when I catch the SQLException?
Is this proper behaviour?
Finally, we're using JBoss 3.0.4 with Oracle 9.2
Ciao,
Jonathan
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
