Hi there, i`ve tryed the select from the error message in the query analyser and it returned the "anon" user okay, as it should.
That troubled me so much that i asked this list for help finally... Refering to mapBuillder.java: Well i did not change anything in there, and i started from a new binary Distributon.... So i dont know what to look for an where in these 47 files that have "mapbuilder" in ist name... Do you have to build Jetspeed from source to use another database than the default hypersonic? The Howto-Installation guide is not really obvious at that point?!?! Any other suggestions what i should try? Would be really appreciated. Otherwise i`have to give up trying to use Jetspeed, and have to use whatever the other folks come around with.... Thanx! Yours christof >Are you successfully retrieving a record when you do it via >Query Analyzer? I originally had to insert an "anon" user. >Also, check I think it is the mapBuilder .java file that you >are using to see if somehow an extra column snuck in? > >Lastly, using profiler, grab the sql generated by jetspeed and >try that in Query analyzer. > >Eric > >-----Original Message----- >From: Ahrendt, Christof [mailto:[EMAIL PROTECTED] >Sent: Tuesday, April 01, 2003 10:19 AM >To: '[EMAIL PROTECTED]' >Subject: Want to switch DB to MS-SQL Server 2000 ... > > >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.SQL >ServerDriver >torque.database.default.url=jdbc:microsoft:sqlserver://localhos >t: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.SQLS >erverDriver >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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.TurbineAuthentica >tion.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]
