Anyboy catch error with jboss-2.4.x-tomcat-3.2.3 when using MS Sql Server: can't load the entity, find works, just can't load, the error message is: java.rmi.ServerException: Load failed; nested exception is: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
Can anybody help? thanks a lot. David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 12:33 AM To: [EMAIL PROTECTED] Subject: [JBoss-dev] [ jboss-Bugs-459443 ] deexternalization problem Bugs item #459443, was opened at 2001-09-07 00:32 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=459443&group _id=22866 Category: JBossCMP Group: v2.4 (stable) Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: deexternalization problem Initial Comment: I cannot read externalized data back from database using jboss2.4 Still, if I write into database using jboss-2.4.0- tomcat-3.2.3 I can read back using jboss-2.2.2-tomcat- 3.2.2 without problems. I'm using MS SQL server 7.0 with jdbc-odbc bridge (from jdk1.3.1) Table contains 2 fields: id integer -- 32 bit mydata image -- BLOB in other databases MyBean is CMP Entity: public class MyBean implements EntityBean { public int id; public MyDataMarshaller mydata; ... } id class is: public class PKint implements java.io.Serializable { public int id; ... } mydata class is: public class MyDataMarshaller implements java.io.Externalizable { ... public void writeExternal( ObjectOutput out )throws IOException{ out.write( 3 ); ... } public void readExternal ( ObjectInput in ) throws IOException, ClassNotFoundException{ int i = in.read(); ... } } deployment is solely described in ejb-jar.xml Writing the bean goes ok, but the read fails: I read using findAll(); then I get iterator and first bean from iterator and when I'm trying to get MyDataMarshaller from MyBean the exception goes: Note: I have read the "[JAWS] Got a [B: '[B@5f75d8' while looking for a com.mypackage.MyDataMarshaller" line in the log file too using JBoss_2.2.2- tomcat_3.2.2 which works ok [JAWS] findAll command executing: SELECT id FROM MyTable [MyTable] Activated bean MyTable with id = MyTablePK [207726] 'MyTablePK[207726]' printed from toString() [JAWS] Load command executing: SELECT MyTable.id,MyTable.mydata FROM MyTable WHERE id=? [JAWS] Set parameter: idx=1, jdbcType=INTEGER, value=207726 [JAWS] Got a [B: '[B@5f75d8' while looking for a com.mypackage.MyDataMarshaller [JAWS] Unable to read from ResultSet: java.lang.reflect.InvocationTargetException [JAWS] java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index [JAWS] at sun.jdbc.odbc.JdbcOdbc.createSQLException (Unknown Source) [JAWS] at sun.jdbc.odbc.JdbcOdbc.standardError (Unknown Source) [JAWS] at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger (Unknown Source) [JAWS] at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(Unknown Source) [JAWS] at sun.jdbc.odbc.JdbcOdbcResultSet.getInt (Unknown Source) [JAWS] at sun.jdbc.odbc.JdbcOdbcResultSet.getObject (Unknown Source) [JAWS] at org.jboss.pool.jdbc.ResultSetInPool.getObject (ResultSetInPool.java:554) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultOb ject(JDBCCommand.java :405) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultOb ject(JDBCCommand.java :504) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.l oadOneEntity(JDBCLoad EntityCommand.java:219) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.h andleResult(JDBCLoadE ntityCommand.java:176) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.execut eStatementAndHandleRe sult(JDBCQueryCommand.java:59) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute (JDBCCommand.java:160 ) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.e xecute(JDBCLoadEntity Command.java:147) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadE ntity(JAWSPersistence Manager.java:156) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity (CMPPersistenceManager .java:365) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor. invoke(EntitySynchron izationInterceptor.java:263) [JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke (EntityInstanceInterce ptor.java:256) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext (TxInterceptorCMT.java:133) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti ons(TxInterceptorCMT. java:307) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke (TxInterceptorCMT.java:99) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke (SecurityInterceptor.java:12 8) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke (LogInterceptor.java:195) [JAWS] at org.jboss.ejb.EntityContainer.invoke (EntityContainer.java:349) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker. invoke(JRMPContainerI nvoker.java:483) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invo keContainer(GenericPr oxy.java:335) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invok e(EntityProxy.java:13 3) [JAWS] at $Proxy30.getMarshaller(Unknown Source) [JAWS] at mypackage.MyEvent.onMessage(***.java:77) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.MessageDrivenContainer$ContainerIntercept or.invoke(MessageDriv enContainer.java:400) [JAWS] at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor. invoke(MessageDrivenI nstanceInterceptor.java:58) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext (TxInterceptorCMT.java:133) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti ons(TxInterceptorCMT. java:307) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke (TxInterceptorCMT.java:99) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke (SecurityInterceptor.java:12 8) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke (LogInterceptor.java:195) [JAWS] at org.jboss.ejb.MessageDrivenContainer.invoke (MessageDrivenContainer.java:281) [JAWS] at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke (JMSContainerInvoker.jav a:150) [JAWS] at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageLi stenerImpl.onMessage( JMSContainerInvoker.java:495) [JAWS] at org.jbossmq.SpyMessageConsumer.deliverMessage (SpyMessageConsumer.java:296) [JAWS] at org.jbossmq.SpySession.run (SpySession.java:218) [JAWS] at org.jboss.jms.asf.StdServerSession.run (StdServerSession.java:132) [JAWS] at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker. run(PooledExecutor.ja va:642) [JAWS] at java.lang.Thread.run(Unknown Source) ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=459443&group _id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
