On startup of Jetspeed I get the following exception in the log:
[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]
------
as you can see it thinks that TURBINE_USER_GROUP_ROLE.USER_ID is a
varchar, or it is attempting to put single ticks around the number 3.
The contents of my Torque.properties is below. Am I missing something
here? How can this problem be resolved?
#----
#database.default=default
#database.default.driver=org.hsql.jdbcDriver
#database.default.url=jdbc:HypersonicSQL:${webappRoot}/WEB-INF/db/jetspeed
#database.default.username=sa
#database.default.password=
#----
database.default=default
database.default.driver=COM.ibm.db2.jdbc.app.DB2Driver
database.default.url=jdbc:db2:JSTEST
database.default.username=testdb
database.default.password=testdb
-----------------------------------------------------------
Jason Richardson
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
