-
1. Re: JDBC Insert Data Not Commited
mremond Dec 16, 2004 6:06 AM (in response to auzi)I am encountering the same problem. Insert of data (used with prepared statement) do not end up in the database.
Do you have found any answer on your problem ? -
2. Re: JDBC Insert Data Not Commited
hariv Dec 16, 2004 9:38 AM (in response to auzi)May be the connection has auto commit set to false once you pull from the connection poll. Try printing the value for the Auto Commit and check. If it is set to false call commit at the end of the transaction
-
3. Re: JDBC Insert Data Not Commited
mremond Dec 16, 2004 10:03 AM (in response to auzi)I was wondering if JBoss 4.0 was not doing things in by back with some kind of optimisation-related interceptors. Could the problem be related to prepared statement pooling ? Has the behaviour regarding prepared statement changed between JBoss 3.x and JBoss 4 ?
-
4. Re: JDBC Insert Data Not Commited
aloubyansky Dec 17, 2004 5:03 AM (in response to auzi)You should not touch auto-commit in a managed environment. Application server will commit local transaction when the global one is committed.
-
5. Re: JDBC Insert Data Not Commited
mremond Dec 17, 2004 5:09 AM (in response to auzi)"alex.loubyansky@jboss.com" wrote:
You should not touch auto-commit in a managed environment. Application server will commit local transaction when the global one is committed.
Ok. That what I thought. JBoss is acting as a wrapper regarding JDBC activity and transactions.
Now, what I would like to know what could be the reason for a write not to be committed to the database ? How to debug this stuff in Jboss ? What are the Jboss parameters to make less intrusive ?
Thank you for your help
--
Mickaël Rémond -
6. Re: JDBC Insert Data Not Commited
aloubyansky Dec 19, 2004 11:13 AM (in response to auzi)This is not JBoss-specific behaviour, this is the spec. auto-commit is set to false in a managed environment. I think, you should be able to reproduce this with pure JDBC standalone app and find out what's wrong.
-
7. Re: JDBC Insert Data Not Commited
mremond Dec 19, 2004 11:35 AM (in response to auzi)"alex.loubyansky@jboss.com" wrote:
This is not JBoss-specific behaviour, this is the spec. auto-commit is set to false in a managed environment. I think, you should be able to reproduce this with pure JDBC standalone app and find out what's wrong.
I know.
Something in the application prevent it from reading the result of inserts.
I am asking that because an application that was previously working in JBoss 3.x does no more work in 4.0. So I am assuming that some default behaviour have changed. But until now, I did not manage to figure out precisely what has changed.
I have seen nothing in the JBoss wiki (JBoss4FAQ) regarding those topics.
--
Mickaël -
8. Re: JDBC Insert Data Not Commited
aloubyansky Dec 19, 2004 12:32 PM (in response to auzi)Try JCA forum. Maybe Adrian can help you.