Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: How to dynamically add new database to Torque
Date: Fri, 28 Nov 2003 10:41:58 +1100
Message-ID: <0875EA5871C9604F997C751E6FEAA14E465105@melmail.intermoco.corp>
Thread-Topic: How to dynamically add new database to Torque
Thread-Index: AcO0sBOWZ3ZOfwWHQrCk6OFLRbKR/AAClqMQAB6oRlA=
From: "Jeremy Kincaid" <Jeremy.Kincaid@intermoco.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>

Thankyou for the response Gerhard, but unfortunately it didn't work for =
me.  I still get the error "java.lang.NullPointerException: There was no =
DataSourceFactory configured for the connection newDatabase".  I am =
using Torque version 3.1.  I read that they have changed the re-entry to =
the initialize method from earlier versions.

Torque is a static wapper for the TorqueInstance class.  The =
TorqueInstance.init(Configuration) method calls =
setConfiguration(Configuration) and then initialize().  Inside the =
initialize() method there is an if statement that checks if Torque has =
already been initialized.  If so, then simply returns and the adapters =
and data source factories are not initialized. I think this is a safety =
measure as the initialize() method also creates new hashmaps for mapping =
databases to adapters and data source factories which would override =
existing maps.  If the creation of these hashmaps were done else where, =
then it might be easier.

At this stage I am comptemplating creating a class that inherits from =
TorqueInstance and has the ablility to add to the hashmaps.
//------------------------------------------------------------
        Jeremy Kincaid
          Software Systems Engineer
=20
          Intermoco Solutions Pty. Ltd.
          488-494 La Trobe Street
          Melbourne, Victoria, 3000
          AUSTRALIA
         =20
          Voice: +61 3 8080 8709
          Fax:    +61 3 8080 8700
          email:  jeremy.kincaid@intermoco.com
          www.intermoco.com


-----Original Message-----
From: Gerhard Otte [mailto:Gerhard.Otte@emediapark.de]=20
Sent: Thursday, 27 November 2003 6:52 PM
To: Apache Torque Users List
Subject: AW: How to dynamically add new database to Torque


You have to start a new configuration with
Configuration c =3D (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=FCngliche 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 =3D Torque.getConfiguration();
//add adpater information
config.addProperty( "database.newDatabase.adapter", "mysql" );=09
//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 =3D 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


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org