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