Hello,
I work with Jboss 3.2.5
My table (on SQL Server 2000) contains 2 columns with smallmoney (or money) type.
if I create a bean with one column setted, no problem.
if I create a bean with the two columns setted:
ljReglementHome.create(..., new BigDecimal("100100.444"), new
BigDecimal("123456.12"), ...);
the Server generates the following exception:
17:37:46,477 ERROR [LogInterceptor] TransactionRolledbackLocalException in method:
public abstract vldsintegrator.objetspersistants.resultats.LjArticle
vldsintegrator.objetspersistants.resultats.LjArticleHome.create(java.lang.String,java.lang.String,java.lang.String,java.sql.Timestamp,java.lang.String,java.lang.Integer,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Byte,java.lang.String,java.lang.Short,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Byte,java.lang.Byte,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Integer,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.sql.Timestamp,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal,java.math.BigDecimal)
throws javax.ejb.CreateException, causedBy:
|
| java.lang.ArrayIndexOutOfBoundsException
|
| at java.lang.System.arraycopy(Native Method)
|
| at com.microsoft.jdbc.sqlserver.tds.TDSRPCParameter.write(Unknown Source)
|
| at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown Source)
|
| at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
|
| at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
|
| at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
|
| at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
|
| at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:335)
|
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.executeInsert(JDBCAbstractCreateCommand.java:328)
|
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:286)
|
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)
|
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:562)
|
| at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:203)
|
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
|
| at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:576)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1061)
|
| at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
|
| at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:204)
|
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
|
| at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
|
| at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
|
| 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:315)
|
| at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:128)
|
| at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:94)
|
| 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:478)
|
| at org.jboss.ejb.Container.invoke(Container.java:743)
|
| at
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:294)
|
| at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
|
| at $Proxy76.create(Unknown Source)
|
| at
vldsintegrator.objetsmetiers.GestionResultatsBean.majJournalArticle(GestionResultatsBean.java:240)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
|
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
|
| at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
|
| at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
|
| at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
|
| at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
|
| at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120)
|
| at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
|
| at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
|
| at
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
|
| at org.jboss.ejb.Container.invoke(Container.java:723)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at
org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
|
| at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
|
| at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
|
| at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
|
| at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
|
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
|
| at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
|
| at sun.rmi.transport.Transport$1.run(Transport.java:148)
|
| at java.security.AccessController.doPrivileged(Native Method)
|
| at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
|
| at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
|
| at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
|
| at java.lang.Thread.run(Thread.java:534)
|
|
The next call to the create method generates the following exception on the server
side:
| java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
by peer: socket write error
|
| at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
|
| at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
|
| at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
|
| at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown Source)
|
| at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown Source)
|
| at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
|
| at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
|
| at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
|
| at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
|
| at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:314)
|
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:79)
|
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:136)
|
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:562)
|
| at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:203)
|
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
|
| at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:576)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1061)
|
| at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
|
| at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:204)
|
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
|
| at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
|
| at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
|
| 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:315)
|
| at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:128)
|
| at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:94)
|
| 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:478)
|
| at org.jboss.ejb.Container.invoke(Container.java:743)
|
| at
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:294)
|
| at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
|
| at $Proxy76.create(Unknown Source)
|
| at
vldsintegrator.objetsmetiers.GestionResultatsBean.majJournalArticle(GestionResultatsBean.java:240)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
|
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
|
| at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
|
| at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
|
| at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
|
| at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
|
| at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120)
|
| at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
|
| at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
|
| at
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
|
| at org.jboss.ejb.Container.invoke(Container.java:723)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at
org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
|
| at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
|
| at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
|
| at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
|
| at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
|
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
|
| at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360)
|
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:324)
|
| at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
|
| at sun.rmi.transport.Transport$1.run(Transport.java:148)
|
| at java.security.AccessController.doPrivileged(Native Method)
|
| at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
|
| at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
|
| at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
|
| at java.lang.Thread.run(Thread.java:534)
|
Is there a bug with the money type in jboss ?
thanks in advance for any workaround
FranÃois
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844424#3844424
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844424
-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
