Hi All,
I've got a wierd error message coming from a CMP Entity Bean. The
Client app simply does a findByPrimaryKey, then it calls a couple of get
mutators, and then exits. The client seems to be getting the data out of
the database just fine, but sometime during the find, I'm getting an
SQLException on the server. After the error occurs, I have to completely
shutdown jboss and restart it in order to connect again. I'm using HP's
JDBC Driver for Allbase and IMAGE/SQL, which is a type 3 driver. I have a
feeling that the JDBC Driver may not be playing nice. I had to make a
small change to JdbcProvider.java just to get it to load correctly. It
seems that the version of the JDBC Driver that ships with MPE/ix 6.0 is
build using the oldy-moldy jdk 1.1.7 (i think), and therefore requires a
DriverManager.setLogStream deprecated api to be called in JdbcProvider.java
before the driver loads. Based on the errors in my server.log does anybody
have any other speculations as to why I'm getting these errors, or do you
agree that it is probably the JDBC Driver? Thanks in advance for any insight!
Server Log Snippets:
[Info] Java version: 1.3.0,Sun Microsystems Inc.
[Info] Java VM: Java HotSpot(TM) Server VM 1.3.0,Sun Microsystems Inc.
[Info] System: Linux 2.2.14-5.0,i386
(...snip...)
[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:jdbc.idbDriver
[JDBC] Loaded JDBC-driver:com.hp.jdbc.allbase.JdbcDriver
(...snip...)
[XADataSource] Starting
[XADataSource] XA Connection pool TurboIMAGE bound to TurboIMAGE
[XADataSource] Started
(...snip...)
[Auto deployer] Starting
[Auto deploy] Auto deploy of file:/usr/java/jBoss/deploy/TestStudent.jar
[Container factory] Deploying:file:/usr/java/jBoss/deploy/TestStudent.jar
[Container factory] Loading ejb-jar.xml :
jar:file:/usr/java/jBoss/tmp/deploy/tmpejbjar7778.jar!/META-INF/ejb-jar.xml
[Container factory] Loading standardjboss.xml :
jar:file:/usr/java/jBoss/lib/ext/jboss.jar!/org/jboss/metadata/standardjboss.xml
[Container factory]
jar:file:/usr/java/jBoss/tmp/deploy/tmpejbjar7778.jar!/META-INF/jboss.xml
found. Overriding defaults
[Verifier] Verifying file:/usr/java/jBoss/tmp/deploy/tmpejbjar7778.jar
[EmbededTomcat] PoolTcpConnector: Starting HttpConnectionHandler on 8080
[Verifier] Student: Verified.
[Container factory] Deploying Student
[Container factory] Container Invoker Optimize='false'
[JAWS] Initializing JAWS plugin for Student
[JAWS] Loading standardjaws.xml :
jar:file:/usr/java/jBoss/lib/ext/jboss.jar!/org/jboss/ejb/plugins/jaws/metadata/standardjaws.xml
[JAWS]
jar:file:/usr/java/jBoss/tmp/deploy/tmpejbjar7778.jar!/META-INF/jaws.xml
found. Overriding defaults
[Container factory] Bound Student to test/Student
[Container factory] Deployed application:
file:/usr/java/jBoss/deploy/TestStudent.jar
[Default] jBoss 2.0 BETA-PROD-PRE-03 Started
(....snip..... ((this is the error during the first call to database)) )
[Student] java.sql.SQLException: Statement has been closed!
[Student] at
org.jboss.minerva.jdbc.StatementInPool.getResultSetType(StatementInPool.java:248)
[Student] at
org.jboss.minerva.xa.XAClientConnection.statementClosed(XAClientConnection.java:108)
[Student] at
org.jboss.minerva.jdbc.PreparedStatementInPool.close(PreparedStatementInPool.java:421)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:165)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.findByPrimaryKey(JDBCFindEntityCommand.java:83)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:59)
[Student] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(JAWSPersistenceManager.java:130)
[Student] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:206)
[Student] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:405)
[Student] at java.lang.reflect.Method.invoke(Native Method)
[Student] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[Student] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:156)
[Student] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:86)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[Student] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:126)
[Student] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[Student] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[Student] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[Student] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[Student] at java.lang.reflect.Method.invoke(Native Method)
[Student] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[Student] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[Student] at java.security.AccessController.doPrivileged(Native Method)
[Student] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[Student] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[Student] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[Student] at java.lang.Thread.run(Thread.java:484)
[Student] java.sql.SQLException: Statement has been closed!
[Student] at
org.jboss.minerva.jdbc.StatementInPool.getResultSetType(StatementInPool.java:248)
[Student] at
org.jboss.minerva.xa.XAClientConnection.statementClosed(XAClientConnection.java:108)
[Student] at
org.jboss.minerva.jdbc.PreparedStatementInPool.close(PreparedStatementInPool.java:421)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:165)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:77)
[Student] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistenceManager.java:150)
[Student] at
org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:277)
[Student] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:188)
[Student] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:204)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[Student] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:144)
[Student] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
[Student] at
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:316)
[Student] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:222)
[Student] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:187)
[Student] at java.lang.reflect.Method.invoke(Native Method)
[Student] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[Student] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[Student] at java.security.AccessController.doPrivileged(Native Method)
[Student] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[Student] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[Student] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[Student] at java.lang.Thread.run(Thread.java:484)
(.....snip.....(((this is the error the second time a call is made))))
[Student] java.sql.SQLException: Error returned by DBMS.
(0/1,0) No previously prepared INSERT, UPDATE, DELETE, or SELECT.
[Student] at
com.hp.jdbc.allbase.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:217)
[Student] at
com.hp.jdbc.allbase.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:302)
[Student] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:155)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.findByPrimaryKey(JDBCFindEntityCommand.java:83)
[Student] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:59)
[Student] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(JAWSPersistenceManager.java:130)
[Student] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:206)
[Student] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:405)
[Student] at java.lang.reflect.Method.invoke(Native Method)
[Student] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[Student] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:156)
[Student] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:86)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[Student] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[Student] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:126)
[Student] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[Student] at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[Student] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[Student] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[Student] at java.lang.reflect.Method.invoke(Native Method)
[Student] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[Student] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[Student] at java.security.AccessController.doPrivileged(Native Method)
[Student] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[Student] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[Student] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[Student] at java.lang.Thread.run(Thread.java:484)
[JAWS] java.sql.SQLException: Error returned by DBMS.
[JAWS] (0/1,0) No previously prepared INSERT, UPDATE, DELETE, or SELECT.
[JAWS] at
com.hp.jdbc.allbase.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:217)
[JAWS] at
com.hp.jdbc.allbase.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:302)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:70)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:155)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCommand.execute(JDBCBeanExistsCommand.java:46)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.findByPrimaryKey(JDBCFindEntityCommand.java:83)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:59)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(JAWSPersistenceManager.java:130)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:206)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:405)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:585)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:156)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:86)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:126)
[JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:309)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:207)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:153)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
[JAWS] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
[JAWS] at java.lang.Thread.run(Thread.java:484)
Michael G. Drew
Kishwaukee College
Interface Programmer
[EMAIL PROTECTED]
(815) 825-2086 ext. 595
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
