1 Reply Latest reply on Apr 2, 2002 10:35 AM by Andreas Kilian

    TransactionRolledbackException on 'getConnection()'

    Andreas Kilian Newbie

      Hello,
      I'm using JBoss 2.4.4 with MS SQL Server 2000 and
      the MS SQL Server 2000 JDBC Driver Beta 2 (latest, I think).
      Everytime I access the database in my BMP beans, I call this code in a method:


      Context ctx = new InitialContext();
      DataSource ds = (javax.sql.DataSource) ctx.lookup("java:/SQLServerDS");
      return ds.getConnection();


      After a view calls, i get the following exception:


      java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
      javax.transaction.TransactionRolledbackException: null
      Embedded Exception
      null; nested exception is:
      javax.ejb.EJBException: nested exception is: java.lang.NullPointerException
      at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:292)
      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:536)
      at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)
      at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
      at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:133)
      at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invokeHome(Unknown Source)
      at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:258)
      at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182)
      at $Proxy4.findByUserIDAndDate(Unknown Source)
      at com.pst.phoenix.client.models.TimeTableModel.loadTimeData(TimeTableModel.java:49)
      at com.pst.phoenix.client.modules.timerecording.TimeRecordingMainFrame.dateSelectionChanged(TimeRecordingMainFrame.java:136)
      at com.pst.phoenix.client.modules.timerecording.TimeRecordingMainFrame.access$000(TimeRecordingMainFrame.java:19)
      at com.pst.phoenix.client.modules.timerecording.TimeRecordingMainFrame$1.propertyChange(TimeRecordingMainFrame.java:64)
      at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:252)


      I've already been searching the web but I haven't found anything.
      Does anyone have an idea what I do wrong?

      Regards,
      Andreas Kilian