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: AW: PSML Import Problem with MySQL
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]
AW: PSML Import Problem with MySQL
Hi Dmitriy! 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 Please take a look at http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg15355.html. In the last part David explains that he has added the property org.apache.jetspeed.test.jdbc.j1.drivers.path to the maven.xml. This was for the 1.6 version from the CVS, but your description sounds pretty much like the problems I met. So you might give it a try. Regards Daniel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: PSML Import Problem with MySQL
Daniel Brose wrote: Hi Dmitriy! 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 Im seeing a lot of PSML import failures. I guess its not a trivial process. Im sorry. Before even importing, can you get Jetspeed to run with MySQL? Can you create new users from the User Admin portlet? Often the importer fails because Jetspeed is compiled with HSQL parameters -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: PSML Import Problem with MySQL
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. -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
PSML Import Problem with MySQL
Title: Message Hello, I am using Jetspeed 1.5 FINAL,MySQL 4.1.9 andTomcat 5.0.16. Attempts to import PSML into DBkeeps 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/AbstractDataSourceFactory.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... - 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...
