[JS1-98] [FIX] Jetspeed and DB2 field type mismatch

• Type: Bug
• Status: Resolved
• Resolution: Fixed
• Affects Version/s: 1.4b1
• Component/s: Database
• Environment: Operating System: Windows XP; Platform: PC
• Bugzilla Id: 11535
• Assignee: David Sean Taylor
• Reporter: Jason Richardson
• Created: 08/Aug/02 00:12
• Updated: 24/Mar/04 14:28
• Resolved: 24/Mar/04 14:28

Description

After running the db2 database scripts and populating the data. Starting up
jetspeed produces the following db2 exception in the log. It appears that
Jetspeed is confused on whether or not a field is numeric or varchar. Is this
someting that was done wrong in moving to db2. Or is it a bug in jetspeed?
What should the db field in question actually be?

--------
[11:01:34,656 INFO ] Start Initializing service (early): GroupManagement
[11:01:34,656 INFO ] Finish Initializing service (early): GroupManagement
[11:01:34,656 INFO ] Start Initializing service (early): PermissionManagement
[11:01:34,656 INFO ] Finish Initializing service (early): PermissionManagement
[11:01:34,656 INFO ] Start Initializing service (early): SecurityCache
[11:01:34,656 INFO ] Finish Initializing service (early): SecurityCache
[11:01:34,656 INFO ] Finished initializing all services!
[11:01:34,656 INFO ] Turbine: Completed HTTP initialization of services
[11:01:34,656 INFO ] Start Initializing service (late): UploadService
[11:01:34,656 INFO ] Finish Initializing service (late): UploadService
[11:01:34,671 INFO ] Start Initializing service (late): AssemblerBrokerService
[11:01:34,687 INFO ] Finish Initializing service (late): AssemblerBrokerService
[11:01:34,812 INFO ] IDBroker thread was started.
[11:01:35,125 DEBUG] SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME,
TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME,
TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED,
TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.DISABLED,
TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE (TURBINE_USER.LOGIN_NAME='anon')
[11:01:35,125 DEBUG] Elapsed time=0 ms
[11:01:35,171 DEBUG] JetspeedRunDataService: accessing rundata
org.apache.jetspeed.services.rundata.DefaultJetspeedRunData@57222110 for
thread: 10
[11:01:35,187 DEBUG] SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME,
TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME,
TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED,
TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.DISABLED,
TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE (TURBINE_USER.LOGIN_NAME='anon')
[11:01:35,187 DEBUG] Elapsed time=0 ms
[11:01:35,218 DEBUG] SELECT TURBINE_USER_GROUP_ROLE.USER_ID,
TURBINE_USER_GROUP_ROLE.GROUP_ID, TURBINE_USER_GROUP_ROLE.ROLE_ID FROM
TURBINE_USER_GROUP_ROLE WHERE (TURBINE_USER_GROUP_ROLE.USER_ID='3')
[11:01:35,265 ERROR] Turbine.handleException: Failed to get anonymous user:
org.apache.jetspeed.services.security.RoleException: Failed to retrieve roles :
[IBM][CLI Driver][DB2/LINUX] SQL0401N The data types of the operands for the
operation "=" are not compatible. SQLSTATE=42818

[11:01:35,265 ERROR]
org.apache.jetspeed.services.security.LoginException: Failed to get anonymous
user: org.apache.jetspeed.services.security.RoleException: Failed to retrieve
roles : [IBM][CLI Driver][DB2/LINUX] SQL0401N The data types of the operands
for the operation "=" are not compatible. SQLSTATE=42818
at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnonymous
User(TurbineAuthentication.java:194)
at org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser
(JetspeedAuthentication.java:107)
at org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser
(JetspeedSecurity.java:157)
at
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform
(TemplateSessionValidator.java:97)
at
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform
(JetspeedSessionValidator.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:468)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService
(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service
(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service
(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service
(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service
(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch
(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch
(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:523)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch
(WebAppRequestDispatcher.java:282)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward
(WebAppRequestDispatcher.java:112)
at org.apache.jasper.runtime.PageContextImpl.forward
(PageContextImpl.java:498)
at _index_jsp_0._jspService(index.jsp )
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service
(JspServlet.java:300)
at org.apache.jasper.runtime.JspServlet.serviceJspFile
(JspServlet.java:430)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:565)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService
(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service
(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service
(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service
(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service
(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch
(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch
(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:523)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch
(WebAppRequestDispatcher.java:282)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward
(WebAppRequestDispatcher.java:112)
at com.ibm.servlet.engine.webapp.SimpleFileServlet.doGet
(SimpleFileServlet.java:223)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService
(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service
(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service
(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service
(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service
(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch
(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch
(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:523)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch
(WebAppRequestDispatcher.java:282)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward
(WebAppRequestDispatcher.java:112)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward
(WebAppInvoker.java:91)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook
(WebAppInvoker.java:184)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation
(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI
(ServletRequestProcessor.java:122)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service
(OSEListener.java:315)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest
(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest
(HttpConnection.java:323)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
[11:01:35,640 INFO ] Start Initializing service (late): LocalizationService
[11:01:35,640 INFO ] Finish Initializing service (late): LocalizationService
[11:01:35,687 ERROR] Error rendering Velocity template: layouts/default.vm:
Unable to find resource 'layouts/default.vm'
[11:01:35,687 ERROR] Error rendering Velocity template: layouts/default.vm:
Unable to find resource 'layouts/default.vm'
org.apache.velocity.exception.ResourceNotFoundException: Unable to find
resource 'layouts/default.vm'
at org.apache.velocity.runtime.resource.ResourceManagerImpl.loadResource
(ResourceManagerImpl.java:501)
at org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource
(ResourceManagerImpl.java:384)
at org.apache.velocity.runtime.RuntimeInstance.getTemplate
(RuntimeInstance.java:812)
at org.apache.velocity.runtime.RuntimeSingleton.getTemplate
(RuntimeSingleton.java:355)
at org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:482)
at org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:461)
org.apache.turbine.util.TurbineException: Error rendering Velocity template:
layouts/default.vm: Unable to find resource 'layouts/default.vm'
at
org.apache.turbine.services.velocity.TurbineVelocityService.renderingError
(TurbineVelocityService.java:524)
at
org.apache.turbine.services.velocity.TurbineVelocityService.decodeRequest
(TurbineVelocityService.java:490)
at
org.apache.turbine.services.velocity.TurbineVelocityService.handleRequest
(TurbineVelocityService.java:327)
at org.apache.turbine.services.velocity.TurbineVelocity.handleRequest
(TurbineVelocity.java:146)
at org.apache.turbine.modules.layouts.VelocityDirectLayout.doBuild
(VelocityDirectLayout.java:106)
at org.apache.turbine.modules.Layout.build(Layout.java:91)
at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:123)
at org.apache.turbine.modules.pages.DefaultPage.doBuild
(DefaultPage.java:169)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.handleException(Turbine.java:670)
at org.apache.turbine.Turbine.doGet(Turbine.java:575)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService
(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service
(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service
(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service
(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service
(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch
(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch
(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:523)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch
(WebAppRequestDispatcher.java:282)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward
(WebAppRequestDispatcher.java:112)
at org.apache.jasper.runtime.PageContextImpl.forward
(PageContextImpl.java:498)
at _index_jsp_0._jspService(index.jsp )
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service
(JspServlet.java:300)
at org.apache.jasper.runtime.JspServlet.serviceJspFile
(JspServlet.java:430)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:565)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService
(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service
(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service
(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service
(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service
(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch
(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch
(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:523)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch
(WebAppRequestDispatcher.java:282)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward
(WebAppRequestDispatcher.java:112)
at com.ibm.servlet.engine.webapp.SimpleFileServlet.doGet
(SimpleFileServlet.java:223)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService
(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service
(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service
(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service
(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service
(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch
(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch
(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch
(WebAppRequestDispatcher.java:523)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch
(WebAppRequestDispatcher.java:282)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward
(WebAppRequestDispatcher.java:112)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward
(WebAppInvoker.java:91)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook
(WebAppInvoker.java:184)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation
(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI
(ServletRequestProcessor.java:122)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service
(OSEListener.java:315)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest
(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest
(HttpConnection.java:323)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
[11:01:35,953 DEBUG] JetspeedRunDataService: releasing rundata for thread: 10