Could have just been the way the mail program was wrapping the lines, but the way it showed up on my screen was that several of the lines in your properties file appeared to be all on one line. Probably nothing.
I have definitely run into that same error when I was using mySQL. I remember solving it by fixing my torque.properties file. But everything about your file looks fine to me. Is your mySQL jar file in the right place (although that would give a ClassDefNotFound type error). Hmmm.... I can't think of any useful suggestions other than seeing how far you can follow the code in the debugger. I will send you my torque.properties file for mySQL tonight (PST). 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 10:37 AM To: Jetspeed Users List Subject: RE: Connecting to two databases - but with different adapters... 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.TorqueDat > aS > 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.TorqueData > So > 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.TorqueDat > aS > 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.TorqueDataSo > ur > 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.TorqueDa > ta > 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.TorqueDat > aS > 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.TorqueDat > aS > 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.TorqueData > So > 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(B > as > eTurbineUserPeer.java:505) > at > org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doUpdate(B > as > eTurbineUserPeer.java:475) > at > org.apache.jetspeed.services.security.turbine.TurbineUserManagement.sa > ve > 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.sa > ve > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
