I am having the same problem...
A BMP entity bean with CMT.
I turn off autocommit when I connect to the Oracle 8i (8.1.5) database.
The Transaction never seems to complete.
If I turn on autocommit, then the data is updated but cannot be rolled back by
the transaction manager in the case of an error.
In either case, I dont think that the Transaction ever commits.
Tim Haley
"Guy Rouillier" <[EMAIL PROTECTED]> on 04/06/2001 03:23:24 PM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: [JBoss-user] Oracle 8i
Sounds like your change is being made but not committed. What type of EJB
is this? Are you managing your own transaction? Are you turning autocommit
off?
----- Original Message -----
From: "Simphoukham, Southin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 12:32 PM
Subject: [JBoss-user] Oracle 8i
> Hi,
>
> Has anyone run into problems on making an update to an Oracle table?
>
> I have run into such a problem. I have created a preparedStatement and
> called the preparedStatement.excuteUpdate. The update returns a value of
1
> (which is good). I turn around and check to make sure it works in
SQLPlus.
> Wrong. I turn on the loggingenable option in the Mbean in the jcml.
> Everything looks good though the logging doesn't tell me if it actually
> excuted and committed the changes to Oracle. I know I can definitely
> retrieve using Jboss's connection pool saving ummm.
> oh yes I also copy the sql and pasted in SQLPlus and excuted it. That
> worked.
>
> Thanks,
>
> Southin Simphoukham
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user