ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torx <aito...@hotmail.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 17:58:08 GMT

Hi Larry,

:)

It works, I am my grateful for your help.

I have use this config in other project and it works fine. I donĀ“t
undertand!!!
The diference between two projects is the Database. With Oracle this config
works fine.

Ok, thanks for your help :):):)


Thanks,
Torx



Christopher Lamey wrote:
> 
> 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
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Ibatis-2.3.0-%2B-postgresql-8.2%2C-returns-org.postgresql.util.PSQLException%3A-ERROR%3A-transaction-is-read-only.-tp18920683p18930527.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message