Here's how I used Transactions with Torque (roughly):
Connection conn = null;
conn = Transaction.begin(DNISLookupTablePeer.DATABASE_NAME);
try
{
newRow.delete(conn); //call torque method
passing the connection
Transaction.commit(conn);
} catch (TorqueException e)
{
Transaction.safeRollback(conn); //ROLLBACK
}
Tobin Juday
Software Engineer
proud graduate of The Ohio State University
CheckFree Corporation
[EMAIL PROTECTED]
Phone: 614.564.4192
Pager: 877.546.0103
The #1 Way to Pay Online
http://www.mycheckfree.com/
|---------+---------------------------->
| | "Thomas J. |
| | Harris" |
| | <[EMAIL PROTECTED]|
| | om> |
| | |
| | 06/03/2003 03:16 |
| | PM |
| | Please respond to|
| | "Turbine Torque |
| | Users List" |
| | |
|---------+---------------------------->
>-----------------------------------------------------------------------------------------------------------------|
|
|
| To: "'Turbine Torque Users List'" <[EMAIL PROTECTED]>, "'eCommerce
Software Solutions Inc.'"|
| <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: RE: Transaction Isolation setting for Torque DB connections
|
>-----------------------------------------------------------------------------------------------------------------|
I'm trying to use Torque. I already have Hibernate working. As I said,
we're trying to run benchmarks, so I must use both in the same way.
Tom
-----Original Message-----
From: eCommerce Software Solutions Inc. [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 4:55 PM
To: Turbine Torque Users List; [EMAIL PROTECTED]
Subject: Re: Transaction Isolation setting for Torque DB connections
Try Hibernate on Google
----- Original Message -----
From: "Thomas J. Harris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 03, 2003 10:46 AM
Subject: Transaction Isolation setting for Torque DB connections
>
> Torque-users,
>
> Does anyone know how to set the transaction isolation level for the DB
> connections Torque uses?
>
> We are building a persistence layer benchmarking tool in-house to
> determine the most appropriate object-relational Java layer, JDBC
> driver, RDBMS, etc. The three Java DB layers we decided to try out
first
> were Torque, Hibernate, and Kodo JDO. In order for the benchmark to be
> useful, the transaction isolation level must be the same setting on
all
> the layers. I cannot determine how to set this setting anywhere, and I
> also do not know what the used level is in Torque. I simply cannot
find
> any documentation that describes how to set this important JDBC
setting.
> Can someone help? If I cannot set this value to something, we cannot
use
> Torque.
>
> Tom Harris
>
> ~--------------------------------------------------------~
> ~| Tom Harris - Cisco Systems - VTG - CCBU - CCIS - CEM |~
> ~| 23-85 27th Street, Second Floor - Astoria, NY 11105 |~
> ~|(718) 956-3310 - mailto:[EMAIL PROTECTED] |~
> ~| http://home.nyc.rr.com/tharrisx/ |~
> ~| http://wwwin-people.cisco.com/tharrisx/tharrisx.html |~
> ~--------------------------------------------------------~
>
>
------------------------------------------------------------------------
----
----
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
