ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Lamey <cla...@localmatters.com>
Subject Re: Ibatis 2.3.0 + postgresql 8.2, returns org.postgresql.util.PSQLException: ERROR: transaction is read-only.
Date Mon, 11 Aug 2008 16:45:16 GMT
On 8/11/08 10:26 AM, "Torx" <aitordg@hotmail.com> wrote:

> <bean id="defaultTxAttributes"
> class="org.springframework.transaction.interceptor
> .NameMatchTransactionAttributeSource">
> <property name="properties">
> <props>
> <prop key="update*">
> PROPAGATION_REQUIRED,
> ISOLATION_DEFAULT,-FatalException,-ServiceException,readOnly
> </prop>
> <prop key="set*">
> PROPAGATION_REQUIRED,
> ISOLATION_DEFAULT,-FatalException,-ServiceException,readOnly
> </prop>
> <prop key="insert*">
> PROPAGATION_REQUIRED,
> ISOLATION_DEFAULT,-FatalException,-ServiceException,readOnly
> </prop>
> <prop key="delete*">
> PROPAGATION_REQUIRED,
> ISOLATION_DEFAULT,-FatalException,-ServiceException,readOnly
> </prop>
> <prop key="select*">
> PROPAGATION_SUPPORTS, ISOLATION_DEFAULT, readOnly
> </prop>
> <prop key="get*">
> PROPAGATION_SUPPORTS, ISOLATION_DEFAULT, readOnly
> </prop>
> </props>
> </property>
> </bean>

Just a guess, but the "readOnly" value here might be making your
transactions read only.

Cheers,
Chris


Mime
View raw message