Just to follow up on this, the settings below work - but HSQLDB doesn't seem to support nested transactions.
<<< beginning the transaction >>> DBTest >> javax.transaction.NotSupportedException: Nested transactions not suppo rted at org.objectweb.jotm.Current.begin(Current.java:233) at foo.DBTest.init(DBTest.java:30) at org.apache.jsp.test_jsp._jspService(org.apache.jsp.test_jsp:54) The DBTest class is from the JOTM + Tomcat example at http://jotm.objectweb.org/current/jotm/doc/howto-tomcat-jotm.html. Changing to use MySQL solves the problem and everything works great. Also, it looks like JOTM (or maybe Carol) has issues with JDK 5. I googled for the following error and it appears to be known about on the ObjectWeb mailing lists - but there doesn't seem to be a documented solution. java.lang.NoSuchMethodError: sun.rmi.transport.ObjectTable.getStub(Ljava/rmi/Remote;)Ljava/rmi/server/RemoteStub; org.objectweb.carol.rmi.jrmp.server.JUnicastRemoteObject.unexportObject(JUnicastRemoteObject.java:138) org.objectweb.carol.rmi.multi.JrmpPRODelegate.unexportObject(JrmpPRODelegate.java:107) org.objectweb.carol.rmi.multi.MultiPRODelegate.unexportObject(MultiPRODelegate.java:107) javax.rmi.PortableRemoteObject.unexportObject(PortableRemoteObject.java:119) org.objectweb.jotm.SubCoordinator.doAfterCompletion(SubCoordinator.java:1584) org.objectweb.jotm.SubCoordinator.doRollback(SubCoordinator.java:1370) org.objectweb.jotm.SubCoordinator.rollback(SubCoordinator.java:330) org.objectweb.jotm.TransactionImpl.rollback(TransactionImpl.java:668) org.objectweb.jotm.Current.rollback(Current.java:538) foo.DBTest.init(DBTest.java:50) org.apache.jsp.test_jsp._jspService(org.apache.jsp.test_jsp:54) Thanks, Matt On 2/8/06, Remy Maucherat <[EMAIL PROTECTED]> wrote: > Since you're doing docs, META-INF/context.xml should be simplified to: > <Context> > > <Resource name="jdbc/myDB" auth="Container" type="javax.sql.DataSource" > factory="org.objectweb.jndi.DataSourceFactory" > driverClassName="org.hsqldb.jdbcDriver" > username="sa" password="" > url="jdbc:hsqldb:."/> > > <Transaction factory="org.objectweb.jotm.UserTransactionFactory" > jotm.timeout="60"/> > > </Context> > > No servlet class reloading anymore (not useful to many people), and > the Transaction element has all the necessary defaults since it's a > special resource. > > -- > xxxxxxxxxxxxxxxxxxxxxxxxx > Rémy Maucherat > Developer & Consultant > JBoss Group (Europe) SàRL > xxxxxxxxxxxxxxxxxxxxxxxxx > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]