Hello,
We have run into an issue running against Oracle10g. When attempting to upload
an entry into the CMS that is larger than 64K, we are seeing the errors below.
This occurs when uploading a single file or an archive via CMSAdminPortlet or
when doing an XML import via JackRabbit. It is particularly nasty in that it
seems to hose the entire DataSource (see the Close Connection exceptions
below)?an app server restart is required. Files less than 64K aren?t a
problem. I?ve tried various file types, a couple of different driver versions,
and two different database instances just to be sure.
I can run the same server instance against MySQL and everything works fine.
Any ideas?
(using v2.4 final (source download bundle), JBoss AS 4.0.4GA, Oracle 10g
(10.2.0.1.), Oracle thin JDBC Driver version "10.2.0.2.0", JDK 1.5.0, WindowsXP)
Thanks in advance,
Jerry
2006-09-26 11:39:34,796 ERROR
[org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize
database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
...
Caused by: java.sql.BatchUpdateException: Io exception: Read error
at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:517)
...
2006-09-26 11:39:34,828 ERROR
[org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager] failed to
read binary data:
957f3585-a275-46e6-ae4e-1967fbe9acad/{http://www.jcp.org/jcr/1.0}data[0]
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
Caused by: java.sql.BatchUpdateException: Io exception: Read error
at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:517)
...
2006-09-26 11:39:34,843 ERROR
[org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager] failed to
write property state:
957f3585-a275-46e6-ae4e-1967fbe9acad/{http://www.jcp.org/jcr/1.0}data
org.apache.jackrabbit.core.state.ItemStateException: failed to read binary
data: 957f3585-a275-46e6-ae4e-1967fbe9acad/{http://www.jcp.org/jcr/1.0}data[0]
at
org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager$DbBLOBStore.get(HibernatePersistenceManager.java:1011)
at
org.apache.jackrabbit.core.state.util.Serializer.serialize(Serializer.java:219)
at
org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager.store(HibernatePersistenceManager.java:624)
...
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC
batch update
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
Caused by: java.sql.BatchUpdateException: Io exception: Read error
at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:517)
...
2006-09-26 11:39:34,906 INFO [STDOUT] Hibernate: select wspnode0_.NODE_DATA as
col_0_0_ from jbp_cms_wsp_node wspnode0_ where NODE_ID=?
2006-09-26 11:39:34,906 ERROR [org.hibernate.util.JDBCExceptionReporter] Closed
Connection
2006-09-26 11:39:34,906 ERROR
[org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager] failed to
read node state: 89035540-55a3-4b20-95a6-7264a7ab1799
org.hibernate.exception.GenericJDBCException: could not execute query
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
Caused by: java.sql.SQLException: Closed Connection
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:849)
...
2006-09-26 11:39:34,921 ERROR
[org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager] failed to
read property state:
89035540-55a3-4b20-95a6-7264a7ab1799/{http://www.jcp.org/jcr/1.0}lastModified
org.hibernate.exception.GenericJDBCException: could not execute query
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
Caused by: java.sql.SQLException: Closed Connection
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:849)
...
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3974325#3974325
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3974325
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
