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 Jyothi Gangadharan <jg...@interchangedigital.com> on 2002/05/30 16:01:16 UTC
Help : Using jetspeed with MS Sql
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
some question about jetspeed security and turbine.
Posted by JiaoZhiping <zh...@aisipu.com>.
HELLO.can you give me some help.
I'm new to Jetspeed and Turbine .
Now we have a project.our goal is to replace the security of jetspeed
with j2ee security (jaas,ldap).
so i want to know how jetspeed work with turbine ,and it's security
framework.
i want to know how jetspeed work with turbine....relative
interface........is there some picture can describe it?
i have read some doucument at ibm website....but whether jetspeed
use the same security framework?
can you tell me some resource about this. (documentation about
jetspeed security framework and turbine)
Thanks a lot in advance !
joe
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Help : Using jetspeed with MS Sql
Posted by James Lee <j2...@yahoo.com>.
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
<jg...@interchangedigital.com> 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:
>
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>