Not sure if this helps you, but here is what my torque.properties has: torque.database.default=default torque.database.default.adapter=mssql
## ## Using torque's old pool ## torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.default.connection.url = jdbc:microsoft:sqlserver://hqdbtest01:1433;DatabaseName=portal;SelectMethod= cursor torque.dsfactory.default.connection.user = SilverUserLogin torque.dsfactory.default.connection.password = password torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc eFactory # The number of database connections to cache per ConnectionPool instance (specified per database) torque.dsfactory.default.pool.defaultMaxConnections=10 torque.dsfactory.default.pool.maxExpiryTime=3600 torque.dsfactory.default.pool.connectionWaitTimeout=10 torque.database.efo.adapter=mssql ## ## Using torque's old pool ## torque.dsfactory.efo.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.efo.connection.url = jdbc:microsoft:sqlserver://hqdbtest01:1433;DatabaseName=portal;SelectMethod= cursor torque.dsfactory.efo.connection.user = SilverUserLogin torque.dsfactory.efo.connection.password = password torque.dsfactory.efo.factory=org.apache.torque.dsfactory.TorqueDataSourceFac tory # The number of database connections to cache per ConnectionPool instance (specified per database) torque.dsfactory.efo.pool.defaultMaxConnections=10 torque.dsfactory.efo.pool.maxExpiryTime=3600 torque.dsfactory.efo.pool.connectionWaitTimeout=10 While both of the connetions are to the same db, I have had them against two different ones as well. ERic -----Original Message----- From: Matthieu DELAHAIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 3:32 AM To: [EMAIL PROTECTED] Subject: Use a second database (MS SQL) Hi, I'm trying to add a second database on my jetspeed. So, I used the tutorial of torque to create my second database and I succeeded. So, I tried to had this database on my jetspeed. I configured the file torque.properties as follow : torque.dsfactory.devbib.adapter=mssql torque.dsfactory.devbib.createUrl = jdbc:microsoft:sqlserver://localhost:1433;databasename=sqlserver torque.dsfactory.devbib.buildUrl = jdbc:microsoft:sqlserver://localhost:1433;databasename=devbib torque.dsfactory.devbib.url = jdbc:microsoft:sqlserver://localhost:1433;databasename=devbib;SelectMethod=c ursor torque.dsfactory.devbib.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.devbib.user = bib torque.dsfactory.devbib.password = unis torque.dsfactory.devbib.host = unis14 Then, I tried to access some data of my database but I had this error : Horrible Exception: java.lang.NullPointerException: Connection object was null. This could be due to a misconfiguration of the DataSourceFactory. Check the logs and Torque.properties to better determine the cause. at org.apache.torque.util.Transaction.rollback(Transaction.java:179) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1333) at com.unis.om.BaseAuthorPeer.doSelectVillageRecords(BaseAuthorPeer.java:369) at com.unis.om.BaseAuthorPeer.doSelectVillageRecords(BaseAuthorPeer.java:336) at com.unis.om.BaseAuthorPeer.doSelect(BaseAuthorPeer.java:305) at org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:230 ) at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.Turbine.doGet(Turbine.java:509) at org.apache.turbine.Turbine.doPost(Turbine.java:658) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:368) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: 1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125 ) at java.lang.Thread.run(Thread.java:484) Anyone could help me? Thanks a lot... Matthieu --------------------------------- Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais ! Testez le nouveau Yahoo! Mail
