Use a second database (MS SQL)

[Matthieu DELAHAIS <de...@yahoo.fr>]

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=cursor
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(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) 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.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) 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:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:368) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) 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:566) 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