Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.3

Full stack trace of any exception that occurs: below

Name and version of the database you are using: Informix 7.23


I'm trying to retrieve data from the mentioned legacy database and I get the below exception. I've tried setting autocommit to true as suggested on some forums but that didn't seem to work.


java.sql.SQLExcpetion: Transactions not supported
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1812)
com.mchange.v2.s3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:756)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.begin(JDBCTransaction.java:63)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.inoke(Unknown Source)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext:301)
at $Proxy0.beginTransaction(Unknown Source)
at segue.db.framework.dao.hibernate.HibernateDaoSupport.getObjectById(HibernateDaoSupport.java:465

....

two questions: Can anyone experienced with this database and hibernate provide some suggestions? Does hibernate support nontransactional reads?

mjd