[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3605?page=c...
]
Frank Grimes commented on HHH-3605:
-----------------------------------
This is not a hibernate problem.
Your database doesn't have a transaction log enabled, that's why you're
seeing: "java.sql.SQLException: Transactions not supported".
You need to set your Informix database instance up correctly.
See
http://forums.hibernate.org/viewtopic.php?t=941610 for details.
Informix7.2, jdk1.5, Informix Dialect Version 2.21JC5, Hibernate3.3
--------------------------------------------------------------------
Key: HHH-3605
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3605
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.3.0.GA
Reporter: jean jj
Informix7.2, jdk1.5, Informix Dialect Version 2.21JC5, Hibernate3.3
Hi I am using Hibernate 3 with JDK1.5 and Informix 7.2 and driver version 2.21JC5
But it shows the error seems not support informix7.2
The Error is
org.hibernate.exception.GenericJDBCException: Cannot open connection
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
.
.
.
.
org.hibernate.exception.GenericJDBCException: Cannot open connection
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
.
.
.
.
Caused by: java.sql.SQLException: Transactions not supported
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:349)
at com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1627)
at
com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881)
at
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:61)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 116 more
hibernate.cfg.xml
<hibernate-configuration>
<session-factory>
<property
name="dialect">org.hibernate.dialect.InformixDialect</property>
<property
name="connection.driver_class">com.informix.jdbc.IfxDriver</property>
<property
name="connection.url">jdbc:informix-sqli://xxx.xxx.xxx.xxx:8347/dbname:INFORMIXSERVER=dbSERVER</property>
<property name="connection.username">xxx</property>
<property name="connection.password">xxxxx</property>
<property name="show_sql">true</property>
<property name="hibernate.c3p0.min_size">2</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">50</property>
<!--jdbcTest -->
<mapping resource="hibernateDB/informix/JdbcTest.hbm.xml"/>
</session-factory>
</hibernate-configuration>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira