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]
