Eerrrr.... I am answering my own question....
in the properties file, i set this on url" url=jdbc:informix-sqli://dataBaseServer:ifxPortNumber/dataBase:INFORMIXSERVER=serverInstance;IFX_LOCK_MODE_WAIT=1 --- Angel Gomez <[EMAIL PROTECTED]> wrote: > Hi all. > > I am using an Informix DB and, in some cases, I get > an > error from iBatis ( 2.1.5 ) > > --- Check the statement (update failed). > --- Cause: java.sql.SQLException: Could not do a > physical-order read to fetch next row. > Caused by: java.sql.SQLException: Could not do a > physical-order read to fetch next row. > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:500) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:85) > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.update(SqlMapClientImpl.java:62) > > > I am quite sure this is due to concurrent readings > to > the BD table, but i don't know how to set or isue a > "SET LOCK MODE TO WAIT; SET ISOLATION TO COMMITED > READ" ( or dirty read ) for the connections on the > DBCP. > > I already have set the tables to LOCK MODE ROW. > > Regards. > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > /* Las generaciones por venir dudaran que un hombre como El ( Mohandas K. Gandhi ) camino alguna vez sobre la faz de la tierra en carne y hueso. - Albert Einstein */ ~ _/ _/ _/_/_/_/ _/_/_/_/ _/ 'v' _/_/ _/ _/ _/_/ _/ Angel Gomez // \\ _/ _/_/ _/ _/_/ _/ _/ [EMAIL PROTECTED] /( )\ _/ _/ _/_/_/_/ _/_/_/_/ _/_/_/_/ ^`~'^ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
