I assume it's a problem with the type mapping. The interclient jar
sometimes has problems with even simple SQL statements you can execute
in the IB console.
E.g., if you are using longs in your CMP Entities chances are that
interclient will throw SQLExceptions.
You can turn on the debug-flag in
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand on, so you can see the SQL
statements that are created.
--
/// Dirk.
achandra writes:
> has anyone tried using interbase and jboss ?
> can you tell me why every time a client tried to getxxx from a cmp bean
> jboss always give this error (see below)
> i am using JBoss PRE2.1 from the cvs at feb 16, 2001 and interclient 1.60
> and i already set the jaws.xml type mapping to InterBase
> and the findxxx method work just fine
> and i am using java class as a primary key
>
> thanks in advance,
> adam
>
> [J2EE Deployer Default] Create application user.jar
> [J2EE Deployer Default] install module user.jar
> [J2EE Deployer Default] Starting module user.jar
> [Container factory]
> Deploying:file:/C:/jboss/tmp/deploy/Default/user.jar/ejb10
> 03.jar
> [Verifier] Verifying file:/C:/jboss/tmp/deploy/Default/user.jar/ejb1003.jar
> [Container factory] Deploying User
> [Container factory] Deploying Group
> [Container factory] Deploying Features
> [Container factory] Deploying Usergroup
> [Container factory] Deploying Userfeature
> [Container factory] Deploying Ejb
> [Container factory] Deploying EJBGroup
> [Container factory] Deploying login
> [Container factory] Deploying validasi
> [Container factory] SELECT userid FROM TBLUSERFEATURES
> [Container factory] SELECT groupid,ejbid FROM TBLEJBGroup
> [Container factory] SELECT groupid FROM TBLGROUP
> [Container factory] SELECT userid,userpassword FROM TBLUSER
> [Container factory] SELECT userid FROM TBLUSERGROUP
> [Container factory] SELECT ejbid FROM TBLEJB
> [Container factory] SELECT featuresid FROM TBLFEATURES
> [Container factory] Deployed application:
> file:/C:/jboss/tmp/deploy/Default/us
> er.jar/ejb1003.jar
> [J2EE Deployer Default] J2EE application: file:/C:/jboss/deploy/user.jar is
> de
> ployed.
> [User] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception is:
> java.sql.SQLException: Unable to create PreparedStatement!; nested
> excep
> tion is:
> java.rmi.ServerException: Load failed; nested exception is:
> java.sql.SQLException: Unable to create PreparedStatement!
> [User] java.rmi.ServerException: Load failed; nested exception is:
> [User] java.sql.SQLException: Unable to create PreparedStatement!
> [User] java.sql.SQLException: Unable to create PreparedStatement!
> [User] at
> org.opentools.minerva.jdbc.xa.wrapper.XAClientConnection.prepareState
> ment(XAClientConnection.java:169)
> [User] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.j
> ava:158)
> [User] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoa
> dEntityCommand.java:78)
> [User] at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPers
> istenceManager.java:150)
> [User] at
> org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistence
> Manager.java:328)
> [User] at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntityS
> ynchronizationInterceptor.java:192)
> [User] at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstance
> Interceptor.java:186)
> [User] at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.ja
> va:133)
> [User] at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
> torCMT.java:263)
> [User] at
> org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:9
> 9)
> [User] at
> org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.
> java:137)
> [User] at
> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
> [User] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323)
> [User] at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPCon
> tainerInvoker.java:384)
> [User] at java.lang.reflect.Method.invoke(Native Method)
> [User] at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [User] at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [User] at java.security.AccessController.doPrivileged(Native Method)
> [User] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [User] at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4
> 43)
> [User] at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport
> .java:643)
> [User] at java.lang.Thread.run(Thread.java:484)
>
>
