[JBoss Portal] - CMS errors on Oracle10g
by jlacy
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}lastModi...
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
19 years, 7 months