[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jetspeed-user
Subject:    Re: Retry: Help needed to connect to MySQL
From:       James Lee <j27lee () yahoo ! com>
Date:       2002-05-30 15:43:34
[Download RAW message or body]

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 <walter@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:
> 
> > <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > > For additional commands, e-mail: 
> > > <mailto:jetspeed-user-help@jakarta.apache.org>
> > > 
> > > 
> > 
> > 
> > 
> > --
> > To unsubscribe, 
> > e-mail:  
> 
<mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail: 
> > <mailto:jetspeed-user-help@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:  
> 
<mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:jetspeed-user-help@jakarta.apache.org>
> 


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

--
To unsubscribe, e-mail:   <mailto:jetspeed-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-user-help@jakarta.apache.org>


[prev in list] [next in list] [prev in thread] [next in thread]