Hi David,
hi all!
> Could you send the relevant properties from your
> JetspeedResources.properties. Also, for Jetspeed-1, to switch databases
> you have to change the Torque properties and rebuild. Did you do that?
Okay, here are the relevant properties from my JetspeedResources.properties
(as far as I know which ARE relevant):
# To use the File-based PSML service, select (uncomment) this service (this
is the default setting):
#
services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.Cast
orPsmlManagerService
# To use the DB-PSML service, select (uncomment) this service, and comment
out the above service:
services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.D
atabasePsmlManagerService
# Select this service to import from File System to the Database (make sure
that DatabasePsmlManagerService is selected above)
services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanage
r.CastorPsmlManagerService
# Select this service to import from the Database to the File System (make
sure that CastorPsmlManagerService is selected above)
#
services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanage
r.db.DatabasePsmlManagerService
And yes, I changed my Torque.properties and rebuild. I'm already using MySQL
for users. Here are my settings for my db in my Torque.properties:
torque.database.default=default
torque.database.default.adapter=mysql
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.default.connection.url =
jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.default.connection.user = jetspeed
torque.dsfactory.default.connection.password = jetspeed
> Finally, check the log files from the import.
> Send any relevant stack traces to this list
Actually there seem to be some problems with the MySQL driver. As I'm
already using it for users, I thought anything would be fine with it. Where
do I put the jar for the MySQL driver so that maven recognizes it?
Excerpt from my jetspeedservices.log:
2005-02-15 21:16:26,722 [main] WARN DatabasePsmlManagerService -
DatabasePsmlManagerService.getDbConnection: exception:
org.apache.torque.TorqueException: java.sql.SQLException: No suitable driver
2005-02-15 21:16:27,243 [main] WARN DatabasePsmlManagerService -
DatabasePsmlManagerService.createOrSaveDocument: profile:
BaseProfile[user/admin/html/default.psml] tableName: JETSPEED_USER_PROFILE
org.apache.torque.TorqueException: java.sql.SQLException: No suitable driver
at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:755)
at org.apache.torque.Torque.getConnection(Torque.java:306)
at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:636)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:223)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:581)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.doInsertOrUpdate(Jetsp
eedUserProfilePeer.java:108)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.insert(JetspeedUserPro
filePeer.java:49)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eOrSaveDocument(DatabasePsmlManagerService.java:626)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eDocument(DatabasePsmlManagerService.java:586)
at
org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas
torPsmlManagerService.java:1310)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java:
171)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImporter.java
:140)
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
