PSMLImporter, DB2 & "No suitable driver"

[Stuart Belden <SB...@bjc.org>]

I'm trying to export PSML from the DB2  to the filesystem; I know this must be a stupid user error but I can't for the life of me get Torque to cooperate.  I have no trouble building and running Jetspeed in WAS/WSAD.

The root problem is "org.apache.torque.TorqueException: No suitable driver"  PsmlImporter.run() starts up fine; this exception is thrown when Torque first tries to grab a connection.

I modified the ant import task to explicitly reference the db2 driver jar in the java process it spawns:    
<classpath>
  ....
  <pathelement location="webapp/WEB-INF/lib/db2java.jar"/>
</classpath>

I modified webapp/WEB-INF/conf/Torque.properties to be the exact same as the Torque.properties I use to run Jetspeed.   Is that the file Torque reads to find connection info or have I missed something?

Any help would be greatly appreciated.  Here's the relevant part of the log fwiw:

2003-09-03 09:06:47,046 [main] INFO  PsmlImporter - Running with Importer Service: class org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
2003-09-03 09:06:47,046 [main] INFO  PsmlImporter - Running with Exporter Service: class org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService
2003-09-03 09:06:47,078 [main] WARN  DatabasePsmlManagerService - DatabasePsmlManagerService.getDbConnection: exception: org.apache.torque.TorqueException: No suitable driver
2003-09-03 09:06:47,171 [main] WARN  DatabasePsmlManagerService - DatabasePsmlManagerService.query: exception
java.lang.NullPointerException: Connection object was null. This could be due to a misconfiguration of the DataSourceFactory. Check the logs and Torque.properties to better determine the cause.
	at org.apache.torque.util.Transaction.rollback(Transaction.java:179)
	at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1372)
	at org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doSelectVillageRecords(BaseJetspeedUserProfilePeer.java:388)
	at org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doSelect(BaseJetspeedUserProfilePeer.java:339)
	at org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.selectOrdered(JetspeedUserProfilePeer.java:180)
	at org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.query(DatabasePsmlManagerService.java:814)
	at org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.export(DatabasePsmlManagerService.java:1148)
	at org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java:209)
	at org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImporter.java:178)
2003-09-03 09:06:47,187 [Thread-1] DEBUG RegistryWatcher - RegistryWatcher: Saving dirty fragments.
2003-09-03 09:06:47,187 [Thread-1] DEBUG RegistryWatcher - RegistryWatcher: Checking for updated files.
2003-09-03 09:06:47,218 [main] INFO  PsmlImporter - PSMLImporter completed. Exported 0 profiles