Hi, I've experienced a similar problem as described below - When trying to add a new user I get:
com.workingdogs.village.DataSetException: Bad conversion:java.lang.NumberFormatException: ...etc. I've tried changing the Torque schema (security-schema.xml on my version) but BYTEA returns an error on build - its not a permitted value in the dtd http://jakarta.apache.org/turbine/dtd/database.dtd is it the Torque schema or the database sql code in src/sql/external/turbine-postgresql.sql that you change to BYTEA? I've seen others with this problem on the list. Any other sugestions? Thanks, Brendan Richards ps. Big thanks to Stephen Jackson for getting me this far! -----Original Message----- Markus, thank you it worked! Let me buy you a beer! -----Original Message----- From: Markus Strau� [mailto:markus.strauss@;klt-ag.de] Sent: Thursday, July 11, 2002 11:18 PM To: Jetspeed Users List Subject: AW: Postgres problem with adding/retrieving users Did you change your turbine-schema.xml file before building? this is the thing which gave me the creeps until i found out... in the table "turbine_user" take a look at the "objectdata" column, look at the type. it must be "BYTEA" otherwise you would keep getting your error. try this - i hope that helps -----Urspr�ngliche Nachricht----- Von: Ed Park [mailto:epark@;hotwire.com] Gesendet: Donnerstag, 11. Juli 2002 18:22 An: '[EMAIL PROTECTED]' Betreff: Postgres problem with adding/retrieving users > Is there any resolution right now to the problems using Jetspeed with > Postgres (7.2.1) ? > I've tried all the latest CVS builds of the Postgres JDBC driver and the > Village API to no avail ... > The how-to at > http://jakarta.apache.org/turbine/turbine-2/howto/postgres-howto.html is > horribly outdated and of no use. > Here are the steps I follow to get a NumberFormatException from the > Village API: > 1. execute the 'turbine-postgres.sql' and 'populate-postgres.sql' scripts > from the Jetspeed source distribution > 2. start Jetspeed after configuring it to use Postgres > 3. log in as 'admin' and password 'jetspeed' > 4. go to the 'Security' tab and 'Edit' the admin user > 5. change the first and last name and click 'Update user' > > The following stack trace appears in jetspeed's log: > > com.workingdogs.village.DataSetException: Bad conversion: > java.lang.NumberFormatException: ?? ?sr ?java.util.Hashtable???%!J??? ?F > > loadFactorI thresholdxp?@ ? x > at com.workingdogs.village.Value.asInt(Value.java:462) > at > com.workingdogs.village.Value.setPreparedStatementValue(Value.java:241) > at com.workingdogs.village.Record.saveWithUpdate(Record.java:262) > at com.workingdogs.village.Record.save(Record.java:187) > at com.workingdogs.village.Record.save(Record.java:166) > at > org.apache.turbine.om.peer.BasePeer.insertOrUpdateRecord(BasePeer.java:8 90 > ) > at > org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1683) > at > org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1577) > at > org.apache.turbine.om.security.peer.TurbineUserPeer.doUpdate(TurbineUser Pe > er.java:469) > > > Help! Brendan Richards
