You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Walter Gamba <wa...@e-gramma.net> on 2002/05/29 15:09:16 UTC
Retry: Help needed to connect to MySQL
Hello,
since nobody could answer my first post, I'll try one last time before
losing all hope and wrinting my portal from scratch :)
I can not make JEtspeed connect to MySQL.
Before ou insult me please note that:
0) I've RTFM
1) Jetspeed works ok with HypersonicSQL
2) Jestpeed worked within minutes with Oracle using Oracle's Thin drivers.
Configuration was very similar to the one made for MySQL
3) mm.mysql-2.0.14-bin.jar is in tomcat/lib directory as well as in
jetspeed/WEB-INF/lib dir
4) the turbine property file is configured as per Docuemtnation
5) I've created tables using scripts and populated them
6) i can connnect to MySQL inside a portlet (java) code by loading myself
the driver, but -again-not using a Turbine DBPool
My test system is win2k with JDK1.3.1 and tomcat 3.2.1 and jetspeed 1.3.a2.
Jdbc driver is mm.mysql-2.0.14
MySQL is 3.23.49max
This is my TR.prop section
database.default.driver=org.gjt.mm.mysql.Driver
database.default.url=jdbc:mysql://localhost/turbine
database.default.username=turbine
database.default.password=turbine
database.adaptor=MMSQL
database.adaptor.MMSQL=org.gjt.mm.mysql.Driver
I alwyas get the same error:
Horrible Exception: java.lang.ExceptionInInitializerError:
java.lang.NullPointerException
at
org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(TurbineUserPeer.java:99)
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
and subsequent calls get
Horrible Exception: java.lang.NoClassDefFoundError
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246)
at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:312)
with the log saying
[Tue May 28 18:36:32 GMT+02:00 2002] -- ERROR -- BasePeer.MapBuilder failed
trying to instantiate: org.apache.turbine.util.db.map.TurbineMapBuilder
Exception: org.apache.turbine.util.TurbineException: Unknown JDBC
driver: org.gjt.mm.mysql.Driver: Check your configuration file
Stack Trace follows:
java.lang.InstantiationException: Unknown JDBC driver:
org.gjt.mm.mysql.Driver: Check your configuration file
and so on..
Any help, any hint will be appreciated. I've seen a post with a quewstion
almost like mine, but nobody came up with a resoultive solution..
I gather that, since it can load Oracle's driver and connect to the DB, the
proble is somewhere between the JDBC driver and MySQL??
Detailed info can be found in my prevoius post.
THis is my ;last hope :)
Thanks for any, any kind of help
Walter Gamba
Walter Gamba
walter@e-gramma.it
E-Gramma srl
via Palazzo di Citta' 8 - 10122 TORINO
tel 011-5136583 fax 011-5136582
www.e-gramma.it
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Retry: Help needed to connect to MySQL
Posted by James Lee <j2...@yahoo.com>.
Where can i find this closed set of names? Is there
syntax to making this work? I'm currently trying to
configure jetspeed to work with MS SQL Server 2000
using the MS JDBC Driver.
Any ideas?
thanks in advance
james
--- Walter Gamba <wa...@e-gramma.net> wrote:
> At 13.50 30/05/2002 +0530, you wrote:
> >Make sure you enter the port number too like...
> >database.default.driver=org.gjt.mm.mysql.Driver
>
>database.default.url=jdbc:mysql://localhost:3306/turbine
> >
> >and try this adaptor...
>
> THanks to the many replies,
> it apperas that one HAS to put certain names in
> database.adaptor, as you
> and many other suggested, and not just a menominc.
> The problm was that I've never read that adaptor
> names should be picked in
> a closed set, and not invented :)
>
> Thanks a lot
>
> Walter
>
> >database.adaptor=DBMM
> >database.adaptor.DBMM=org.gjt.mm.mysql.Driver
> >
> >-Anand
> >
> >Walter Gamba wrote:
> >
> >>Hello,
> >>
> >>since nobody could answer my first post, I'll try
> one last time before
> >>losing all hope and wrinting my portal from
> scratch :)
> >>
> >>I can not make JEtspeed connect to MySQL.
> >>Before ou insult me please note that:
> >>0) I've RTFM
> >>1) Jetspeed works ok with HypersonicSQL
> >>2) Jestpeed worked within minutes with Oracle
> using Oracle's Thin
> >>drivers. Configuration was very similar to the one
> made for MySQL
> >>3) mm.mysql-2.0.14-bin.jar is in tomcat/lib
> directory as well as in
> >>jetspeed/WEB-INF/lib dir
> >>4) the turbine property file is configured as per
> Docuemtnation
> >>5) I've created tables using scripts and populated
> them
> >>6) i can connnect to MySQL inside a portlet (java)
> code by loading myself
> >>the driver, but -again-not using a Turbine DBPool
> >>
> >>My test system is win2k with JDK1.3.1 and tomcat
> 3.2.1 and jetspeed
> >>1.3.a2. Jdbc driver is mm.mysql-2.0.14
> >>MySQL is 3.23.49max
> >>
> >>This is my TR.prop section
> >>database.default.driver=org.gjt.mm.mysql.Driver
>
>>database.default.url=jdbc:mysql://localhost/turbine
> >>database.default.username=turbine
> >>database.default.password=turbine
> >>
> >>database.adaptor=MMSQL
> >>database.adaptor.MMSQL=org.gjt.mm.mysql.Driver
> >>
> >>
> >>I alwyas get the same error:
> >>Horrible Exception:
> java.lang.ExceptionInInitializerError:
> >>java.lang.NullPointerException
> >>at
>
>>org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(TurbineUserPeer.java:99)
>
> >>
> >>at
>
>>org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
>
> >>
> >>
> >>and subsequent calls get
> >>
> >>Horrible Exception: java.lang.NoClassDefFoundError
> >>at
>
>>org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
>
> >>
> >>at
>
>>org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246)
>
> >>
> >>at
>
>>org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:312)
>
> >>
> >>
> >>with the log saying
> >>[Tue May 28 18:36:32 GMT+02:00 2002] -- ERROR --
> BasePeer.MapBuilder
> >>failed trying to instantiate:
> org.apache.turbine.util.db.map.TurbineMapBuilder
> >> Exception:
> org.apache.turbine.util.TurbineException: Unknown
> >> JDBC driver: org.gjt.mm.mysql.Driver: Check your
> configuration file
> >> Stack Trace follows:
> >> java.lang.InstantiationException: Unknown
> JDBC driver:
> >> org.gjt.mm.mysql.Driver: Check your configuration
> file
> >>and so on..
> >>
> >>
> >>
> >>Any help, any hint will be appreciated. I've seen
> a post with a quewstion
> >>almost like mine, but nobody came up with a
> resoultive solution..
> >>
> >>I gather that, since it can load Oracle's driver
> and connect to the DB,
> >>the proble is somewhere between the JDBC driver
> and MySQL??
> >>
> >>Detailed info can be found in my prevoius post.
> >>
> >>THis is my ;last hope :)
> >>Thanks for any, any kind of help
> >>
> >>Walter Gamba
> >>
> >>Walter Gamba
> >>walter@e-gramma.it
> >>E-Gramma srl
> >>via Palazzo di Citta' 8 - 10122 TORINO
> >>tel 011-5136583 fax 011-5136582
> >>www.e-gramma.it
> >>
> >>
> >>--
> >>To unsubscribe, e-mail:
>
>><ma...@jakarta.apache.org>
> >>For additional commands, e-mail:
> >><ma...@jakarta.apache.org>
> >>
> >>
> >
> >
> >
> >--
> >To unsubscribe,
> >e-mail:
>
<ma...@jakarta.apache.org>
> >For additional commands, e-mail:
> ><ma...@jakarta.apache.org>
> >
>
> Walter Gamba
> walter@e-gramma.it
> E-Gramma srl
> via Palazzo di Citta' 8 - 10122 TORINO
> tel 011-5136583 fax 011-5136582
> www.e-gramma.it
>
>
> --
> To unsubscribe, e-mail:
>
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Retry: Help needed to connect to MySQL
Posted by Walter Gamba <wa...@e-gramma.net>.
At 13.50 30/05/2002 +0530, you wrote:
>Make sure you enter the port number too like...
>database.default.driver=org.gjt.mm.mysql.Driver
>database.default.url=jdbc:mysql://localhost:3306/turbine
>
>and try this adaptor...
THanks to the many replies,
it apperas that one HAS to put certain names in database.adaptor, as you
and many other suggested, and not just a menominc.
The problm was that I've never read that adaptor names should be picked in
a closed set, and not invented :)
Thanks a lot
Walter
>database.adaptor=DBMM
>database.adaptor.DBMM=org.gjt.mm.mysql.Driver
>
>-Anand
>
>Walter Gamba wrote:
>
>>Hello,
>>
>>since nobody could answer my first post, I'll try one last time before
>>losing all hope and wrinting my portal from scratch :)
>>
>>I can not make JEtspeed connect to MySQL.
>>Before ou insult me please note that:
>>0) I've RTFM
>>1) Jetspeed works ok with HypersonicSQL
>>2) Jestpeed worked within minutes with Oracle using Oracle's Thin
>>drivers. Configuration was very similar to the one made for MySQL
>>3) mm.mysql-2.0.14-bin.jar is in tomcat/lib directory as well as in
>>jetspeed/WEB-INF/lib dir
>>4) the turbine property file is configured as per Docuemtnation
>>5) I've created tables using scripts and populated them
>>6) i can connnect to MySQL inside a portlet (java) code by loading myself
>>the driver, but -again-not using a Turbine DBPool
>>
>>My test system is win2k with JDK1.3.1 and tomcat 3.2.1 and jetspeed
>>1.3.a2. Jdbc driver is mm.mysql-2.0.14
>>MySQL is 3.23.49max
>>
>>This is my TR.prop section
>>database.default.driver=org.gjt.mm.mysql.Driver
>>database.default.url=jdbc:mysql://localhost/turbine
>>database.default.username=turbine
>>database.default.password=turbine
>>
>>database.adaptor=MMSQL
>>database.adaptor.MMSQL=org.gjt.mm.mysql.Driver
>>
>>
>>I alwyas get the same error:
>>Horrible Exception: java.lang.ExceptionInInitializerError:
>>java.lang.NullPointerException
>>at
>>org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(TurbineUserPeer.java:99)
>>
>>at
>>org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
>>
>>
>>and subsequent calls get
>>
>>Horrible Exception: java.lang.NoClassDefFoundError
>>at
>>org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
>>
>>at
>>org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246)
>>
>>at
>>org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:312)
>>
>>
>>with the log saying
>>[Tue May 28 18:36:32 GMT+02:00 2002] -- ERROR -- BasePeer.MapBuilder
>>failed trying to instantiate: org.apache.turbine.util.db.map.TurbineMapBuilder
>> Exception: org.apache.turbine.util.TurbineException: Unknown
>> JDBC driver: org.gjt.mm.mysql.Driver: Check your configuration file
>> Stack Trace follows:
>> java.lang.InstantiationException: Unknown JDBC driver:
>> org.gjt.mm.mysql.Driver: Check your configuration file
>>and so on..
>>
>>
>>
>>Any help, any hint will be appreciated. I've seen a post with a quewstion
>>almost like mine, but nobody came up with a resoultive solution..
>>
>>I gather that, since it can load Oracle's driver and connect to the DB,
>>the proble is somewhere between the JDBC driver and MySQL??
>>
>>Detailed info can be found in my prevoius post.
>>
>>THis is my ;last hope :)
>>Thanks for any, any kind of help
>>
>>Walter Gamba
>>
>>Walter Gamba
>>walter@e-gramma.it
>>E-Gramma srl
>>via Palazzo di Citta' 8 - 10122 TORINO
>>tel 011-5136583 fax 011-5136582
>>www.e-gramma.it
>>
>>
>>--
>>To unsubscribe, e-mail:
>><ma...@jakarta.apache.org>
>>For additional commands, e-mail:
>><ma...@jakarta.apache.org>
>>
>>
>
>
>
>--
>To unsubscribe,
>e-mail: <ma...@jakarta.apache.org>
>For additional commands, e-mail:
><ma...@jakarta.apache.org>
>
Walter Gamba
walter@e-gramma.it
E-Gramma srl
via Palazzo di Citta' 8 - 10122 TORINO
tel 011-5136583 fax 011-5136582
www.e-gramma.it
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Retry: Help needed to connect to MySQL
Posted by Anandkumar Ayyachamy <an...@eself.com>.
Make sure you enter the port number too like...
database.default.driver=org.gjt.mm.mysql.Driver
database.default.url=jdbc:mysql://localhost:3306/turbine
and try this adaptor...
database.adaptor=DBMM
database.adaptor.DBMM=org.gjt.mm.mysql.Driver
-Anand
Walter Gamba wrote:
> Hello,
>
> since nobody could answer my first post, I'll try one last time before
> losing all hope and wrinting my portal from scratch :)
>
> I can not make JEtspeed connect to MySQL.
> Before ou insult me please note that:
> 0) I've RTFM
> 1) Jetspeed works ok with HypersonicSQL
> 2) Jestpeed worked within minutes with Oracle using Oracle's Thin
> drivers. Configuration was very similar to the one made for MySQL
> 3) mm.mysql-2.0.14-bin.jar is in tomcat/lib directory as well as in
> jetspeed/WEB-INF/lib dir
> 4) the turbine property file is configured as per Docuemtnation
> 5) I've created tables using scripts and populated them
> 6) i can connnect to MySQL inside a portlet (java) code by loading
> myself the driver, but -again-not using a Turbine DBPool
>
> My test system is win2k with JDK1.3.1 and tomcat 3.2.1 and jetspeed
> 1.3.a2. Jdbc driver is mm.mysql-2.0.14
> MySQL is 3.23.49max
>
> This is my TR.prop section
> database.default.driver=org.gjt.mm.mysql.Driver
> database.default.url=jdbc:mysql://localhost/turbine
> database.default.username=turbine
> database.default.password=turbine
>
> database.adaptor=MMSQL
> database.adaptor.MMSQL=org.gjt.mm.mysql.Driver
>
>
> I alwyas get the same error:
> Horrible Exception: java.lang.ExceptionInInitializerError:
> java.lang.NullPointerException
> at
> org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(TurbineUserPeer.java:99)
>
> at
> org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
>
>
> and subsequent calls get
>
> Horrible Exception: java.lang.NoClassDefFoundError
> at
> org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
>
> at
> org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246)
>
> at
> org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:312)
>
>
> with the log saying
> [Tue May 28 18:36:32 GMT+02:00 2002] -- ERROR -- BasePeer.MapBuilder
> failed trying to instantiate:
> org.apache.turbine.util.db.map.TurbineMapBuilder
> Exception: org.apache.turbine.util.TurbineException: Unknown
> JDBC driver: org.gjt.mm.mysql.Driver: Check your configuration file
> Stack Trace follows:
> java.lang.InstantiationException: Unknown JDBC driver:
> org.gjt.mm.mysql.Driver: Check your configuration file
> and so on..
>
>
>
> Any help, any hint will be appreciated. I've seen a post with a
> quewstion almost like mine, but nobody came up with a resoultive
> solution..
>
> I gather that, since it can load Oracle's driver and connect to the
> DB, the proble is somewhere between the JDBC driver and MySQL??
>
> Detailed info can be found in my prevoius post.
>
> THis is my ;last hope :)
> Thanks for any, any kind of help
>
> Walter Gamba
>
> Walter Gamba
> walter@e-gramma.it
> E-Gramma srl
> via Palazzo di Citta' 8 - 10122 TORINO
> tel 011-5136583 fax 011-5136582
> www.e-gramma.it
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>