Mailing-List: contact jetspeed-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jetspeed Users List" <jetspeed-user@jakarta.apache.org>
Message-ID: 
 <2070AF841197244B9A824996F4A5746D5663D7@nbvrnts16.probation.nycnet>
From: "McIntyre, Kevin" <kmcintyr@probation.nyc.gov>
To: "'Jetspeed Users List'" <jetspeed-user@jakarta.apache.org>
Subject: RE: Multiple Torque Adapters.
Date: Wed, 19 Mar 2003 15:54:04 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

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:michael@michaelrothrock.com]
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" <kmcintyr@probation.nyc.gov> 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: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
> 
> 


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

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