Thanks Jeremy for the script, but I've already built the jetspeed schema in mySQL database.
My issue comes during the maven compilation (maven war). Here is an extract of my torque.properties file : torque.database.default=jetspeed torque.database.jetspeed.adapter=mysql torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory.TorqueDataSour ceFactory # The number of database connections to cache per ConnectionPool instance (specified per database) torque.dsfactory.jetspeed.pool.defaultMaxConnections=10 torque.dsfactory.jetspeed.pool.maxExpiryTime=3600 torque.dsfactory.jetspeed.pool.connectionWaitTimeout=10 ### MySQL torque.dsfactory.jetspeed.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.jetspeed.connection.url = jdbc:mysql://localhost:3306/jetspeed torque.dsfactory.jetspeed.connection.user = root torque.dsfactory.jetspeed.connection.password = Any help would be welcome, Daniel. -----Message d'origine----- De : Jeremy Kuhnash [mailto:[EMAIL PROTECTED] Envoyé : vendredi 14 mai 2004 02:46 À : Jetspeed Users List Objet : Re: Moving jetspeed to mysql Wanted to try and help ... possibly save some trouble: Basically use the attached schema like so - # mysql -u [username] -p [database] < portal_dump.sql Migrating to mysql with the new maven stuff seem to be very broken, and the sql scripts in the distribution dont work for me (at least). Luckily, I had a mysql database on a server that had the schema installed but had never gotten jetspeed 1.4 to talk to it ... 1.5 talks to it but can't make the schema. Once you have that in place, your Torque.properties and whatever else with the database stuff need changed, but after that it should work. I am currently working on getting PSML working against the database .. probably a few more tweaks. Need to figure out how to do the initial data population.... Cheers, Jeremy Daniel SELAM wrote: >Hi, > >I try to move jetspeed to mysql db following the online doc. >I've changed project.properties and torque.properties accordingly, but get >this error message during maven compilation : > >[junit] ERROR - Property: driver value: org.gjt.mm.mysql.Driver is not >supported by DataSource: >org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS > >Any idea ? >Thanks ! > >Daniel. > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
