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]
