Re: using MySQL with J2 - setup problem
IIRC, quickStart does all the copying/DB ops, not allBuild. allBuild just basically builds J2 sans any deployment. Regrads, Marina wrote: ooh, I feel so bad... :) I knew it was something very stupid - I did not run the 'maven quickStart'. For some reason I thought it was intended for the HSQLDB only... Sorry for wasting so much of your time! Thanks, Randy, Marina --- [EMAIL PROTECTED] wrote: Marina: If your j2 DB is not setup, nothing will work anyway, so we are back to the failing maven build... you did use maven quickStart, no? Also, your DB URL probably needs to be jdbc:mysql://127.0.0.1:3306/j2 or jdbc:mysql://localhost/j2, (mysql can be picky about IP usage and I am not sure about the port you specified). Randy Thanks, Randy :) I modified jetspeed.xml file using the one from a working HSQL J2M2 installation as an example and copied it into the TOMCAT_HOME/conf/Catalina/localhost dir. I also copied a security.xml file from the HSQLDB J2M2 installation and adjusted the docBase value. Unfortunately, when I started Tomcat, I've got the same error: Caused by: org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs api.org.springframework.transaction.CannotCreateTransactionException: Could not create OJB transaction; nested exception is org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown while trying to get Connection from Datasource (java:comp/env/jdbc/jetspeed) at org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(Preference sFactoryImpl.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. ... And in the J2's log file: 2005-02-27 18:24:24 StandardContext[/jetspeed]StandardWrapper.Throwable java.lang.NullPointerException at org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876) at One thing that puzzles me (among others, of course) is that the 'j2' DB did not get populated while 'j2test' did... Here is my jetspeed.xml - lines that I changed: !-- HSQL dB username and password for dB connections -- parameter nameusername/name valueadmin/value /parameter parameter namepassword/name valueadmin/value /parameter !-- Class name for HSQL JDBC driver -- parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter !-- The JDBC connection url for connecting to your HSQL dB. -- parameter nameurl/name valuejdbc:mysql://127.0.0.1:3306/value /parameter /ResourceParams Thanks for looking into this! Marina --- [EMAIL PROTECTED] wrote: Marina, 3. jetspeed.xml there was no jetspeed.xml in the =TOMCAT_HOME/conf/Catalina/localhost dir The only jetspeed.xml files in the J2-project-home directory that I found were: maven-plugin/target/classes/plugin-resources/jetspeed.xml portal/src/resources/jetspeed.xml Should I manually edit one of them and copy into TOMCAT_HOME/conf/Catalina/localhost dir ? Since you manually copied the jetspeed.war into webapps, I assume you will need to do the same thing with the portal/src/resources/jetspeed.xml file. It is certainly simple enough to try! Is not it supposed to be done by the maven 'allBuild' goal? Well, so is copying jetspeed.war into webapps! :) Something is broken for sure, but I am just interesting in seeing if you can get it to run at all since you have taken it almost this far already. Yes, we are in the weeds at this point! Randy - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Great minds discuss ideas. Average minds discuss events. Small minds discuss people. - Admiral Hyman Rickover *** * Scott T. Weaver * * [EMAIL PROTECTED] * * http://www.einnovation.com* *
Re: using MySQL with J2 - setup problem
Randy,
I double checked my config files and verified the
following:
Verified:
1.
JVM version used by maven - added 'java -version'
command to the 'show.maven.props' goal:
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQLmaven
show.maven.props
__ __
| \/ |__ _Apache__ ___
| |\/| / _` \ V / -_) ' \ ~ intelligent projects ~
|_| |_\__,_|\_/\___|_||_| v. 1.0.2
build:start:
show.maven.props:
[echo] maven.home.local = C:/Marina/MyWork/Maven
[echo] maven.repo.local =
C:/Marina/MyWork/Maven/maven_repository
[echo] checking JRE version:
[exec] java version 1.4.2_06
[exec] Java(TM) 2 Runtime Environment, Standard
Edition (build 1.4.2_06-b03)
[exec] Java HotSpot(TM) Client VM (build
1.4.2_06-b03, mixed mode)
BUILD SUCCESSFUL
Total time: 2 seconds
Finished at: Sun Feb 27 11:54:13 EST 2005
2. 'admin' user has rights to the 'j2' and 'j2test'
tables in MySQL:
logged into MySQL as 'admin', created and dropped test
tables in both 'j2' and 'j2test' DBs:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3 to server version:
4.1.7. Type 'help;' or '\h' for help. Type '\c' to
clear the buffer.
mysql use j2test
Database changed
mysql create table MyTest( id int );
Query OK, 0 rows affected (0.10 sec)
mysql drop table MyTest;
Query OK, 0 rows affected (0.00 sec)
mysql use j2
Database changed
mysql create table MyTest( id int );
Query OK, 0 rows affected (0.02 sec)
mysql drop table MyTest;
Query OK, 0 rows affected (0.00 sec)
3. jetspeed.xml
there was no jetspeed.xml in the
=TOMCAT_HOME/conf/Catalina/localhost dir
The only jetspeed.xml files in the J2-project-home
directory that I found were:
maven-plugin/target/classes/plugin-resources/jetspeed.xml
portal/src/resources/jetspeed.xml
Should I manually edit one of them and copy into
TOMCAT_HOME/conf/Catalina/localhost dir ?
Is not it supposed to be done by the maven 'allBuild'
goal?
4. I checked the MySQL driver jar file itself - it
does have both com.mysql.jdbc.Driver and
org.gjt.mm.mysql.Driver. It is indeed located in the
TOMCAT_HOME/shared/lib dir.
Any other setup I could have missed?
Thanks!
Marina
--- [EMAIL PROTECTED] wrote:
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:
Re: using MySQL with J2 - setup problem
Marina, 3. jetspeed.xml there was no jetspeed.xml in the =TOMCAT_HOME/conf/Catalina/localhost dir The only jetspeed.xml files in the J2-project-home directory that I found were: maven-plugin/target/classes/plugin-resources/jetspeed.xml portal/src/resources/jetspeed.xml Should I manually edit one of them and copy into TOMCAT_HOME/conf/Catalina/localhost dir ? Since you manually copied the jetspeed.war into webapps, I assume you will need to do the same thing with the portal/src/resources/jetspeed.xml file. It is certainly simple enough to try! Is not it supposed to be done by the maven 'allBuild' goal? Well, so is copying jetspeed.war into webapps! :) Something is broken for sure, but I am just interesting in seeing if you can get it to run at all since you have taken it almost this far already. Yes, we are in the weeds at this point! Randy - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: using MySQL with J2 - setup problem
Thanks, Randy :) I modified jetspeed.xml file using the one from a working HSQL J2M2 installation as an example and copied it into the TOMCAT_HOME/conf/Catalina/localhost dir. I also copied a security.xml file from the HSQLDB J2M2 installation and adjusted the docBase value. Unfortunately, when I started Tomcat, I've got the same error: Caused by: org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs api.org.springframework.transaction.CannotCreateTransactionException: Could not create OJB transaction; nested exception is org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown while trying to get Connection from Datasource (java:comp/env/jdbc/jetspeed) at org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(Preference sFactoryImpl.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. ... And in the J2's log file: 2005-02-27 18:24:24 StandardContext[/jetspeed]StandardWrapper.Throwable java.lang.NullPointerException at org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876) at One thing that puzzles me (among others, of course) is that the 'j2' DB did not get populated while 'j2test' did... Here is my jetspeed.xml - lines that I changed: !-- HSQL dB username and password for dB connections -- parameter nameusername/name valueadmin/value /parameter parameter namepassword/name valueadmin/value /parameter !-- Class name for HSQL JDBC driver -- parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter !-- The JDBC connection url for connecting to your HSQL dB. -- parameter nameurl/name valuejdbc:mysql://127.0.0.1:3306/value /parameter /ResourceParams Thanks for looking into this! Marina --- [EMAIL PROTECTED] wrote: Marina, 3. jetspeed.xml there was no jetspeed.xml in the =TOMCAT_HOME/conf/Catalina/localhost dir The only jetspeed.xml files in the J2-project-home directory that I found were: maven-plugin/target/classes/plugin-resources/jetspeed.xml portal/src/resources/jetspeed.xml Should I manually edit one of them and copy into TOMCAT_HOME/conf/Catalina/localhost dir ? Since you manually copied the jetspeed.war into webapps, I assume you will need to do the same thing with the portal/src/resources/jetspeed.xml file. It is certainly simple enough to try! Is not it supposed to be done by the maven 'allBuild' goal? Well, so is copying jetspeed.war into webapps! :) Something is broken for sure, but I am just interesting in seeing if you can get it to run at all since you have taken it almost this far already. Yes, we are in the weeds at this point! Randy - 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]
Re: using MySQL with J2 - setup problem
ooh, I feel so bad... :) I knew it was something very stupid - I did not run the 'maven quickStart'. For some reason I thought it was intended for the HSQLDB only... Sorry for wasting so much of your time! Thanks, Randy, Marina --- [EMAIL PROTECTED] wrote: Marina: If your j2 DB is not setup, nothing will work anyway, so we are back to the failing maven build... you did use maven quickStart, no? Also, your DB URL probably needs to be jdbc:mysql://127.0.0.1:3306/j2 or jdbc:mysql://localhost/j2, (mysql can be picky about IP usage and I am not sure about the port you specified). Randy Thanks, Randy :) I modified jetspeed.xml file using the one from a working HSQL J2M2 installation as an example and copied it into the TOMCAT_HOME/conf/Catalina/localhost dir. I also copied a security.xml file from the HSQLDB J2M2 installation and adjusted the docBase value. Unfortunately, when I started Tomcat, I've got the same error: Caused by: org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs api.org.springframework.transaction.CannotCreateTransactionException: Could not create OJB transaction; nested exception is org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown while trying to get Connection from Datasource (java:comp/env/jdbc/jetspeed) at org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(Preference sFactoryImpl.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. ... And in the J2's log file: 2005-02-27 18:24:24 StandardContext[/jetspeed]StandardWrapper.Throwable java.lang.NullPointerException at org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876) at One thing that puzzles me (among others, of course) is that the 'j2' DB did not get populated while 'j2test' did... Here is my jetspeed.xml - lines that I changed: !-- HSQL dB username and password for dB connections -- parameter nameusername/name valueadmin/value /parameter parameter namepassword/name valueadmin/value /parameter !-- Class name for HSQL JDBC driver -- parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter !-- The JDBC connection url for connecting to your HSQL dB. -- parameter nameurl/name valuejdbc:mysql://127.0.0.1:3306/value /parameter /ResourceParams Thanks for looking into this! Marina --- [EMAIL PROTECTED] wrote: Marina, 3. jetspeed.xml there was no jetspeed.xml in the =TOMCAT_HOME/conf/Catalina/localhost dir The only jetspeed.xml files in the J2-project-home directory that I found were: maven-plugin/target/classes/plugin-resources/jetspeed.xml portal/src/resources/jetspeed.xml Should I manually edit one of them and copy into TOMCAT_HOME/conf/Catalina/localhost dir ? Since you manually copied the jetspeed.war into webapps, I assume you will need to do the same thing with the portal/src/resources/jetspeed.xml file. It is certainly simple enough to try! Is not it supposed to be done by the maven 'allBuild' goal? Well, so is copying jetspeed.war into webapps! :) Something is broken for sure, but I am just interesting in seeing if you can get it to run at all since you have taken it almost this far already. Yes, we are in the weeds at this point! Randy - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: using MySQL with J2 - setup problem
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
Re: using MySQL with J2 - setup problem
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
Re: using MySQL with J2 - setup problem
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
using MySQL with J2 - setup problem
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]
Re: using MySQL with J2 - setup problem
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]
Re: using MySQL with J2 - setup problem
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]
