[jboss-user] [JBoss Portal] - CMS errors on Oracle10g

jlacy do-not-reply at jboss.com
Tue Sep 26 15:20:41 EDT 2006 

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

More information about the jboss-user mailing list