I guess you need to setup another datasource, e.g. leave original Jetspeed Torque.properties and add something like this to the end of it:
--- torque.database.mydb.adapter=postgresql torque.dsfactory.mydb.connection.driver = org.postgresql.Driver torque.dsfactory.mydb.connection.url = jdbc:postgresql://localhost/mydb torque.dsfactory.mydb.connection.user = myuser torque.dsfactory.mydb.connection.password = ***
torque.dsfactory.mydb.factory=org.apache.torque.dsfactory.
Jdbc2PoolDataSourceFactory
torque.dsfactory.mydb.pool.defaultMaxActive=10
torque.dsfactory.mydb.pool.testOnBorrow=true
torque.dsfactory.mydb.pool.validationQuery=SELECT 1
---
(this one is actually for pgSQL, so you need to change values to suit your config)
providing that in yourproject-schema.xml from which you generate Torque classes you specify:
<database name="mydb" ...> ... </database>
(for me, it was necessary to set the same database name in project- schema.xml and for the datasource, otherwise Torque classes didn't work correctly).
Hope this helps.
Martin Dostal
Dne 06.12.2003 22:51:41 napsal Robson Borges:
Hi, Stuart.
Thanks for your answer. I understood the procedures for change the default Jetspeed's database to another, like MySql, for example. But my question is: how can I access another database with my business data setting Torque Framework and still using hypersonic default database for Jetspeed's data ?
Thanks in advance ! Robson Borges
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
