Hi there....
In TurbineUserBuildMap it says:
All columns are there but not in the same column-order
as in the select-statement OR in the database
++++++++++++++++++ cut ~~~~~~~~~~~~~~~~~~~~++
tMap.setPrimaryKeyMethodInfo("TURBINE_USER");
tMap.addPrimaryKey("TURBINE_USER.USER_ID", new Integer(0));
tMap.addColumn("TURBINE_USER.LOGIN_NAME", new String());
tMap.addColumn("TURBINE_USER.PASSWORD_VALUE", new String());
tMap.addColumn("TURBINE_USER.FIRST_NAME", new String());
tMap.addColumn("TURBINE_USER.LAST_NAME", new String());
tMap.addColumn("TURBINE_USER.EMAIL", new String());
tMap.addColumn("TURBINE_USER.CONFIRM_VALUE", new String());
tMap.addColumn("TURBINE_USER.MODIFIED", new Date());
tMap.addColumn("TURBINE_USER.CREATED", new Date());
tMap.addColumn("TURBINE_USER.LAST_LOGIN", new Date());
tMap.addColumn("TURBINE_USER.DISABLED", new String());
tMap.addColumn("TURBINE_USER.OBJECTDATA", new Object());
tMap.addColumn("TURBINE_USER.PASSWORD_CHANGED", new Date());
~~~~~~~~~~~~~~~~~~ cut ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Any ideas why Turbine wont ackowlegs the "anon" user!?
>-----Urspr�ngliche Nachricht-----
>Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Gesendet: Dienstag, 1. April 2003 18:48
>An: [EMAIL PROTECTED]
>Betreff: RE: Want to switch DB to MS-SQL Server 2000 ...
>
>
>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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
