Marina,
I know you probably have most of this down cold, but please verify:
- you have a copy of mysql-connector-java-3.0.16-ga-bin.jar in
<TOMCAT_HOME>/shared/lib.
- that the com.mysql.jdbc.Driver class exists in
mysql-connector-java-3.0.16-ga-bin.jar.
- if you are manually copying the jetspeed.war into webapps, make sure
that the jetspeed.xml is edited for your configuration and is copied to
the correct location: tomcat5=<TOMCAT_HOME>/conf/Catalina/localhost or
tomcat4=<TOMCAT_HOME>/webapps.
- that admin/admin has access to your j2 and j2test databases.
- that your java implementation is being located correctly and is a
current 1.4.2 or 1.5 version... I have never seen those "targetting 1.4"
messages on Linux.
Randy
> Thanks, Randy.
> Something very strange is going on here...
> I tried different variations of the build.properties
> file and it comes down to the following two scenarios:
>
> 1) if I set properties to:
> 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 = admin
> org.apache.jetspeed.test.database.password = admin
>
> org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.test.database.default.name=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 = admin
> org.apache.jetspeed.production.database.password =
> admin
>
> org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.production.database.default.name=mysql
>
>
> then I get errors running maven allBuild target::
> jetspeed2:jar:install:
> build:start:
>
> java:prepare-filesystem:
> [mkdir] Created dir:
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
>
> 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
>
> 2) if I set driver's name to:
> org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.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-ga-bin.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
>
> then 'maven allBuild' finishes successfully, but:
> -- no jetspeed.war is created in the Tomcat's webapp/
> directory --> when trying to access J2 from a browser
> - you get 404 error
> -- no tables are created in the 'j2' DB schema.
> 'j2test' schema has all tables created and populated.
> -- the jetspeed.war file is created in the J2
> project's .../portal/target/ directory though. I tried
> copying it manually to the Tomcat's webapp/ dir - but
> when I started tomcat, the following errors were
> thrown when Tomcat was trying to deploy jetspeed.war:
>
> Caused by:
> org.springframework.beans.factory.BeanCreationException:
> Error creati
> ng bean with name 'java.util.prefs.PreferencesFactory'
> defined in URL [file:/C:/
> Marina/Java/tomcat-5.0.30-j2M2-MYSQL/webapps/jetspeed/WEB-INF/assembly/jetspeed-
> spring.xml]: Initialization of bean failed; nested
> exception is org.apache.jetsp
> eed.prefs.PreferencesException: Failed to initialize
> prefs api. org.springframe
> work.transaction.CannotCreateTransactionException:
> Could not create OJB transact
> ion; nested exception is
> org.apache.ojb.broker.accesslayer.LookupException:
> SQLE
> xception thrown while trying to get Connection from
> Datasource (java:comp/env/jdbc/jetspeed)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBean
> Factory.createBean(AbstractAutowireCapableBeanFactory.java:300)
>
>
> It hunts me that it must be something very simple and
> very stupid, since nobody else had these problems
> using MySQL, but I can't find what that is...
> Any ideas?
>
> Thanks!
> Marina
>
>
>
>
> --- [EMAIL PROTECTED] wrote:
>
>> Marina,
>>
>> These settings have always worked for me, (note that
>> I do not set the
>> ojb.platform property):
>>
>>
> org.apachejetspeed.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 =
>>
> === message truncated ===
>
>
> ---------------------------------------------------------------------
> 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]
