db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henning P. Schmiedehausen" <...@intermeta.de>
Subject Re: Auto Commit + Transaction Problems
Date Tue, 21 Dec 2004 09:38:26 GMT
Thomas Fischer <Fischer@seitenbau.net> writes:

>Hi,

>Some pools can test connections before they give it to the end user (in
>this case Torque). This is done by executing a simple query like "select
>sysdate from dual". If the connections are not auto commit, this is the
>first query in the transaction, and it is not possible to use any "set
>transaction..." commands afterwards.

>do you only use the methods (save()...)without connection, or do you also
>use methods that need a connection (save(connection)...) or custom queries
>?
>What Pool are you using (see your runtime configuration) ?

There is also a configuration option which allows the OID generator to
use a separate connection. (However this would happen outside the
Transaction).

	Regards
		Henning

-- 
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
hps@intermeta.de        +49 9131 50 654 0   http://www.intermeta.de/

RedHat Certified Engineer -- Jakarta Turbine Development  -- hero for hire
   Linux, Java, perl, Solaris -- Consulting, Training, Development

What is more important to you...
   [ ] Product Security
or [ ] Quality of Sales and Marketing Support
              -- actual question from a Microsoft customer survey

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message