You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Sven Richter <sr...@gmx.net> on 2005/04/03 15:56:25 UTC
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
<da...@bluesunrise.com>:
> 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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: PSML Import Problem with MySQL
Posted by Roel van Dijk <ro...@forest-fields.nl>.
See this URL:
http://db.apache.org/torque/maven-plugin/goals.html
torque:om Generate the Peer-based object model from *-schema.xml files
Roel
> -----Oorspronkelijk bericht-----
> Van: Sven Richter [mailto:srman@gmx.net]
> 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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: PSML Import Problem with MySQL
Posted by Sven Richter <sr...@gmx.net>.
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" <sr...@gmx.net>
An: "Jetspeed Users List" <je...@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
<da...@bluesunrise.com>:
> 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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org