[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3605) Informix7.2, jdk1.5, Informix Dialect Version 2.21JC5, Hibernate3.3

[Frank Grimes (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31718#action_31718 ] 

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira