>
> I need to simultaneously access multiple DBs (several
> Oracle instances, several SQL Server instances and a
> mySql DB for fun). I'm pretty sure Turbine has provisions
> to do this, but I was wondering if anybody who has
> done this before could give me a quick run down (or
> pointers to official docs) of:
>
> 1. Changes to TR.props.
Last time I looked this was not possible from within TR.props.
See (3) for further directions.
> 3. What impact (if any) this has on the DB pool (broker?
> whatever it is called these days).
You must call the registerPool(...) function in PoolBrokerService:
PoolBrokerService.getInstance()
.registerPool(
"mysecondpool",
"com.my.jdbc.Driver",
"jdbc:localhost/mydb",
"user",
"passwd")
> 2. How to select between the different DBs from Java code.
You must call the getConnection(String) function in PoolBrokerService:
PoolBrokerService.getInstance()
.getConnection("mysecondpool")
This function will return a DBConnection to mydb, residing on localhost.
> Thanks in advance,
>
>
> --
> Gonzalo A. Diethelm
> [EMAIL PROTECTED]
>
ps. What is this TurbineDB anyway???
I haven't seen anything about it in the list ...
Magnus
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
