Hi,
I recently followed your instructions at stumod.com for implementing Jetspeed's psml into a DB2 environment. I wasn't successful.
I found that the bindings file in jetspeed has to be changed based on what Database you are using, so using maven I built the torque-om code from scratch, editing the project.properties file to use the db2400 option. This didn't change anything from what I can see.
The problem is, I get SQL exceptions when trying to login to jetspeed with the Database service configured to use the as400 db2. I think the statements that Torque is passing along is somewhat DB2 incompatible:
|
I'm attaching the entire stack trace so you can have a look at it, and perhaps shed some light on what I should do next.
(I also cc'd the jetspeed list, perhaps someone from this list might have any ideas?)
Thanks
______________________
Shawn Haworth
LWSI/WebDev Programmer
Reason:
org.apache.jetspeed.services.security.UserException: Failed to save
user object : java.sql.SQLException: [SQL0104] Token USER_ID was not valid.
Valid tokens: =.
Get/Post Data:
password = jetspeed
template = /html/ShowError.vm
action = JLoginUser
submit = Login
username = admin
Stacktrace:
org.apache.torque.TorqueException: java.sql.SQLException: [SQL0104]
Token USER_ID was not valid. Valid tokens: =.
at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1940)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1835)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doUpdate(BaseTurbineUserPeer.java:501)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doUpdate(BaseTurbineUserPeer.java:471)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser(TurbineUserManagement.java:245)
at
org.apache.jetspeed.services.JetspeedUserManagement.saveUser(JetspeedUserManagement.java:86)
at
org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
at
org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
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:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
rethrown as org.apache.jetspeed.services.security.UserException: Failed to save
user object : java.sql.SQLException: [SQL0104] Token USER_ID was not valid.
Valid tokens: =.
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser(TurbineUserManagement.java:250)
at
org.apache.jetspeed.services.JetspeedUserManagement.saveUser(JetspeedUserManagement.java:86)
at
org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
at
org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
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:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
