java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • JPA Transactions on Informix
    via Stack Overflow by Alejandro Hdez. Angeles
    ,
  • Hi I am using Hibernate 3 with JDK1.5 and Informix 9.4 and driver version 2.21JC5 But it shows the error seems not support informix9.4 The Error is org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:301) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:137) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49) at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24) at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:271) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1079) at com.pa.cricket.daoimpl.PlayerDAOImpl.findAllPlayers(PlayerDAOImpl.java:46) at com.pa.cricket.bl.Test.main(Test.java:31) Caused by: java.sql.SQLException: Transactions not supported at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355) at com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1714) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298) ... 8 more
    via by Mohammed Hanifa,
  • Hi I am using Hibernate 3 with JDK1.5 and Informix 9.4 and driver version 2.21JC5 But it shows the error seems not support informix9.4 The Error is org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:301) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:137) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49) at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24) at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:271) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1079) at com.pa.cricket.daoimpl.PlayerDAOImpl.findAllPlayers(PlayerDAOImpl.java:46) at com.pa.cricket.bl.Test.main(Test.java:31) Caused by: java.sql.SQLException: Transactions not supported at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355) at com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1714) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298) ... 8 more
    via by Mohammed Hanifa,
    • 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.sun.enterprise.resource.JdbcUrlAllocator.createResource(JdbcUrlAllocator.java:93) at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASNonSharedResourcePool.java:856) at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResourcePool.java:416) at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNonSharedResourcePool.java:625) at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedResourcePool.java:520) at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:263) at com.sun.enterprise.resource.JdbcXAConnection.<init>(JdbcXAConnection.java:74) at com.sun.enterprise.resource.Jdbc10XaAllocator.createResource(Jdbc10XaAllocator.java:94) at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASNonSharedResourcePool.java:856) at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResourcePool.java:416) at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNonSharedResourcePool.java:625) at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedResourcePool.java:520) at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:263) at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:170) at com.sun.enterprise.resource.JdbcDataSource.internalGetConnection(JdbcDataSource.java:241) at com.sun.enterprise.resource.JdbcDataSource.getConnection(JdbcDataSource.java:98) at deigma.sep.comun.sql.BaseQueryCmd.<init>(BaseQueryCmd.java:53) at deigma.sep.datamanagement.seguridad.sql.MenuCmd.<init>(MenuCmd.java:29) at deigma.sep.datamanagement.seguridad.session.SeguridadSessionBean.ejbCreate(SeguridadSessionBean.java:335) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.sun.ejb.containers.StatelessSessionContainer.createStatelessEJB(StatelessSessionContainer.java:510) at com.sun.ejb.containers.StatelessSessionContainer.access$000(StatelessSessionContainer.java:68) at com.sun.ejb.containers.StatelessSessionContainer$SessionContextFactory.create(StatelessSessionContainer.java:735) at com.sun.ejb.containers.util.pool.NonBlockingPool.preload(NonBlockingPool.java:252) at com.sun.ejb.containers.util.pool.NonBlockingPool.prepopulate(NonBlockingPool.java:289) at com.sun.ejb.containers.StatelessSessionContainer.onReady(StatelessSessionContainer.java:254) at com.iplanet.ias.server.ApplicationLifecycle.onReady(ApplicationLifecycle.java:204) at com.iplanet.ias.server.ApplicationServer.onReady(ApplicationServer.java:343) at com.iplanet.ias.server.J2EERunner.onReady(J2EERunner.java:187)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    5 more bugmates