I am getting the following error when I try to save an object using a key
sequence.
This works fine for oracle, sqlserver, hsqldb and db2.
Here is my database.xml. Is there something I can do it to force castor to
use a different connection to get the keys or change connection from
read-only to non read-only?
org.exolab.castor.jdo.keygen.MaxKeyGenerator:
org.postgresql.util.PSQLException: ERROR: transaction is read-only.: ERROR:
transaction is read-only
<!DOCTYPE mapping PUBLIC "-//EXOLAB/Castor Mapping DTD Version 1.0//EN"
"http://castor.exolab.org/mapping.dtd";>
<mapping>
<key-generator name="HIGH-LOW" alias="keygen">
<param name="table" value="seq"/>
<param name="key-column" value="seq_table_name"/>
<param name="value-column" value="max_pk_value"/>
<param name="grab-size" value="50"/>
<param name="same-connection" value="true"/>
</key-generator>
</mapping>
Steve
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
