Re: PSML Import Problem with MySQL
Hello, is there nobody who can help me with that? How do you guys do it? First you create a schema for the new tables, then you run 'maven torque:sql', the you run the genaerated scripts in your database. So far so good. But you also need the corresponding OM-classes to use the new tables. But how do I do that? Please help me if you can, Thanks a lot, Sven. --- Weitergeleitete Nachricht --- Von: Sven Richter [EMAIL PROTECTED] An: Jetspeed Users List jetspeed-user@jakarta.apache.org Betreff: Re: AW: PSML Import Problem with MySQL Datum: Sun, 03 Apr 2005 15:56:25 +0200 Hello, I just created a new schema for new database tables and put it under the same directory of jetspeed-src as the other database-schema-xml-files. Then I ran maven torque:sql and it generated the sql-file just fine. But where and how do I tell torque about generating the corresponding OM-Classes? Thanks a lot, Sven. Am Wed, 30 Mar 2005 09:30:05 -0800 schrieb David Sean Taylor [EMAIL PROTECTED]: OK, Im going to try real quick to summarize MySQL and PSML importing. I sent these instructions to Sven, and they really need to go out to everyone on the list: I am speaking here about version 1.6(-dev) You need to generate the DDL for the PSML. As described on the online docs, you need to: 1. change the project.properties database = mysql 2. run torque to gen the schema maven torque:sql It will generate a file named target/classes/sql/dbpmsl-schema.sql 3. run this script in MySQL 4. follow the instructions for making a specific build of Jetspeed, generating the torque bindings for MySQL. http://portals.apache.org/jetspeed-1/psml_db.html specifically, set your Torque.properties to MySQL and rebuild: 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 = root torque.dsfactory.default.connection.password = 5. then and only then you can run the importer I hate this, but you must RECOMPILE the source to run against any database except Hypersonic. These are all good reasons to NOT use Jetspeed-1 and instead use Jetspeed-2. (sigh) For the final 1.6 release, I will try to solve the compile/binding problem. - 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]
RE: PSML Import Problem with MySQL
See this URL: http://db.apache.org/torque/maven-plugin/goals.html torque:omGenerate the Peer-based object model from *-schema.xml files Roel -Oorspronkelijk bericht- Van: Sven Richter [mailto:[EMAIL PROTECTED] Verzonden: Tuesday, April 05, 2005 3:53 PM Aan: jetspeed-user@jakarta.apache.org CC: David Sean Taylor Onderwerp: Re: PSML Import Problem with MySQL Hello, is there nobody who can help me with that? How do you guys do it? First you create a schema for the new tables, then you run 'maven torque:sql', the you run the genaerated scripts in your database. So far so good. But you also need the corresponding OM-classes to use the new tables. But how do I do that? Please help me if you can, Thanks a lot, Sven. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: PSML Import Problem with MySQL
Here are attachments inline:
==STDOUT=
import:
[java] * PSML Importer *
[java] log4j:WARN No appenders could be found for logger
(org.apache.stratum.component.ComponentLoader).
[java] log4j:WARN Please initialize the log4j system properly.
[java] 766 [main] ERROR dsfactory.AbstractDataSourceFactory -
Property: driver value: com.mysql.jdbc.Driver is not supported by
DataSource: org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS
[java] 844 [main] INFO component.ComponentLoader - loading
component: name=fulcrum class=org.apache.fulcrum.Fulcrum
config=.\webapp\WEB-INF\conf\Fulcrum.properties
[java] 1079 [main] INFO fulcrum.TurbineServices - Finished
initializing all services!
[java] Running with Importer Service: class
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService
[java] Running with Exporter Service: class
org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
[java] PSMLImporter completed. Exported 0 profiles
[java] PSML Importer - completed
[java] [ERROR] Java Result: 1
project.properties (excerpt) =
#database = hypersonic
#targetPackage = org.apache.jetspeed.om.torque
#torque.retrievableInterface = org.apache.fulcrum.intake.Retrievable
#torque.database.url = jdbc:hsqldb:hsql://localhost
#torque.database.driver = org.hsqldb.jdbcDriver
#torque.database.user = sa
#torque.database.password =
database = mysql
targetPackage = org.apache.jetspeed.om.torque
torque.retrievableInterface = org.apache.fulcrum.intake.Retrievable
torque.database.url = jdbc:mysql://localhost:3306/jetspeed
torque.database.driver = com.mysql.jdbc.Driver
#torque.database.driver = org.gjt.mm.mysql.Driver
torque.database.user = root
torque.database.password =
Torque.properties (excerpt) =
torque.database.default=default
### torque.database.default.adapter=hypersonic
torque.database.default.adapter=mysql
### torque.database.default.adapter=oracle
### torque.database.default.adapter=mssql
##
## Using torque's old pool
##
### torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver
### torque.dsfactory.default.connection.url =
jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed
### torque.dsfactory.default.connection.user = sa
### torque.dsfactory.default.connection.password =
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS
ourceFactory
# The number of database connections to cache per ConnectionPool
instance (specified per database)
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
### MySQL
torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver
# 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 = root
torque.dsfactory.default.connection.password =
-Original Message-
From: Dmitriy Kruglyak [mailto:[EMAIL PROTECTED]
Sent: Monday, March 28, 2005 1:57 PM
To: jetspeed-user@jakarta.apache.org
Subject: PSML Import Problem with MySQL
Hello,
I am using Jetspeed 1.5 FINAL, MySQL 4.1.9 andTomcat 5.0.16.
Attempts to import PSML into DB keeps causing errors, even though I
modified properties files (attached) to use MySQL settings instead of
HSQL. I tried both MySQL drivers and ensured that they are in the
CLASSPATH. Still I get the problem that you can see in attached stdout
log.
AbstractDataSourceFactory says that the driver is not supported, and its
code seems to hide the real source / line of the exception. What could
be causing this problem?
http://db.apache.org/torque/xref/org/apache/torque/dsfactory/AbstractDat
aSourceFactory.html
Any help very much appreciated...
Regards,
Dmitriy
P.S. The same setup works just fine if I build war and run it from
tomcat...
