db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jürgen Hoffmann ...@byteaction.de>
Subject Re: Torque with more dynamic DB connections, avoiding singleton and statics?
Date Mon, 05 Jan 2004 01:10:12 GMT
Hi,

AFAIK you cannot do that. there is one default class and thats it. BUT Nobody 
is stopping you to extend Torque and add a method setDefaultDb(String 
connection) and use your new class to initialize Torque.

If yu would want to, you could create some kind of registry within a 
hashtable, which would manage you different Torque Connections which each 
have a different properties file for each Torque Instance. 

Kind Regards

Jürgen Hoffmann

On Friday 02 January 2004 20:00, Ekkehard Kraemer wrote:
> On Thu, 1 Jan 2004 22:12:14 -0600, Jiaqi Guo <chinajoeblack@hotmail.com>
> wrote:
>
> Hello Jiaqi,
>
> > First it's possible to define more than one database connection for
> > torque like this:
> >
> > Torque.database.default=dsf1
> > Torque.dsfactory.dsf1.factory=..
> > .....
> > Torque.database.another=dsf2
> > Torque.dsfactory.dsf2.factory=..
> > .....
>
> Aye, I'm doing that already, works well.
>
> > At runtime you can call it dynamically:
> >
> > Connection dbcon1 = Torque.getConnection(); //Get a connection for
> > default database
> > Connection dbcon2 = Torque.getConnection("another");
>
> I'm doing that too, to get Connections which I then use directly (i.e.
> without using the Torque OM classes).
>
> But how do I instruct Torque to use dbcon2 instead of the default when
> using the Torque OM classes (i.e.,  "SomePeer.doSelect(crit)")?
>
> Thanks,
> Ekkehard
>
> > -----Original Message-----
> > From: Ekkehard Kraemer [mailto:ekraemer@pluto.camelot.de]
> > Sent: Wednesday, December 31, 2003 5:48 AM
> > To: torque-user@db.apache.org
> > Subject: Torque with more dynamic DB connections, avoiding singleton and
> > statics?
> >
> > Hello,
> >
> > is it possible to avoid the Torque singleton and static OM members
> > altogether?
> >
> > I have some quite dynamic needs for my DBMS connections. In the easiest
> > case, it boils down to being able to specify which of several databases
> > (defined in the standard Torque property file) to use during runtime.
> >
> > Ideally, I would do something like
> >
> >          for (Iterator i=SomePeer.doSelect(whichDb,crit).iterator();
> >               i.hasNext(); )
> >          {
> >              Some some=(Some)(i.next()); // some is from whichDb
> >              doSomething(some);
> >          }
> >
> > Or
> >
> >          TorqueInstance torq=new TorqueInstance(whichDb);
> >          for (Iterator i=SomePeer.doSelect(torq,crit).iterator();
> >               i.hasNext(); )
> >          ...
> >
> > Or
> >
> >          SomePeer somePeer=new SomePeer(whichDb);
> >          for (Iterator i=somePeer.doSelect(torq,crit).iterator();
> >               i.hasNext(); )
> >          ...
> >
> >
> > Where whichDb tells Torque which database should be used.
> >
> > While a TorqueInstance exists already, the generated OM classes contain
> > static members for the database name (and maybe other things). I see no
> > place to put the "whichDb" in.
> >
> > Any hint on whether this can be solved, and how? I didn't find much in
> > the documentation or the archives; and looking at the source code made me
> > suspect it is not possible at the moment. Am I wrong? Is this
> > functionality being planned for the future of Torque?
> >
> > Simply changing the "final static" members to "static" and overwriting
> > them as needed is probably not a solution for me, as the next step would
> > be to work on two different databases at the same time (with the same set
> > of OM classes)...
> >
> > Thanks in advance,
> > Ekkehard
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
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