Hi,
I'm using Turbine 2.1 and wat to use it's security module in an
application.
I'm experiencing problem while getting new users into TURBINE_USER.
Postgres 7.1.3 is beeing used as the data store.
Java 1.3.x is the JVM and the systems this is been used on are
Linux with 2.4 kernels on i386 and powerpc
This is the stacktrace:
==================================================
[Thu Feb 14 17:50:14 CET 2002] -- DEBUG -- Refreshing UI manager
[Thu Feb 14 17:50:14 CET 2002] -- ERROR -- Cannot load skin: default
[Thu Feb 14 17:50:19 CET 2002] -- ERROR -- Het usr object:fghfgh pipo
deClown
[Thu Feb 14 17:50:19 CET 2002] -- 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.OBJECTDATA FROM TURBINE_USER WHERE
(TURBINE_USER.LOGIN_NAME='fghfgh')
[Thu Feb 14 17:50:19 CET 2002] -- INFO -- Forced id retrieval - no
available vector
[Thu Feb 14 17:50:19 CET 2002] -- DEBUG -- BasePeer.doUpdate:
whereClause=TABLE_NAME='TURBINE_USER'
[Thu Feb 14 17:50:19 CET 2002] -- ERROR -- Couldn't create account: db
problem
Exception: org.apache.turbine.util.security.DataBackendException:
Failed to create account 'fghfgh': Bad conversion:
java.lang.NumberFormatException:
<AC><ED>^@^Esr^@^Sjava.util.Hashtable^S<BB>^O%!J<E4><B8>^C^@^BF^@
loadFactorI^@ thresholdxp?@^@^@^@^@^@^@^@^@^@^A^@^@^@^@x
Stack Trace follows:
com.workingdogs.village.DataSetException: Bad conversion:
java.lang.NumberFormatException: <AC><ED>^@^Esr^@^Sjava.util.Hashtable^S
<BB>^O%!J<E4><B8>^C^@^BF^@
loadFactorI^@ thresholdxp?@^@^@^@^@^@^@^@^@^@^A^@^@^@^@x
at com.workingdogs.village.Value.asInt(Value.java:424)
at
com.workingdogs.village.Value.setPreparedStatementValue(Value.java:233)
at com.workingdogs.village.Record.saveWithInsert(Record.java:325)
at com.workingdogs.village.Record.save(Record.java:185)
at com.workingdogs.village.Record.save(Record.java:166)
at
org.apache.turbine.om.peer.BasePeer.insertOrUpdateRecord(BasePeer.java:860)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:764)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
rethrown as org.apache.turbine.util.security.DataBackendException: Failed
to create account 'fghfgh': Bad conversion:
java.lang.NumberFormatException:
<AC><ED>^@^Esr^@^Sjava.util.Hashtable^S<BB>^O%!J<E4><B8>^C^@^BF^@
loadFactorI^@ thresholdxp?@^@^@^@^@^@^@^@^@^@^A^@^@^@^@x
at
org.apache.turbine.services.security.db.DBUserManager.createAccount(DBUserManager.java:404)
at
org.apache.turbine.services.security.BaseSecurityService.addUser(BaseSecurityService.java:392)
at
org.apache.turbine.services.security.TurbineSecurity.addUser(TurbineSecurity.java:430)
at
com.wyldebeast_wunderliebe.expertfinder.servlets.actions.AddExpert.doPerform(AddExpert.java:79)
==================================================
After analysing some code i came to the conclusion that the workingdog
checks for collumns beein empty at insert time. It then set's a field to
NULL. In this case it is the USER_ID field.
I checked the mail archives, and someone said it was a problem with
postgresql(and arrays). The same error also comes up with mysql though.
The turbine example project that uses the security also displays the same
troubles. Any tables we populate ourselves do get into the database with
ID's from the IDBroker
If anyone could point me to some documentation on how to solve this
problem, (or just come up with a plain solution :-) ) I would surely
appreciate it.
Gert-Jan Braas
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
