Postgres woes

[Bill <bh...@collaborativefusion.com>]

I need some help in a bad way....

I've been getting the following error when i try to add a user to
Turbine:

[Wed Nov 20 17:08:03 EST 2002] -- ERROR --
        Exception:  java.lang.reflect.InvocationTargetException
        Stack Trace follows:
        java.lang.reflect.InvocationTargetException:
com.workingdogs.village.DataSetException: Bad conversion:
java.lang.NumberFormatException: ¬ísrjava.util.Hashtable»%!Jä¸F
loadFactorI     thresholdxp?@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 'bh@cf.com': Bad conversion:
java.lang.NumberFormatException: ¬ísrjava.util.Hashtable»%!Jä¸F
loadFactorI     thresholdxp?@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.collabfusion.cf.modules.business.MemberMgr.createMemberAccount(MemberMgr.java:360)
        at
com.collabfusion.cf.modules.actions.requestMemberAccount.ARequestAccount.doRegister(ARequestAccount.java:74)
        at java.lang.reflect.Method.invoke(Native Method)

The code that generates this error is running against a postgresql
database.  I have another IDENTICAL copy of this app running on the same
server against an Oracle database and it works fine.

I've gone thru the code looking for an idea of what is causing the
problem but I'm at a loss.  Anyone a little more Turbine savvy have an
idea?

Does anyone know what versions of PG have been tested with the TDK?  I'm
wondering if maybe the adapter I have is too old to work with my version
of PG, or something like that.  I'm currently running TDK 2.1, Village
1.5.3 (1.5.1 fails as well), and PG 7.2.1

thanks 

-bill




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Postgres woes

[Edwin Gustafson <ed...@caymanchem.com>]

Bill wrote:

>I've been getting the following error when i try to add a user to
>Turbine:
>  
>
I use PostgreSQL 7.2 and 7.3β with TDK 2.1.  Your problem doesn't ring 
any particular bells, but I've had trouble in the past with the type 
mappings that Torque uses to generate tables and classes.  These 
mappings are stored in 
WEB-INF/build/bin/torque/templates/sql/base/postgresql/db.props. 
 Specifically:

Six months ago, I switched from text to bytea for the VARBINARY type. 
 This just might be your problem, since this is the type of the 
objectdata column in the TURBINE_USER table into which you are trying to 
insert.  Search the mailing list archives for bytea to get the full 
story on the change.

Just the other day, I rebuilt my database under PostgreSQL 7.3β and 
found that TIMESTAMP columns had changed from using time zones to 
ignoring time zones.  I had to manually specify I wanted timestamp(6) 
with time zone to get my application working again.

Hope this helps.  I like PostgreSQL a lot and find it works great with 
Turbine.

-- 
Edwin Gustafson
Cayman Chemical Company
--
734 971 3586 x 221
http://www.caymanchem.com/promo/ewg
42*13'44" N 83*43'25" W




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>