Re: Problem with connection pool

[Christopher Schultz <ch...@christopherschultz.net>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris,

On 4/30/2011 6:58 AM, chris derham wrote:
> Finally managed to track the problem down to nested transactions -
> apparently spring doesn't support them. Once removed the problem went away

Glad you got it figured out. What is a "nested transaction"? Just
something like this:

BEGIN;
BEGIN;
UPDATE;
COMMIT;
DELETE;
COMMIT;

?

JDBC4 actually does support something like this: they are called
"savepoints". Read the JavaDocs for java.sql.Connection and search for
that string: it sounds like the capability you are trying to use there.

Then, of course, you'll have to figure out how to use them with Spring.
But, if Spring provides you with a java.sql.Connection object, you can
use savepoints directly. If not, maybe there's an API that you can
use... now that you know what the term is called.

Good luck,
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk2+wr4ACgkQ9CaO5/Lv0PDqAQCggFZDRdvD/SwG9lpYQN0Zvfgc
gcoAn36LsZH1PPRGgpRWWN1+nfHxiwBB
=VArQ
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org