Thanks Josh for helping me out, it works !!
----- Original Message ----- From: Josh Holding <[EMAIL PROTECTED]> To: 'Jetspeed Users List' <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 11:13 PM Subject: RE: HOw to Connect two different database ? > I've done it this way successfully: > > ### start torque.properties file: > torque.database.default=default > torque.database.default.adapter=mssql > > ### Jetspeed Microsoft SQL > torque.dsfactory.default.connection.driver = > com.microsoft.jdbc.sqlserver.SQLServerDriver > torque.dsfactory.default.connection.url = > jdbc:microsoft:sqlserver://<servername1>:1433;databaseName=<dbName1>;SelectM > ethod=cursor > torque.dsfactory.default.connection.user = <username1> > torque.dsfactory.default.connection.password = <password1> > torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc > eFactory > # The number of database connections to cache per ConnectionPool instance > (specified per database) > torque.dsfactory.default.pool.defaultMaxConnections=10 > torque.dsfactory.default.pool.maxExpiryTime=3600 > torque.dsfactory.default.pool.connectionWaitTimeout=10 > > ### My Dev Data DB > torque.dsfactory.devDB.connection.driver = > com.microsoft.jdbc.sqlserver.SQLServerDriver > torque.dsfactory.devDB.connection.url = > jdbc:microsoft:sqlserver://<servername2>:1433;databaseName=<dbName2>;SelectM > ethod=cursor > torque.dsfactory.devDB.connection.user = <username2> > torque.dsfactory.devDB.connection.password = <password2> > torque.dsfactory.devDB.factory=org.apache.torque.dsfactory.TorqueDataSourceF > actory > # The number of database connections to cache per ConnectionPool instance > (specified per database) > torque.dsfactory.devDB.pool.defaultMaxConnections=10 > torque.dsfactory.devDB.pool.maxExpiryTime=3600 > torque.dsfactory.devDB.pool.connectionWaitTimeout=10 > ### end torque.properties file > > Then, in your portlet registry entry add this parameter, otherwise it will > use the default: > > <parameter name="poolname" value="devDB" hidden="true"/> > > Hope this helps- > Josh > > -----Original Message----- > From: Stuart Belden [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 12:08 PM > To: [EMAIL PROTECTED] > Subject: Re: HOw to Connect two different database ? > > > You'll need to configure torque to use two separate databases; see their > documentation and user lists. You may need to extend the db browser portlet > to use something other than the default Torque connection; I've never used > it and can't say for sure. > > >>> [EMAIL PROTECTED] 08/06/03 12:18AM >>> > Hello All, > I wanted to create a database portlet fetching records from > mysql , i made necessary changes in tourque.properties and ,connected it > with mysql and was able to fetch records , but i also need another database > portlet which connects with oracle database , is there any way to make two > different database connections available for database portlets , and how to > refer those connection. > > thanks in advance. > -kri$hnan > > > --------------------------------------------------------------------- > 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]
