Postgres Pro
Downloads
Home   >   mailing lists

ERROR transaction is read-only - Mailing list pgsql-jdbc

From ahnf
Subject ERROR transaction is read-only
Date
Msg-id 263816.27775.qm@web36601.mail.mud.yahoo.com
Whole thread Raw
List pgsql-jdbc
Tree view 
I am using the postgresql-8.2.506.jdbc4.jar file

My jdbc connections are setReadOnly(false)

When attempting an insert I get

org.postgresql.util.PSQLException: ERROR: transaction is read-only

ideas?


org.postgresql.util.PSQLException: ERROR: transaction is read-only
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:344)

pgsql-jdbc by date:

Previous
From: LiuYan 刘研
Date:
Subject: Re: Chinese database name in URL, can I ?
Next
From: interz12@yahoo.com
Date:
Subject: Re: ERROR transaction is read-only