Marina,
Shouldn't there be a default name entry in your build.properties file?
I have used it with Sybase and I have the following entry in my
build.properties.
org.apache.jetspeed.test.database.default.name = sybase
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
