I am in the progress of upgrading from 1.4 to 1.5. But I cant seem to get torque datasource to work with multiple datasources in 1.5. I am accessing 2 mysql databases (default and portletdata). Torque tries to fetch all data from the default database.
I also started to use maven in 1.5.
In project.properties i have:
database = mysql
torque.database.default.adapter=mysql
torque.database.default.connection.driver = org.gjt.mm.mysql.Driver
torque.database.default.connection.url = jdbc:mysql://192.168.1.3:3306/jetspeed15udv
torque.database.default.connection.user = ***
torque.database.default.connection.password = ***
torque.database.portletdata.adapter=mysql
torque.database.portletdata.connection.driver = org.gjt.mm.mysql.Driver
torque.database.portletdata.connection.url = jdbc:mysql://192.168.1.3:3306/portletdata
torque.database.portletdata.connection.user = ***
torque.database.portletdata.connection.password = ***
and in torque.properties i have: torque.database.default=default torque.database.default.adapter=mysql torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory torque.dsfactory.default.pool.defaultMaxConnections=20 torque.dsfactory.default.pool.maxExpiryTime=3600 torque.dsfactory.default.pool.connectionWaitTimeout=10
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.default.connection.url = jdbc:mysql://192.168.1.3:3306/jetspeed15udv
torque.dsfactory.default.connection.user = ***
torque.dsfactory.default.connection.password = ***
torque.dsfactory.portletdata.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory torque.dsfactory.portletdata.pool.defaultMaxConnections=10 torque.dsfactory.portletdata.pool.maxExpiryTime=3600 torque.dsfactory.portletdata.pool.connectionWaitTimeout=10
torque.database.portletdata.adapter=mysql
torque.dsfactory.portletdata.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.portletdata.connection.url = jdbc:mysql://192.168.1.3:3306/portletdata
torque.dsfactory.portletdata.connection.user = data
torque.dsfactory.portletdata.connection.password = data
--------------------
The exception is:
[17 Aug 2004 21:21:20 ERROR] - General error, message from server: "Table 'jetspeed15udv.bookmark' doesn't exist"
[17 Aug 2004 21:21:20 ERROR] - java.sql.SQLException: General error, message from server: "Table 'jetspeed15udv.bookmark' doesn't exist"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651)
So the question is: what do i have to do in order to make maven/torque/jetspeed register that the bookmark table is not in the jetspeed15udv database but in the portletdata database?
Any help would be appreciated ! Regards Henrik
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
