当数据有近1000条时，SessionBean 中的查询报错了(Jboss)，这样的数据量很大吗？

Question

JBOSS 报错，如下：  23:11:15,234 ERROR [LogInterceptor] TransactionRolledbackException in method: public abstract java.lang.String dyxx.TransinfoRemote.getSubstaid() throws java.rmi.RemoteException, causedBy:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(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:296)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:163)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:74)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:631)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:613)
at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:391)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:351)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:232)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:111)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:242)
at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:53)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:514)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:179)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:165)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
at org.jboss.proxy.ejb.EntityInterceptor.invoke(EntityInterceptor.java:97)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy169.getSubstaid(Unknown Source)
at dyxx.dyxxSessBean.getAllTransinfo(dyxxSessBean.java:353)
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:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:130)
at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
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:585)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)

Answer 1

23:11:15,296 INFO  [STDOUT] javax.transaction.TransactionRolledbackException: Load failed; CausedByException is:
[Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.; nested exception is: 
javax.ejb.EJBException: Load failed; CausedByException is:
[Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
23:11:15,296 INFO  [STDOUT]  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:244)
23:11:15,312 INFO  [STDOUT]  at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
23:11:15,312 INFO  [STDOUT]  at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
23:11:15,312 INFO  [STDOUT]  at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
23:11:15,312 INFO  [STDOUT]  at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
23:11:15,312 INFO  [STDOUT]  at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
23:11:15,312 INFO  [STDOUT]  at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:514)
23:11:15,312 INFO  [STDOUT]  at org.jboss.ejb.Container.invoke(Container.java:873)
23:11:15,312 INFO  [STDOUT]  at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
23:11:15,312 INFO  [STDOUT]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
23:11:15,328 INFO  [STDOUT]  at java.lang.reflect.Method.invoke(Method.java:585)
23:11:15,328 INFO  [STDOUT]  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
23:11:15,328 INFO  [STDOUT]  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
23:11:15,328 INFO  [STDOUT]  at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
23:11:15,328 INFO  [STDOUT]  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
23:11:15,328 INFO  [STDOUT]  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
23:11:15,328 INFO  [STDOUT]  at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
23:11:15,328 INFO  [STDOUT]  at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
23:11:15,328 INFO  [STDOUT]  at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:179)
23:11:15,328 INFO  [STDOUT]  at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:165)
23:11:15,328 INFO  [STDOUT]  at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
23:11:15,328 INFO  [STDOUT]  at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
23:11:15,328 INFO  [STDOUT]  at org.jboss.proxy.ejb.EntityInterceptor.invoke(EntityInterceptor.java:97)
23:11:15,343 INFO  [STDOUT]  at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
23:11:15,343 INFO  [STDOUT]  at $Proxy169.getSubstaid(Unknown Source)
23:11:15,343 INFO  [STDOUT]  at dyxx.dyxxSessBean.getAllTransinfo(dyxxSessBean.java:353)
23:11:15,343 INFO  [STDOUT]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
23:11:15,343 INFO  [STDOUT]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
23:11:15,343 INFO  [STDOUT]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
23:11:15,343 INFO  [STDOUT]  at java.lang.reflect.Method.invoke(Method.java:585)
23:11:15,343 INFO  [STDOUT]  at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
23:11:15,343 INFO  [STDOUT]  at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
23:11:15,359 INFO  [STDOUT]  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
23:11:15,359 INFO  [STDOUT]  at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:130)
23:11:15,359 INFO  [STDOUT]  at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
23:11:15,359 INFO  [STDOUT]  at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
23:11:15,375 INFO  [STDOUT]  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
23:11:15,375 INFO  [STDOUT]  at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
23:11:15,375 INFO  [STDOUT]  at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
23:11:15,375 INFO  [STDOUT]  at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
23:11:15,390 INFO  [STDOUT]  at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
23:11:15,390 INFO  [STDOUT]  at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
23:11:15,390 INFO  [STDOUT]  at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
23:11:15,390 INFO  [STDOUT]  at org.jboss.ejb.Container.invoke(Container.java:873)
23:11:15,390 INFO  [STDOUT]  at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
23:11:15,390 INFO  [STDOUT]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
23:11:15,390 INFO  [STDOUT]  at java.lang.reflect.Method.invoke(Method.java:585)
23:11:15,390 INFO  [STDOUT]  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
23:11:15,390 INFO  [STDOUT]  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
23:11:15,390 INFO  [STDOUT]  at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
23:11:15,390 INFO  [STDOUT]  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
23:11:15,390 INFO  [STDOUT]  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
23:11:15,390 INFO  [STDOUT]  at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
23:11:15,406 INFO  [STDOUT]  at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
23:11:15,406 INFO  [STDOUT]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
23:11:15,406 INFO  [STDOUT]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
23:11:15,406 INFO  [STDOUT]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
23:11:15,406 INFO  [STDOUT]  at java.lang.reflect.Method.invoke(Method.java:585)
23:11:15,406 INFO  [STDOUT]  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
23:11:15,406 INFO  [STDOUT]  at sun.rmi.transport.Transport$1.run(Transport.java:153)
23:11:15,406 INFO  [STDOUT]  at java.security.AccessController.doPrivileged(Native Method)
23:11:15,406 INFO  [STDOUT]  at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
23:11:15,421 INFO  [STDOUT]  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
23:11:15,421 INFO  [STDOUT]  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
23:11:15,421 INFO  [STDOUT]  at java.lang.Thread.run(Thread.java:595)

Answer 2

23:11:15,421 INFO  [STDOUT] Caused by: javax.ejb.EJBException: Load failed; CausedByException is:
[Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
23:11:15,421 INFO  [STDOUT]  at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:237)
23:11:15,421 INFO  [STDOUT]  at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:74)
23:11:15,421 INFO  [STDOUT]  at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:631)
23:11:15,421 INFO  [STDOUT]  at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:613)
23:11:15,421 INFO  [STDOUT]  at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:391)
23:11:15,421 INFO  [STDOUT]  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:351)
23:11:15,421 INFO  [STDOUT]  at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:232)
23:11:15,421 INFO  [STDOUT]  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
23:11:15,437 INFO  [STDOUT]  at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:111)
23:11:15,437 INFO  [STDOUT]  at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:242)
23:11:15,437 INFO  [STDOUT]  at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
23:11:15,437 INFO  [STDOUT]  at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:53)
23:11:15,437 INFO  [STDOUT]  at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
23:11:15,437 INFO  [STDOUT]  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
23:11:15,437 INFO  [STDOUT]  ... 64 more

Answer 3

SessinoBean 中的方法贴错了  public TransinfoDTO[] getAllTransinfo() {
    Collection coll = null;
    ArrayList array = new ArrayList();
    TransinfoDTO dto = new TransinfoDTO();//    Timestamp time = new Timestamp(2);
    try {
      coll = Transinfohome.findAllTransinfo();
      Iterator i = coll.iterator();
      while (i.hasNext()) {
        TransinfoRemote ejb = (TransinfoRemote) i.next();
        String linename = getLineName(ejb.getSubstaid(),ejb.getLineid());
            dto = new TransinfoDTO(ejb.getSubstaid()
                                   , ejb.getLineid()
                                   , ejb.getTransid()
                                   , ejb.getStatusflag()
                                   , ejb.getNousedate()
                                   , ejb.getNousedays()
                                   , ejb.getCharcomid()
                                   , ejb.getUsedate()
                                   , ejb.getTranstypeid()
                                   , ejb.getUsetype()
                                   , ejb.getTranscapa()                                   , ejb.getVoltagein()
                                   , ejb.getOiltype(),
                                   ejb.getTransname(), ejb.getCopyerid(),
                                   ejb.getFeeerid(),                                   ejb.getBooknum(), ejb.getTransaddr(),
                                   ejb.getProducecompany(), ejb.getProducecode(),
                                   ejb.getProducedate(),                                   ejb.getSparefield1(), ejb.getSparefield2(),
                                   ejb.getCompoint(),linename,ejb.getRating()
            ); //dto =new  TransinfoDTO End        array.add(dto);
      }
    }
    catch (RemoteException ex) {
      ex.printStackTrace();
    }
    catch (FinderException ex) {
      ex.printStackTrace();
    }
    return (TransinfoDTO[]) array.toArray(new TransinfoDTO[0]);
  }