Thanks for the fast reply.
What do you mean by line breaks? Also, my user has correct permissions
because i can log in in mysql fine.
I found out that i can get to the page after the "failed to save" error.
When i try to run my portlet which access my other database i get the
following error:
java.lang.NullPointerException: There was no DataSourceFactory configured
for the connection mydb
It looks like something in my config file is not correct... but what?
> Here you go, trying to focus on the relevant sections. Note: when I
> looked at your information, there seemed to be missing line breaks, but
> I don't know if that would cause any problems.
>
> # -------------------------------------------------------------------
> #
> # T O R Q U E P R O P E R T I E S
> #
> torque.database.default=default
> torque.database.default.adapter=hypersonic
> ##
> ## Using torque's old pool
> ##
> 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
> torque.dsfactory.default.pool.defaultMaxConnections=10
> torque.dsfactory.default.pool.maxExpiryTime=3600
> torque.dsfactory.default.pool.connectionWaitTimeout=10
>
> ### JMetro on WebLogic
> torque.database.jmetro.adapter=weblogic
> torque.dsfactory.jmetro.factory=org.apache.torque.dsfactory.TorqueDataSo
> urceFactory
> torque.dsfactory.jmetro.connection.driver
> weblogic.jdbc.sqlserver.SQLServerDriver
> torque.dsfactory.jmetro.connection.url
> jdbc:bea:sqlserver://localhost:1433;DatabaseName=jmetro
> torque.dsfactory.jmetro.connection.user = jmetro
> torque.dsfactory.jmetro.connection.password = *****
> torque.dsfactory.jmetro.pool.defaultMaxConnections=10
> torque.dsfactory.jmetro.pool.maxExpiryTime=3600
> torque.dsfactory.jmetro.pool.connectionWaitTimeout=10
>
> I also have a mysql version, but that is at home, so it will be while
> before I can get to it. Please let me know if you need that one. Other
> things to consider - is the password correct and does that user have
> appropriate access/permissions to the tables you are trying to access.
>
> Good luck!
> 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: Louis-Philippe Brochu [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 20, 2004 9:14 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Connecting to two databases - but with different
> adapters...
>
> 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.TorqueDataS
> ourceFactory
> 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.TorqueDataSour
> ceFactory
> 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]
>
>
>
>
> ---------------------------------------------------------------------
> 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]
