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 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. -----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]
