Gert-Jan Braas wrote:
> 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)
>
> ==================================================
>
Gert,
I would recommend that you update your postgresql.jar to the latest version (I
can mail you it off-list if you like) and perform some updates to the db.props
under tdk\share\conf\torque\templates\sql\base\postgresql. Then rebuild your app.
Heres what my db.props looks like:
------------------------------------------------------------
BIT =
TINYINT =
SMALLINT =
INTEGER = integer
BIGINT = int8
FLOAT =
REAL =
DOUBLE =
NUMERIC =
DECIMAL =
CHAR = varchar
VARCHAR = varchar
LONGVARCHAR = bytea
DATE =
TIME =
TIMESTAMP = timestamp
BINARY = bytea
VARBINARY = bytea
LONGVARBINARY = bytea
NULL =
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
BLOB =
CLOB = text
REF =
------------------------------------------------------------
These problems are often associated with the lack of support for bytea types in
older versions of postgres - this is why you need both new type-mappings and the
new driver classes.
HTH
................................................................
colm mccartan
panasonic owl uk
[EMAIL PROTECTED]
(44) 131 561 1035
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
