I think this will work for you:
Connection con = null;
try
{
con = Transaction.begin(dbName);
// do you work
Transaction.commit(con);
}
catch(TorqueException e)
{
Transaction.safeRollback(con);
throw e;
}
Ev
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Turbine Torque Users List" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 4:43 PM
Subject: Torque conn pooling - second db?
>
> Hello all, is there a way to have Torque pool and manage connections to a
> second schema that's not in an O/R model and has a different login/pw/sid?
> Ideally I'm just looking for something lazy like:
>
> Connection myConn = Torque.getConn('db2name');
>
> but I imagine life is rarely that easy ...
> -j
>
> -------------------------------------------------
> James Diggans
> Bioinformatics Programmer
> Gene Logic, Inc.
> Phone: 301.987.1756
> FAX: 301.987.1701
>
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
