HI There,
Im trying to switch databaswes on the
1.4-b4 fullwar distribution.
Tryin to change from the default-hypersonic
to our own MS-SQL 2000 DB.
Using the ms-jdbc driver.
Edited the torque.properties to the following:
~~~~~~~~~~~~~+ cut here ~~~~~~~~~~~~~~~~~~
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=
torque.database.default.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.database.default.url=jdbc:microsoft:sqlserver://localhost:1433;Databa
seName=XXX;SelectMethod=cursor
torque.database.default.username=XXXadmin
torque.database.default.password=xxxadmin
torque.database.adaptor=MSSQL
torque.database.adaptor.MSSQL=com.microsoft.jdbc.sqlserver.SQLServerDriver
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ cut ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Used the create db*.sql and populate.sql script from the src distribution.
Those scripts seemed to have some errors, but finally found some corrected
skripts
in the cvs-tree.
So i`ve populated my sql-server with the coffeshop example
and all the user rights restarting jetspeed i get this out of the
jetspeed-log file....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ cut here ~~~~~~~~~~~~~~~~
16:42:56,828 INFO ] IDBroker thread was started.
[16:42:57,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')
[16:42:57,187 DEBUG] Elapsed time=15 ms
[16:42:57,250 ERROR] Turbine.handleException: Failed to get anonymous user:
org.apache.jetspeed.services.security.UserException: Failed to retrieve user
'anon': Only 12 columns exist!
[16:42:57,250 ERROR]
org.apache.jetspeed.services.security.LoginException: Failed to get
anonymous user: org.apache.jetspeed.services.security.UserException: Failed
to retrieve user 'anon': Only 12 columns exist!
at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnony
mousUser(TurbineAuthentication.java:1
~~~~~~~~~~~~~~~~~ a lot of stackdump follows
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As far as i can see, the select statement selects 12 columns,
but why does 'jetspeed.services.security' complain about that?
The same select statement works fine in the Query-Analyser.
Some columns contain NULL-Values though.
Any suggestions? Any conceptional issue that one has to be aware of?
Mit freundlichen Gr��en / With kind regards
Christof Ahrendt
Mailto:[EMAIL PROTECTED]
------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
