Re: using MySQL with J2 - setup problem

[Scott T. Weaver]

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
/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:
   
   
username
admin
   
   
password
admin
   
   
   
  driverClassName
  org.gjt.mm.mysql.Driver
   
   
   
 url
 jdbc:mysql://127.0.0.1:3306
   
 
Thanks for looking into this!
Marina
--- [EMAIL PROTECTED] wrote:
 

Marina,
   

3. jetspeed.xml
there was no jetspeed.xml in the
=/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
   

/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]> *
* *
* --  *
*   Apache Jetspeed Enterprise Portal *
* Apache Pluto Portlet Container  *
* *
* OpenEdit, Website Content Management*
*    *
***
-

Re: using MySQL with J2 - setup problem

[Marina]

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
> > /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:
> > 
> > 
> >  username
> >  admin
> > 
> > 
> >  password
> >  admin
> > 
> >
> > 
> > 
> >driverClassName
> >org.gjt.mm.mysql.Driver
> > 
> >
> > 
> > 
> >   url
> >   jdbc:mysql://127.0.0.1:3306
> > 
> >   
> >
> > Thanks for looking into this!
> > Marina
> >
> > --- [EMAIL PROTECTED] wrote:
> >
> >> Marina,
> >>
> >> > 3. jetspeed.xml
> >> > there was no jetspeed.xml in the
> >> > =/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
> >> > /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

[watler]

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
> /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:
> 
> 
>  username
>  admin
> 
> 
>  password
>  admin
> 
>
> 
> 
>driverClassName
>org.gjt.mm.mysql.Driver
> 
>
> 
> 
>   url
>   jdbc:mysql://127.0.0.1:3306
> 
>   
>
> Thanks for looking into this!
> Marina
>
> --- [EMAIL PROTECTED] wrote:
>
>> Marina,
>>
>> > 3. jetspeed.xml
>> > there was no jetspeed.xml in the
>> > =/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
>> > /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]

Re: using MySQL with J2 - setup problem

[Marina]

Thanks, Randy :)
I modified jetspeed.xml file using the one from a
working HSQL J2M2 installation as an example and
copied it into the
/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:


 username
 admin


 password
 admin




   driverClassName
   org.gjt.mm.mysql.Driver




  url
  jdbc:mysql://127.0.0.1:3306

  

Thanks for looking into this!
Marina

--- [EMAIL PROTECTED] wrote:

> Marina,
> 
> > 3. jetspeed.xml
> > there was no jetspeed.xml in the
> > =/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
> > /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

[watler]

Marina,

> 3. jetspeed.xml
> there was no jetspeed.xml in the
> =/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
> /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

[Marina]

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-MYSQL>maven
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
=/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
/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
/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
> /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=/conf/Catalina/localhost or
> tomcat4=/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 obta

Re: using MySQL with J2 - setup problem

[watler]

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
/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=/conf/Catalina/localhost or
tomcat4=/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:
>  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.AbstractAutowire

Re: using MySQL with J2 - setup problem

[Marina]

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:
 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.jets

Re: using MySQL with J2 - setup problem

[watler]

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:
>  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 no

Re: using MySQL with J2 - setup problem

[Marina]

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:
 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.jet

Re: using MySQL with J2 - setup problem

[Hema Menon]

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]

Re: using MySQL with J2 - setup problem

[Hema Menon]

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]

using MySQL with J2 - setup problem

[Marina]

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]