RE: AW: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested
Hi, The Bug report at https://sourceforge.net/tracker/?func=detailatid=376687aid=729719group_id=22866has a patch available in which the standard-jbosscmp-jdbc.xml has both jdbc-type mappings as follows :- mapping java-typejava.lang.Short/java-type jdbc-typeNUMERIC/jdbc-type jdbc-typeSMALLINT/jdbc-type sql-typeNUMBER(5)/sql-type/mapping This does not work with Oracle Client 9.2.0.4.When I had just one jdbc-type mapping of SMALLINT, it worked. Any clues about whether this patch is right ? Also does this patch work with Oracle client 9.2.0.1 ? regards, Shubhu"Rupp, Heiko" [EMAIL PROTECTED] wrote: Hi, there is a bug report open on this (#729719) https://sourceforge.net/tracker/?func=detailatid=376687aid=729719group_id=22866 Can you confirm/verify the solution from there? Heiko -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED]im Auftrag vonshubhu mutta Gesendet: Mo 05.01.2004 09:35 An: [EMAIL PROTECTED] Cc: Betreff: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested Hi, I updated my Oracle Client from 9.2.0.1 to 9.2.0.4. Jboss is 3.2.0. After that I tried to execute my application and got this in server.log: javax.ejb.EJBException: Internal error setting parameters for field status; CausedByException is: Invalid conversion requested java.sql.SQLException: Invalid conversion requested at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:607) at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter(JDBCUtil.java:280) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setArgumentParameters(JDBCAbstractCMPFieldBridge.java:301) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setInstanceParameters(JDBCAbstractCMPFieldBridge.java:280) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.insertEntity(JDBCCreateEntityCommand.java:285) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:182) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:569) at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:225) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270) at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:725) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91) at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74) at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92) at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477) at org.jboss.ejb.Container.invoke(Container.java:694) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80) at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82) at $Proxy194.create(Unknown Source) at home.create(uow); All worked fine before the Oracle update. The exception is thrown when setting the value for a EJB-Field of type Short. The default typemapping for Oracle9i is choosen (NUMERIC/NUMBER(5) (
RE: AW: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested
As I understand, this is Oracle's new feature that is not backward compatible and resulted in a bug in JBossCMP default type mapping that is fixed now. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of shubhu muttaSent: Friday, January 09, 2004 5:47 AMTo: [EMAIL PROTECTED]Subject: Re: AW: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested Hi Heiko, Is this a bug with Oracle or withJBoss ? Does Oracle Client 9.2.0.4 work well with other App. Servers without makingchanges in the Data type mapping ? regards, Shubhu"Rupp, Heiko" [EMAIL PROTECTED] wrote: Hi, there is a bug report open on this (#729719) https://sourceforge.net/tracker/?func=detailatid=376687aid=729719group_id=22866 Can you confirm/verify the solution from there? Heiko -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED]im Auftrag vonshubhu mutta Gesendet: Mo 05.01.2004 09:35 An: [EMAIL PROTECTED] Cc: Betreff: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested Hi, I updated my Oracle Client from 9.2.0.1 to 9.2.0.4. Jboss is 3.2.0. After that I tried to execute my application and got this in server.log: javax.ejb.EJBException: Internal error setting parameters for field status; CausedByException is: Invalid conversion requested java.sql.SQLException: Invalid conversion requested at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:607) at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter(JDBCUtil.java:280) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setArgumentParameters(JDBCAbstractCMPFieldBridge.java:301) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setInstanceParameters(JDBCAbstractCMPFieldBridge.java:280) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.insertEntity(JDBCCreateEntityCommand.java:285) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:182) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:569) at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:225) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270) at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:725) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91) at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74) at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92) at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477) at org.jboss.ejb.Container.invoke(Container.java:694) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoke
Re: AW: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested
Hi Heiko, Is this a bug with Oracle or withJBoss ? Does Oracle Client 9.2.0.4 work well with other App. Servers without makingchanges in the Data type mapping ? regards, Shubhu"Rupp, Heiko" [EMAIL PROTECTED] wrote: Hi, there is a bug report open on this (#729719) https://sourceforge.net/tracker/?func=detailatid=376687aid=729719group_id=22866 Can you confirm/verify the solution from there? Heiko -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED]im Auftrag vonshubhu mutta Gesendet: Mo 05.01.2004 09:35 An: [EMAIL PROTECTED] Cc: Betreff: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested Hi, I updated my Oracle Client from 9.2.0.1 to 9.2.0.4. Jboss is 3.2.0. After that I tried to execute my application and got this in server.log: javax.ejb.EJBException: Internal error setting parameters for field status; CausedByException is: Invalid conversion requested java.sql.SQLException: Invalid conversion requested at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:607) at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter(JDBCUtil.java:280) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setArgumentParameters(JDBCAbstractCMPFieldBridge.java:301) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setInstanceParameters(JDBCAbstractCMPFieldBridge.java:280) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.insertEntity(JDBCCreateEntityCommand.java:285) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:182) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:569) at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:225) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270) at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:725) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91) at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74) at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92) at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477) at org.jboss.ejb.Container.invoke(Container.java:694) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80) at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82) at $Proxy194.create(Unknown Source) at home.create(uow); All worked fine before the Oracle update. The exception is thrown when setting the value for a EJB-Field of type Short. The default typemapping for Oracle9i is choosen (NUMERIC/NUMBER(5) ( specified in standarjaws.xml,standardjbosscmp-jdbc.xml). Has anybody encountered this problem ? Is it a bug with Oracle Client 9.2.0.4 ? My datasource definition is like this datasources local-tx-datasource jndi-nameOracleDS/jndi-name !--connection-urljdbc:oracle:thin:@(protected):1521:TEMP/connection-url-- connection-urljdbc:oracle:oci8:@bplin32/connection-url
AW: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested
Hi, there is a bug report open on this (#729719) https://sourceforge.net/tracker/?func=detailatid=376687aid=729719group_id=22866 Can you confirm/verify the solution from there? Heiko -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED]im Auftrag vonshubhu mutta Gesendet: Mo 05.01.2004 09:35 An: [EMAIL PROTECTED] Cc: Betreff: [JBoss-user] JBoss 3.2.4 and Oracle9i: SQLException: Invalid conversion requested Hi, I updated my Oracle Client from 9.2.0.1 to 9.2.0.4. Jboss is 3.2.0. After that I tried to execute my application and got this in server.log: javax.ejb.EJBException: Internal error setting parameters for field status; CausedByException is: Invalid conversion requested java.sql.SQLException: Invalid conversion requested at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:607) at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter(JDBCUtil.java:280) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setArgumentParameters(JDBCAbstractCMPFieldBridge.java:301) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setInstanceParameters(JDBCAbstractCMPFieldBridge.java:280) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.insertEntity(JDBCCreateEntityCommand.java:285) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:182) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:569) at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:225) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270) at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:725) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91) at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74) at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92) at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477) at org.jboss.ejb.Container.invoke(Container.java:694) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80) at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82) at $Proxy194.create(Unknown Source) at home.create(uow); All worked fine before the Oracle update. The exception is thrown when setting the value for a EJB-Field of type Short. The default typemapping for Oracle9i is choosen (NUMERIC/NUMBER(5) ( specified in standarjaws.xml,standardjbosscmp-jdbc.xml). Has anybody encountered this problem ? Is it a bug with Oracle Client 9.2.0.4 ? My datasource definition is like this datasources local-tx-datasource jndi-nameOracleDS/jndi-name !--connection-urljdbc:oracle:thin:@(protected):1521:TEMP/connection-url--