Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » JBoss User Help »

[jboss-user] [JCA/JBoss] - JBoss 4.0.4 java.sql.SQLException: No
 more data to read from

scott.stark@jboss.org

2007-08-07


We have 2 machines each with identical JBoss 4.0.4 Server and Oracle 10g installation.
We have an application (war file) installed on both the system.

When trying to insert data into oracle database from within the application, it works fine on one machine, however, on the 2nd machine we encountered the following error.

Oracle-ds.xml (for connection pooling) configuration on both the installation have identical configuration.


2007-08-07 11:15:43,078 DEBUG [org.jboss.web.tomcat.tc5.Tomcat5] Saw org.jboss.system.server.started notification, starting connectors
2007-08-07 11:15:43,093 INFO [org.apache.coyote.http11.Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
2007-08-07 11:15:43,218 INFO [org.apache.jk.common.ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
2007-08-07 11:15:43,234 INFO [org.apache.jk.server.JkMain] Jk running ID=0 time=0/94 config=null
2007-08-07 11:15:43,234 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000)] Started in 22s:297ms
2007-08-07 11:17:19,000 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807
2007-08-07 11:17:19,000 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: about to notify thread: old next: 1186457089000, new next: 1186457089000
2007-08-07 11:17:40,015 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@(protected)]
java.sql.SQLException: No more data to read from socket
 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.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118)
 at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:478)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
 at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate (WrappedPreparedStatement.java:251)


Any help is appreciated.

Thanks in advance.
Regards,



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4071428#4071428

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4071428
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user
©2008 junlu.com - Jax Systems, LLC, U.S.A.