db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerhard Otte" <Gerhard.O...@emediapark.de>
Subject AW: How to dynamically add new database to Torque
Date Thu, 27 Nov 2003 07:51:47 GMT
You have to start a new configuration with
Configuration c = (Configuration)new
PropertiesConfiguration("Torque.properties");
Then change youtr properties and finally call
Torque.init(c);
At least that worked for me.

Gerhard Otte
__
mailto:G.Otte@emediapark.de     emediapark GmbH http://www.emediapark.de
Tel:+49 (0)941 630804-2 Fax:-9  Hemauerstr.14,93047 Regensburg,Germany

-----Urspr√ľngliche Nachricht-----
Von: Jeremy Kincaid [mailto:Jeremy.Kincaid@intermoco.com]
Gesendet: Donnerstag, 27. November 2003 07:31
An: torque-user@db.apache.org
Betreff: How to dynamically add new database to Torque


	I am trying to find a way to dynamically add a new database to
Torque after it as already been initialized.  I tried retreiving the
configuration from Torque and then adding properties that would normally
have appeared in the torque.properties file, then called
Torque.init(configuration), or Torque.setConfiguration(configuration),
but these didn't work.  After looking at the source code, it was easy to
see why.  So does anyone have an alternative for the following:

Configuration config = Torque.getConfiguration();
//add adpater information
config.addProperty( "database.newDatabase.adapter", "mysql" );	
//add pooling information
config.addProperty( "dsfactory.newDatabase.factory",
"org.apache.torque.dsfactory.SharedPoolDataSourceFactory" );
config.addProperty( "dsfactory.newDatabase.defaultMaxActive", "10" );
config.addProperty( "dsfactory.newDatabase.testOnBorrow", "true" );
config.addProperty( "dsfactory.newDatabase.validationQuery", "SELECT 1"
);
config.addProperty( "dsfactory.newDatabase.connection.driver",
"org.gjt.mm.mysql.Driver" );
config.addProperty( "dsfactory.newDatabase.connection.url",
"jdbc:mysql://localhost:3306/NewDatabase" );

Torque.init( config );
Connection newConnection = Torque.getConnection( "newDatabase" );

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