I'm also a bit confused as to the torque.database.default property semantics. Even when using a single database, if I have the following properties:
torque.database.default=bookstore torque.database.bookstore.driver = org.gjt.mm.mysql.Driver torque.database.bookstore.url = jdbc:mysql://127.0.0.1/bookstore torque.database.bookstore.username = username torque.database.bookstore.password = password Everything works great. But, if I use the following: torque.database.default=somethingelse torque.database.bookstore.driver = org.gjt.mm.mysql.Driver torque.database.bookstore.url = jdbc:mysql://127.0.0.1/bookstore torque.database.bookstore.username = username torque.database.bookstore.password = password I get NPEs. My schema (and id-table-schema) explicitly uses "bookstore" as the name of the database. What exactly is this default property used for? I've been meaning to go through the code for a definitive answer, I just haven't gotten around to it yet, any insight would be helpful for the tutorial that I am writing. Thanks, Pete On Sun, Feb 03, 2002 at 08:47:36PM -0600, Dave Everson wrote: > I wanted to add one more observation before sending this. > > We also noticed that when we change torque.database.default property, we > are not able to insert into that database that is NOT set by this > property. For example, if we set this property to rcmwf we can't insert > into smartdata. If we set this property to smartdata, we can't insert > into rcmwf. > > Dave > > -----Original Message----- > From: Dave Everson [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 03, 2002 8:41 PM > To: 'Turbine Users List' > Subject: Error using Multiple Databases and Torque > > We are using the OM classes generated via standalone Torque (built from > CVS Jan29th). We have two schemas that point to two databases (rcmwf > and smartdata). In testing our code we have discovered that we are able > to read and insert/update data in the first database (rcmwf). However, > with the second database (smartdata) we can only read data. Whenever we > attempt to perform an insert with the second database, we get a Null > Pointer Exception. Unfortunately we don't get any more information than > this. Attached is a portion of the Torque.properties configuration file. > > > Does anybody know what might be causing these exceptions? > > > Portion of the .properties file: > > torque.database.default=rcmwf > > torque.database.rcmwf.driver=org.gjt.mm.mysql.Driver > torque.database.rcmwf.url=jdbc:mysql://localhost:3306/rcmwf > torque.database.rcmwf.username= > torque.database.rcmwf.password= > > torque.database.smartclaim.driver=org.gjt.mm.mysql.Driver > torque.database.smartclaim.url=jdbc:mysql://localhost:3306/smartdata > torque.database.smartclaim.username= > torque.database.smartclaim.password= > > # The number of database connections to cache per ConnectionPool > # instance (specified per database). > > torque.database.rcmwf.maxConnections=80 > torque.database.smartclaim.maxConnections=80 > > # The amount of time (in milliseconds) that database connections will be > # cached (specified per database). > # > # Default: one hour = 60 * 60 * 1000 > > torque.database.rcmwf.expiryTime=3600000 > torque.database.smartclaim.expiryTime=3600000 > > # The amount of time (in milliseconds) a connection request will have to > wait > # before a time out occurs and an error is thrown. > # > # Default: ten seconds = 10 * 1000 > > torque.database.rcmwf.connectionWaitTimeout=10000 > torque.database.smartclaim.connectionWaitTimeout=10000 > > # The interval (in milliseconds) between which the PoolBrokerService > logs > # the status of it's ConnectionPools. > # > # Default: No logging = 0 = 0 * 1000 > > torque.database.logInterval=10 > > > > > -- > 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]> > -- Peter Kazmier http://www.kazmier.com PGP Fingerprint 4FE7 8DA3 D0B5 9CAA 69DC 7243 1855 BC2E 4B43 5654 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
