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]>
