Re: [JBoss-user] Transaction Error

[Burkhard V. <Bur...@gm...>]

Hi,
try using the M$ SQL JDBC driver and see if anything changes... It here:
http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?ur
l=/MSDN-FILES/027/001/779/msdncompositedoc.xml
hth,
Burkhard
----- Original Message -----
From: "Tejeshwar" <tej...@wi...>
To: <jbo...@li...>
Sent: Monday, June 10, 2002 1:24 PM
Subject: [JBoss-user] Transaction Error


Hi

I am running JBOSS on windows 2000 with MS SQL Server as Database, when i
tried to insert 10000 records through CMP  Bean(sample Example) it's
inserting, but when i tried to search are delete the records by calling the
methods written in Bean. It;s giving the folllowing Error when i tried to
search or delete. For records of 1500 this error will not appear only for
more than 2000 records this shows error as shown below. Pls let me know
what's the problem.



[ERROR,CDBean] TRANSACTION ROLLBACK EXCEPTION:
javax.transaction.TransactionRolledbackException: Load failed; nested
exception is:
        java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid
Descriptor Index; nested exception is:
        java.rmi.ServerException: Load failed; nested exception is:
        java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid
Descriptor Index
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:188)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:347)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
        at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:12
7)
        at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
        at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:428)
        at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:504)
        at
org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(GenericPr
oxy.java:335)
        at
org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:13
3)
        at $Proxy9.getTitle(Unknown Source)
        at
org.jboss.docs.cmp.cd.bean.CDCollectionBean.lookupInAnyField(CDCollectionBea
n.java:154)
        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(Stateles
sSessionContainer.java:542)
        at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
ssionInstanceInterceptor.java:82)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:138)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:347)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
        at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:12
7)
        at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
        at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:286)
        at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:410)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        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:7
01)

Thanking you


with regards

Tejesh