Moving HSQL to MySQL

["Cheng Hok Man, Match" <ch...@hong-kong.sema.slb.com>]

Hi all,
	I was trying to move the HSQL to MySQL, I did the the following
changes in Torque.properties.
torque.database.default=default
### torque.database.default.adapter=hypersonic
torque.database.default.adapter=mysql

torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver
torque.dsfactory.default.connection.url =
jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.default.connection.user =  root
torque.dsfactory.default.connection.password = 

Then, I created a database Jetspeed in mysql. Run the script
turbine-mysql.sql and populate-mysql.sql in the database. 

Howevefr when I started DB again, I got the following errors:
Horrible Exception: java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory
configured for the connection default
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(Ba
seTurbineUserPeer.java:154)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(Bas
eTurbineUserPeer.java:128)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getU
ser(TurbineUserManagement.java:166)
at
org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUser
Management.java:98)
at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getA
nonymousUser(TurbineAuthentication.java:215)
at
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jet
speedAuthentication.java:107)
at
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedS
ecurity.java:159)
at
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(T
emplateSessionValidator.java:97)
at
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(J
etspeedSessionValidator.java:103)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.Turbine.doGet(Turbine.java:521)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

Did I miss something?

>-----Original Message-----
>From: Luta, Raphael (VUN) [mailto:Raphael.Luta@groupvu.Com] 
>Sent: Friday, December 13, 2002 4:28 PM
>To: 'Jetspeed Developers List'
>Subject: RE: DO NOT REPLY [Bug 15322] - UserManagement: 
>multiple runtimeinstances for the same user
>
>
>De : Sami Leino [mailto:sami.leino@netorek.fi]
>> 
>> > ------- Additional Comments From david@bluesunrise.com
>> 2002-12-12 17:58
>> > ------- I believe its not a turbine issue, since we removed
>> all turbine
>> > security  objects from Jetspeed in 1.4b1. Its appears to be
>> up to the
>> > Authentication  service to set this.
>> 
>> I found out the same thing when I took a look at the UserManagement 
>> interface. Fortunately I did that before I committed a bug report to 
>> the Turbine list. ;-)
>> 
>
>Sorry about that, I should have left David answer it first time :(
>
>--
>Raphaël Luta - raphael@apache.org
>Jakarta Jetspeed - Enterprise Portal in Java 
>http://jakarta.apache.org/jetspeed/
>
>--
>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>