You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Celeste Haseltine <CH...@unifocus.com> on 2003/10/15 23:11:10 UTC
Setting up Jetspeed with MS SQL Server
I'm new to Jetspeed, and I have searched the jetspeed mailing list with no
luck, so I am hoping someone can point out to me where I am going wrong.
I have done the following:
1. Run the SQL Server scripts to create and populate the database.
2. Built the war file using the ant build.xml file located in the
C:jetspeed\build directory.
2. Put the MS SQL Server driver in both the C:\Tomcat
4.1\webapps\jetspeed\WEB-INF\lib and the C:\Tomcat 4.1\common\lib
directories
3. Modified the torque.properties file as follows:
torque.database.default.adapter=mssql
torque.dsfactory.default.connection.driver =
com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.default.connection.url =
jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=jetspeed
torque.dsfactory.default.connection.user = sa
torque.dsfactory.default.connection.password = sa
The error I am getting when I attempt to go to the jetspeed home page (i.e.
http://localhost:8080/jetspeed is listed below. Does anyone have any idea
of what I am doing wrong?
Thank you in advance for any assistance offered.
Celeste Haseltine
Error recieved:
Horrible Exception: java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory
configured for the connection default
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTu
rbineUserPeer.java:154)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTur
bineUserPeer.java:128)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(
TurbineUserManagement.java:166)
at
org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMana
gement.java:97)
at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnony
mousUser(TurbineAuthentication.java:212)
at
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspee
dAuthentication.java:102)
at
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecur
ity.java:174)
at
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Templ
ateSessionValidator.java:97)
at
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jetsp
eedSessionValidator.java:103)
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:521)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:684)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch
er.java:432)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher
.java:356)
at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
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:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
at java.lang.Thread.run(Thread.java:534)
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: Setting up Jetspeed with MS SQL Server
Posted by Holger Dewes <h....@insiders.de>.
> -----Original Message-----
> From: Celeste Haseltine [mailto:CHaseltine@unifocus.com]
> Sent: Wednesday, October 15, 2003 11:11 PM
> To: 'jetspeed-user@jakarta.apache.org'
> Subject: Setting up Jetspeed with MS SQL Server
> Importance: High
>
>
> I'm new to Jetspeed, and I have searched the jetspeed mailing
> list with no luck, so I am hoping someone can point out to me
> where I am going wrong.
>
> I have done the following:
>
> 1. Run the SQL Server scripts to create and populate the
> database. 2. Built the war file using the ant build.xml file
> located in the C:jetspeed\build directory. 2. Put the MS SQL
> Server driver in both the C:\Tomcat
> 4.1\webapps\jetspeed\WEB-INF\lib and the C:\Tomcat
> 4.1\common\lib directories 3. Modified the torque.properties
> file as follows:
> torque.database.default.adapter=mssql
> torque.dsfactory.default.connection.driver =
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> torque.dsfactory.default.connection.url =
> jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=jetspeed
> torque.dsfactory.default.connection.user = sa
> torque.dsfactory.default.connection.password = sa
>
Hello Celeste,
I'm using jetspeed with MS-SQL and it works fine. I cannot really say
what is wrong, the only differences I noticed between your
torque.properties and mine is that in my properties it is
"DatabaseName=jetspeed" (with a small 'b', but I don't know if these
properties are case sensitive), and my db has no password.
For me, it even worked without having to rebuild the war.
Cheers
--
Holger Dewes
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org