Thank you so much! I just forgot to copy the mySQL jar file. I was under the (wrong) impression that Jetspeed came with all the databases drivers it supported.
That also explains why i wasn't able to configure mySQL for the default database as well. Thank you again :) > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
