Marina,
These settings have always worked for me, (note that I do not set the
ojb.platform property):
org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
org.apache.jetspeed.test.database.default.name=mysql
org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
org.apache.jetspeed.test.database.driver=org.gjt.mm.mysql.Driver
org.apache.jetspeed.test.database.user=admin
org.apache.jetspeed.test.database.password=admin
org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
org.apache.jetspeed.production.database.default.name=mysql
org.apache.jetspeed.production.database.url=jdbc:mysql://localhost/j2
org.apache.jetspeed.production.database.driver=org.gjt.mm.mysql.Driver
org.apache.jetspeed.production.database.user=admin
org.apache.jetspeed.production.database.password=admin
Randy
> Thank you, Hema!
>
> Yes, that was it - the default name had to be set to
> 'mysql'.
> Once I did that, the build script finished all DB
> setup work fine but it failed at a later point:
>
> java:compile:
> [echo] Compiling to
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
> [echo]
> ==========================================================
>
> NOTE: Targetting JVM 1.4, classes
> will not run on earlier JVMs
>
> ==========================================================
>
> [javac] Compiling 27 source files to
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
>
> BUILD FAILED
> File......
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> Element... maven:reactor
> Line...... 133
> Column.... 40
> Unable to obtain goal [java:compile] --
> C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
> <ant:javac> Error running javac.exe compiler
> Total time: 37 seconds
> Finished at: Fri Feb 25 19:23:20 EST 2005
>
>
> Any idea what is wrong now?
>
> Thank you!
> Marina
>
> --- Hema Menon <[EMAIL PROTECTED]> wrote:
>
>> 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]
>>
>>
>
>
> ---------------------------------------------------------------------
> 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]
