I have problem with inserting objects by save() in postgresql.
Running the following configuration:
- turbine 2.2b1 from cvs jakarta-turbine-2
- postgresql
- 'native' idMethod in my schema (though I've tried all possible values
already)
i get following exceptions (here the save() is being called periodically
in a scheduled job)
[..]
Exception: java.sql.SQLException: ERROR: Cannot insert a duplicate
key into unique index acase_pkey
Stack Trace follows:
java.sql.SQLException: ERROR: Cannot insert a duplicate key into
unique index acase_pkey
at
org.postgresql.Connection.ExecSQL(org/postgresql/Connection.java:403)
at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:126)
at com.workingdogs.village.Record.saveWithInsert(Record.java:328)
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:890)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:794)
at pl.alma.intra.om.BaseAcasePeer.doInsert(BaseAcasePeer.java:144)
at pl.alma.intra.om.BaseAcasePeer.doInsert(BaseAcasePeer.java:396)
at pl.alma.intra.om.BaseAcase.save(BaseAcase.java:1518)
at pl.alma.intra.om.BaseAcase.save(BaseAcase.java:1488)
at pl.alma.intra.om.BaseAcase.save(BaseAcase.java:1474)
[..]
and then, after having two same exceptions caught, sequence of other
occurs:
[..]
Exception: java.sql.SQLException: ERROR: Relation 'null' does not
exist
Stack Trace follows:
java.sql.SQLException: ERROR: Relation 'null' does not exist
at
org.postgresql.Connection.ExecSQL(org/postgresql/Connection.java:403)
at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:112)
at
org.apache.turbine.util.db.AutoIncrementIdGenerator.getIdAsVillageValue(AutoIncrementIdGenerator.java:199)
at
org.apache.turbine.util.db.AutoIncrementIdGenerator.getIdAsBigDecimal(AutoIncrementIdGenerator.java:131)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:807)
at pl.alma.intra.om.BaseAcasePeer.doInsert(BaseAcasePeer.java:144)
at pl.alma.intra.om.BaseAcasePeer.doInsert(BaseAcasePeer.java:396)
at pl.alma.intra.om.BaseAcase.save(BaseAcase.java:1518)
at pl.alma.intra.om.BaseAcase.save(BaseAcase.java:1488)
at pl.alma.intra.om.BaseAcase.save(BaseAcase.java:1474)
[..]
I think the problem is in id generation (and thus in misconfiguration),
but I can't track where exactly.
Perhaps someone has a running app with postgresql (Jerome V.?) and has
met similar problem or can describe their working conf....
Bartek
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
