Here is my torque.properties file. Whatever I put in the default breaks the other code, so if I list jetspeed, the portal works fine and my "arts" classes don't work.
If I list "arts" as the default then jetspeed won't work. I have to use the "JndiDataSourceFactory" because informix has a problem with "TorqueDataSourceFactory"... regardless I'm confused how to get both up and working simulatenously. ------------------------------------ torque.applicationRoot = . torque.database.default=???? torque.database.arts.adapter=informix torque.dsfactory.arts.factory=org.apache.torque.dsfactory.JndiDataSourceFact ory torque.dsfactory.arts.jndi.path=java:comp/env/jdbc/InformixXaDS torque.dsfactory.arts.jndi.java.naming.factory.initial = org.jnp.interfaces.NamingContextFactory torque.dsfactory.arts.jndi.java.naming.factory.url.pkgs = org.jboss.naming:org.jnp.interfaces torque.database.jetspeed.adapter=mysql torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory.TorqueDataSour ceFactory torque.dsfactory.jetspeed.pool.defaultMaxConnections=10 torque.dsfactory.jetspeed.pool.maxExpiryTime=3600 torque.dsfactory.jetspeed.pool.connectionWaitTimeout=10 torque.dsfactory.jetspeed.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.jetspeed.connection.url = jdbc:mysql://10.132.108.179:3306/jetspeed torque.dsfactory.jetspeed.connection.user = [user] torque.dsfactory.jetspeed.connection.password = [password] torque.database.logInterval=0 torque.idbroker.cleverquantity=true torque.manager.useCache = true ----------------------------------------- -----Original Message----- From: Michael Rothrock [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 3:37 PM To: Jetspeed Users List Subject: Re: Multiple Torque Adapters. You have to add entries for each of the dbs. As an example, here are the relevant entries from my Torque.properties: torque.database.zb_content.adapter=postgresql torque.database.lyris.adapter=postgresql torque.dsfactory.zb_content.factory=\ org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory torque.dsfactory.zb_content.pool.defaultMaxActive=10 torque.dsfactory.zb_content.pool.testOnBorrow=true torque.dsfactory.zb_content.pool.validationQuery=SELECT 1 torque.dsfactory.zb_content.connection.driver = org.postgresql.Driver torque.dsfactory.zb_content.connection.url = jdbc:postgresql://localhost/zb_content torque.dsfactory.zb_content.connection.user = [user] torque.dsfactory.zb_content.connection.password = [password] torque.dsfactory.lyris.factory=\ org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory torque.dsfactory.lyris.pool.defaultMaxActive=10 torque.dsfactory.lyris.pool.testOnBorrow=true torque.dsfactory.lyris.pool.validationQuery=SELECT 1 torque.dsfactory.lyris.connection.driver = org.postgresql.Driver torque.dsfactory.lyris.connection.url = jdbc:postgresql://localhost/lyris torque.dsfactory.lyris.connection.user = [user] torque.dsfactory.lyris.connection.password = [password] In my case, I maintain two separate torque directories (from the standalone Torque distribution), one for each DB. I then link the source directory from one into the other, and use that as the "master" to compile all of my source files, which I then deploy to my jetspeed installation. I do it this way for a variety of reasons that may not be relevant in your case--ymmv. -- Michael On 3/19/03 12:08 PM, "McIntyre, Kevin" <[EMAIL PROTECTED]> wrote: > > Sorry to ask again, but I'm lost in the woods. > > Below shows 2 adapters that work individually in jetspeed when marked as > default. > > Is there anyway to utilize both in jetspeed? > > ---------------------------------------------------------------------------- > > torque.applicationRoot = . > > torque.database.default=db1 > torque.database.db1.adapter=informix > .... > .... > > torque.database.jetspeed.adapter=mysql > .... > .... > > > > -------------------------------------- > > > Kevin. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
