Marina,
What I meant to say is that, I believe the default name should be the
type of database name, so in your build script it should be mysql
instead of j2 and j2test. If you look at the sample build properties,
it contains hsql for both test and production default database name.
org.apache.jetspeed.test.database.default.name=hsql
org.apache.jetspeed.test.database.ojb.platform=Hsqldb
Hema
>
> On Thu, 24 Feb 2005 18:37:18 -0800 (PST), Marina <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I finally got around to switch from HSQLDB to MySQL
> > and ran into a build problem.
> > I setup MySQL DB schema and users per J2 instructions
> > (created 'j2test' and 'j2' schemas and the 'jetspeed2'
> > user that has all writes for those schemas). I have
> > also modified J2's build.properties to use MySQL (I'm
> > including a snippet below).
> >
> > After that, I do the following:
> > 1. start MySQL DB
> > 2. cd [EMAIL PROTECTED]
> > maven allClean - OK
> > maven allBuild - Error:
> >
> > Attempting to download maven-torque-plugin-3.2.jar.
> > 2/6K
> > 6/6K
> > 6K downloaded
> > build:start:
> >
> > allBuild:
> > check.required.properties:
> >
> > torque:init:
> >
> > db.scripts.gen:
> > [echo] Generating SQL schema creation scripts for
> > HSQLDB
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > MySQL
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > Oracle
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > MS SQL
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > Postgres
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
> >
> > BUILD FAILED
> > File......
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> > Element... sql
> > Line...... 355
> > Column.... 39
> > Source file does not exist!
> > Total time: 12 seconds
> > Finished at: Thu Feb 24 21:27:54 EST 2005
> >
> > Here is my build.properties (relevant parts):
> > # Override the database connection and
> > driverproperties in your ${USER_HOME}/build.properties
> > appropriately
> > # See:
> > # http://portals.apache.org/jetspeed-2/database.html
> >
> > org.apache.jetspeed.test.database.url =
> > jdbc:mysql://localhost/j2test
> > org.apache.jetspeed.test.database.driver =
> > com.mysql.jdbc.Driver
> > org.apache.jetspeed.test.database.user = jetspeed2
> > org.apache.jetspeed.test.database.password = jetspeed2
> >
> > org.apache.jetspeed.test.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> > org.apache.jetspeed.test.database.default.name=j2test
> > org.apache.jetspeed.test.database.ojb.platform=mysql
> >
> > org.apache.jetspeed.production.database.url =
> > jdbc:mysql://localhost/j2
> > org.apache.jetspeed.production.database.driver =
> > com.mysql.jdbc.Driver
> > org.apache.jetspeed.production.database.user =
> > jetspeed2
> > org.apache.jetspeed.production.database.password =
> > jetspeed2
> >
> > org.apache.jetspeed.production.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> > org.apache.jetspeed.production.database.default.name=j2
> > org.apache.jetspeed.production.database.ojb.platform=mysql
> >
> > (I am not sure about the ojb.platform property, there
> > were no directions on what it should be set to for
> > MySQL, so I decided to set it to 'mysql' instead of
> > keeping the default value of 'Hsqldb' ...)
> >
> > Any idea what I did wrong?
> >
> > Thanks!
> > Marina
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
> --
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Hema Menon
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hema Menon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
