RE: Postgres problem with adding/retrieving users

[br...@draftlondon.com]

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: 'jetspeed-user@jakarta.apache.org'
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