This content has been marked as final.
Show 7 replies
-
1. Re: using autocommit true in ejb
adrian.brock Jan 16, 2004 7:33 AM (in response to _solo_)"adrian@jboss.org" wrote:
"adrian@jboss.org" wrote:
Mark your ejb method as NotSupported.
You cannot use AutoCommit inside a managed transaction.
NotSupported means there is not transaction.
Make sure you drop the temporary table. Remember with a connection pool,
connection.close() does not really close the connection. It just makes it available
for others to use.
Regards,
Adrian -
2. Re: using autocommit true in ejb
_solo_ Jan 16, 2004 7:44 AM (in response to _solo_)"_solo_" wrote:
"_solo_" wrote:
yes. I understood this.
but can I set AutoCommit(true)?
if it has affect at next using this connection? -
3. Re: using autocommit true in ejb
adrian.brock Jan 16, 2004 7:54 AM (in response to _solo_)"adrian@jboss.org" wrote:
"adrian@jboss.org" wrote:
AutoCommit == true
is the default for connections retrieved from the DataSource outside a transaction.
But yes, you can set it to true to make sure ;-)
Regards,
Adrian -
4. Re: using autocommit true in ejb
adrian.brock Jan 16, 2004 7:57 AM (in response to _solo_)"adrian@jboss.org" wrote:
"adrian@jboss.org" wrote:
The pool keeps track of the AutoCommit.
Some jdbc drivers (usually XA drivers) don't like using connections inside and outside
a transaction.
If you have this problem you can make jboss use two internal pools by
adding
<no-tx-separate-pool> in your -ds.xml
One pool is for transaction work, the other for non-transactional work.
Regards,
Adrian -
5. Re: using autocommit true in ejb
_solo_ Jan 16, 2004 9:00 AM (in response to _solo_)"_solo_" wrote:
"_solo_" wrote:
thanks.
but from what version of jboss can be using param
no-tx-separate-pool ?
i found it in exmple of 3.2.2 jboss , but we use 2.4.10. -
6. Re: using autocommit true in ejb
adrian.brock Jan 16, 2004 11:28 AM (in response to _solo_)"adrian@jboss.org" wrote:
"adrian@jboss.org" wrote:
I couldn't tell you about 2.4.10, it uses a completley different pooling implementation.
Regards,
Adrian -
7. Re: using autocommit true in ejb
_solo_ Jan 17, 2004 2:55 AM (in response to _solo_)"_solo_" wrote:
"_solo_" wrote:
thanks for your answers.
you make clear this question for me very much.
Best Regards
Andrew