jboss 2.4 and SQL Server
kjelln Sep 7, 2001 9:29 AMHi,
I'm curenly trying out jboss 2.4.0 ( upgrading from 2.2.1 as we want to try the jboss scheduler) but have problems to get a cmp entity bean to work ( the first one testet).
We use SQL Server 2001, and the bean works when deployed in jboss 2.2.1.
We have update the 3 of the entries in standardjaws.xml
for SQL Server as follows:
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
<sql-type>REAL</sql-type>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>FLOAT</sql-type>
Any ideas anyone ?
Tia, Kjell N.
Error message:
[OrderBeanEB] Activated bean OrderBeanEB with id = 1
[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(JdbcOdbc.java:6031)
[JAWS] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
[JAWS] at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(JdbcOdbc.java:3171)
[JAWS] at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(JdbcOdbcResultSet.java:5317)
[JAWS] at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:548)
[JAWS] at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1622)
[JAWS] at org.jboss.pool.jdbc.ResultSetInPool.getObject(ResultSetInPool.java:554)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:405)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:504)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.loadOneEntity(JDBCLoadEntityCommand.java:219)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.handleResult(JDBCLoadEntityCommand.java:176)
[JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(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.execute(JDBCLoadEntityCommand.java:147)
[JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistenceManager.java:156)
[JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:365)
[JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:263)
[JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:256)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
[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(JRMPContainerInvoker.java:393)
[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)