> -----Original Message-----
> From: Eric White [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 19, 2002 6:36 AM
> To: [EMAIL PROTECTED]
> Subject: accessing mysql from a dbbrowser portlet
>
>
> I don't want to replace hypersonic as the user/group/role db under
> Jetspeed, I just want to access a mysql db from a dbbrowser portlet (one
> that I'd write or hijack from the demos/examples).
>
> But, I'm looking for the special sauce recipe of tasks I'm supposed to
> perform. Can somebody point me to the right sequence of URLs.
>
> I understand torque.properties fits in here somewhere but, after
> reviewing the last few month's of mailing list posts, it appears that I
> have to generate some files for torque/turbine to consume as part of the
> object-to-relational mapping stage.
>
The dbbrowserportlet works generically on a database using
java.sql.ResultSetMetaData, so it doesn't make use of torque at all except
for the connection.
Here is one way to configure a second database connection pool in the
Torque.properties. It is named 'ender':
torque.database.ender.adapter=oracle
torque.dsfactory.ender.connection.driver = oracle.jdbc.driver.OracleDriver
torque.dsfactory.ender.connection.url =
jdbc:oracle:thin:@yourSid:1521:yourSchema
torque.dsfactory.ender.connection.user = jetspeed
torque.dsfactory.ender.connection.password = password
torque.dsfactory.ender.factory=org.apache.torque.dsfactory.TorqueDataSourceF
actory
torque.dsfactory.ender.pool.defaultMaxConnections=10
torque.dsfactory.ender.pool.maxExpiryTime=3600
torque.dsfactory.ender.pool.connectionWaitTimeout=10
To use this connection pool in the DatabaseBrowserPortlet, specify it by
name:
<!-- to use an alternate torque pool, set this parameter -->
<parameter name="poolname" value="ender" hidden="false"/>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
