I've finally got it working. Here are the changes you need to make, this is for MS JDBC Driver (surprisingly free), though i'm sure you can configure for your driver:
database.default.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver database.default.url=jdbc:microsoft:sqlserver://<hostname>:<port>;SelectMethod=cursor database.default.username=sa database.default.password= database.adaptor=DBMSSQL database.adaptor.DBMSSQL=com.microsoft.jdbc.sqlserver.SQLServerDriver -------- this is using the build from may 27/28th... in the 1.3a2 build, the drivers and url are defined in TR.P file, in the more recent builds, its in Torque.P. The end of the URL "SelectMethod=cursor" is to resolve a cloned connection error: http://www.sqlmag.com/Forums/messageview.cfm?catid=22&threadid=166 hope this helps. james --- Jyothi Gangadharan <[EMAIL PROTECTED]> wrote: > Has anyone tried using MS Sql Database with Jetspeed > successfully?? > > I am using Type 4 i-net Sprinta2000 Driver that > supports JDBC2.0 . with MS > Sql Server Version 7,win2k , Tomcat 4.0 and Jdk1.4. > Before You go about insulting me, I got it working > with Hypersonic SQL > database. > > The steps I followed are as given below and ran into > problems.Can somebody > let me know if I am missing something?? > 1) Used Torque in src code to build the DB schema > 2) successfully created & populated the database. > 3) Made the changes to conf file as per > documentation > > Altered TR. properties File > # Database Settings > database.driver=com.inet.tds.TdsDriver > database.default.URL=jdbc:inetdae7:127.0.0.1:1433?database=jetspeed > database.default.username=sa > database.default.password= > #Adaptor > database.adaptor=DBMSSQL > database.adaptor.DBMSSQL=com.inet.tds.TdsDriver > > Don't know if this is Required > option 1) Altered jetspeed.resources > #services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService > services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService > services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService > > when I try to access the app from the browser. I get > a blank screen, and > checking the jetspeed.log saw that the message given > below was > continuously being written into it. > > -- INFO -- Waiting for init of > JetspeedProfilerService... > -- INFO -- Waiting for init of > JetspeedProfilerService... > -- INFO -- Waiting for init of > JetspeedProfilerService... > > option 2) With DEFAULT jetspeed.resources > services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService > #services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService > #services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService > > opening the app from the browser.I get a the initial > login screen.When I I > login I get a big nasty java Error > > -------------------------------------------------------------------------------- > > Horrible Exception: java.lang.Error: Error in > BasePeer.initTableSchema(TURBINE_USER): Connection > object is null! at > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:232) > at > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:194) > at > org.apache.turbine.om.security.peer.TurbineUserPeer.(TurbineUserPeer.java:175) > at > org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158) > at > org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246) > at > org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:312) > at > org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:199) > at > org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:111) > at > org.apache.turbine.modules.Action.perform(Action.java:87) > at > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > at > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:161) > at > org.apache.turbine.modules.Action.perform(Action.java:87) > at > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > at > org.apache.turbine.Turbine.doGet(Turbine.java:511) > at > org.apache.turbine.Turbine.doPost(Turbine.java:655) > 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 > rg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) > at > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) > 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 > rg.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) > 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.core.StandardPipeline.invoke(StandardPipeline.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > rg.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 > rg.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107) > at java.lang.Thread.run(Thread.java:536) > > -------------------------------------------------------------------------------- > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
