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.