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]
