TransactionRolledbackException on 'getConnection()'
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