Hi,
Could you post your Torque.properties file? I still get the following
error at logon:
org.apache.jetspeed.services.security.UserException: Failed to save user
object
when trying to use the default Hypersonic database with another MySql
database.
Could somebody help me?
Here is my Torque.properties file:
torque.database.default=default
torque.database.default.adapter=hypersonic
torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver
torque.dsfactory.default.connection.url =
jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed
torque.dsfactory.default.connection.user = sa
torque.dsfactory.default.connection.password =
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
## Our test database
torque.database.mydb.adapter=mysql
torque.dsfactory.mydb.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.mydb.connection.url = jdbc:mysql://127.0.0.1/test
torque.dsfactory.mydb.connection.user = root
torque.dsfactory.mydb.connection.password = *****
torque.dsfactory.mydb.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
torque.dsfactory.mydb.pool.defaultMaxConnections=10
torque.dsfactory.mydb.pool.maxExpiryTime=3600
torque.dsfactory.mydb.pool.connectionWaitTimeout=10
thanks,
Louis-Philippe Brochu
-----Original Message-----
From: Richard Berger
Subject: RE: Connecting to two databases - but with different adapters...
Date: Wed, 14 Jan 2004 11:40:00 -0800
Jeremy:
Somehow I missed your post - my apologies in the delayed response. I
had seen those posts and couldn't quite figure out what I was doing
wrong. However, with a pointer from Paul Mansfield the key problem was
that I was missing the "pool" properties below.
torque.dsfactory.jmetro.pool.defaultMaxConnections=10
torque.dsfactory.jmetro.pool.maxExpiryTime=3600
torque.dsfactory.jmetro.pool.connectionWaitTimeout=10
Just simple confusion on my part. Now I am using Hypersonic for the
login and have a Database Portlet talking to SQL Server on WebLogic.
Thanks much for your response!
RB
-----Original Message-----
From: Jeremy Ford [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 4:14 PM
To: 'Jetspeed Users List'
Subject: RE: Connecting to two databases - but with different
adapters...
Here a couple or threads regarding this issue. Hope this helps.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg09382.ht
ml
http://www.mail-archive.com/[EMAIL PROTECTED]/msg07522.ht
ml
Jeremy Ford
[EMAIL PROTECTED]
-----Original Message-----
From: Richard Berger [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 4:19 PM
To: [EMAIL PROTECTED]
Subject: RE: Connecting to two databases - but with different
adapters...
More information....
Here is a snippet from the Torque.properties files that works (with just
one DBMS) and then the equivalent snippet (comments uncommented) that
fails:
WORKS....
# Original Hypersonic properties
#torque.database.default=default
#torque.database.default.adapter=hypersonic
#torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver
#torque.dsfactory.default.connection.url =
jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed
#torque.dsfactory.default.connection.user = sa
#torque.dsfactory.default.connection.password =
#torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueData
SourceFactory
# SQL Server properties
torque.database.default=default
torque.database.default.adapter=weblogic
torque.dsfactory.default.connection.user = jmetro
torque.dsfactory.default.connection.password = jmetro
torque.dsfactory.default.connection.driver =
weblogic.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.default.connection.url =
jdbc:bea:sqlserver://localhost:1433;DatabaseName=jmetro
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS
ourceFactory
FAILS....
# Original Hypersonic properties
torque.database.default=default
torque.database.default.adapter=hypersonic
torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver
torque.dsfactory.default.connection.url =
jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed
torque.dsfactory.default.connection.user = sa
torque.dsfactory.default.connection.password =
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS
ourceFactory
# SQL Server properties
torque.database.default=default
torque.database.jmetro.adapter=weblogic
torque.dsfactory.jmetro.connection.user = jmetro
torque.dsfactory.jmetro.connection.password = jmetro
torque.dsfactory.jmetro.connection.driver =
weblogic.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.jmetro.connection.url =
jdbc:bea:sqlserver://localhost:1433;DatabaseName=jmetro
torque.dsfactory.jmetro.factory=org.apache.torque.dsfactory.TorqueDataSo
urceFactory
And when I try to login as turbine/turbine, the error I get is:
java.lang.NullPointerException
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1822)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1772)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doUpdate(Bas
eTurbineUserPeer.java:505)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doUpdate(Bas
eTurbineUserPeer.java:475)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.save
User(TurbineUserManagement.java:283)
rethrown as org.apache.jetspeed.services.security.UserException: Failed
to save user object at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.save
User(TurbineUserManagement.java:288
.
TIA for any help - I think that this must be doable....
RB
PS - Sorry if this reply gets treated as a new thread - I am not quite
sure how to add additional information to the thread
Twenty Years | One Mission | Accelerating Business Processes
Richard Berger
Action Technologies, Inc.
VP, Product Management
510.748.1017 (Office)
510.769.0596 (Fax)
www.actiontech.com
NOTE: The opinions expressed herein are those of the writer and not
necessarily those of Action Technologies, Inc. or its employees or its
affiliates.
---------------------------------------------------------------------
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]
