Informix and CMP Exception

[Tommi Penttilä]

We get this exception from Orion CMP:

" com.evermind.server.rmi.OrionRemoteException: javax.ejb.EJBException: Error
" saving state: Could not position within a 
" table (informix.listing).

Sounds like a locking problem caused by multiple concurrent updates. I thought
cmp would automagically handle concurrent cmp-bean updates, but apparently I'm
missing something.

Could this perhaps be a mismatch between OrionCMP and Informix JDBC?

Has anyone succesfully applied Orion CMP beans to Informix DB? Is there a way to
set explicit lock mode for CMP's data-source?

Here's our data-source definition for Informix driver:
        <data-source
                class="com.evermind.sql.DriverManagerDataSource"
                name="foobar"
                location="jdbc/foobar-a"
                ejb-location="jdbc/foobar"
                xa-location="jdbc/foobar-xa"
                connection-driver="com.informix.jdbc.IfxDriver"
url="jdbc:informix-sqli://foobar:8888/foo:informixserver=foobar"
                inactivity-timeout="30"
                min-connections="2"
                max-connections="10"/>


Any help would be greatly appreciated.

Tommi Penttilä