The log.trace stuff is probably a weird problem with inner/outer class method/field visibility. Some jdks compile this code fine and won't execute it;-(((((((
I don't know why the autocommit stuff is not working consistently: probably I wrote it with some bugs. Is there any way you could come up with a testcase for it we could put in the test suite?
ok I will look into this
I wonder if I can reproduce this with hsql
I had the same effect 6 monthe ago with oracle8i and JBoss-2.4.3. What for a driver do you use ? Thin ? native ?
I could not reproduce the problem with HSQL yesterday.
I am using the thin drivers from classes12.zip (oracle 8.1.6).
I wrote a test MBean that performs a straight insert into a table -> no issues
My insert is only different in that I am using a sequence to generate the pk.
My problem somehow went away when I added some code to read sequence.currval after the insert.
I will verify this with a new test mbean to see if this could be the problem.
I had the same problem with JBoss-2.4.3 and Oracle8.1.6 with the same oracle thin 8.1.6 JDBC driver.
First of all, change for the new thin 8.1.7 oracle driver, or try to use the 8.1.7 native driver.
I had the same problem with EJB CMP.