java.sql.SQLException: Connection is closed. at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:124) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:322) at org.springframework.orm.hibernate3.HibernateAccess or.convertJdbcAccessException(HibernateAccessor.ja va:424) at org.springframework.orm.hibernate3.HibernateAccess or.convertHibernateAccessException(HibernateAccess or.java:410) at org.springframework.orm.hibernate3.HibernateTempla te.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTempla te.executeWithNativeSession(HibernateTemplate.java :374) at org.springframework.orm.hibernate3.HibernateTempla te.find(HibernateTemplate.java:917) at com.donateclearly.nps.dcs.config.DcsDataSource.fin d(DcsDataSource.java:49) at com.donateclearly.nps.dcs.manager.DcsUserManager.g etUserInfo(DcsUserManager.java:106) at com.donateclearly.nps.user.logic.UserFactory.login User(UserFactory.java:302) at com.donateclearly.nps.common.controller.MainContro ller.loginByNps(MainController.java:29) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)

spring.io | 4 months ago
  1. 0

    Spring Hibernate with multiple sessionfactories - Spring Forum

    spring.io | 4 months ago
    java.sql.SQLException: Connection is closed. at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:124) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:322) at org.springframework.orm.hibernate3.HibernateAccess or.convertJdbcAccessException(HibernateAccessor.ja va:424) at org.springframework.orm.hibernate3.HibernateAccess or.convertHibernateAccessException(HibernateAccess or.java:410) at org.springframework.orm.hibernate3.HibernateTempla te.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTempla te.executeWithNativeSession(HibernateTemplate.java :374) at org.springframework.orm.hibernate3.HibernateTempla te.find(HibernateTemplate.java:917) at com.donateclearly.nps.dcs.config.DcsDataSource.fin d(DcsDataSource.java:49) at com.donateclearly.nps.dcs.manager.DcsUserManager.g etUserInfo(DcsUserManager.java:106) at com.donateclearly.nps.user.logic.UserFactory.login User(UserFactory.java:302) at com.donateclearly.nps.common.controller.MainContro ller.loginByNps(MainController.java:29) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
  2. 0

    Job Runtime JDBC exception: Missing Defines Exception from Oracle - Spring Forum

    spring.io | 11 months ago
    java.sql.SQLException: Missing defines at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:124) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:322) at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:949) at org.springframework.jdbc.core.JdbcTemplate.call(Jd bcTemplate.java:982) at org.springframework.batch.sample.dao.JdbcMVestTrad eDao.getRate(JdbcMVestTradeDao.java:70) at org.springframework.batch.sample.dao.MVestTradeCom monTransformer.transform(MVestTradeCommonTransform er.java:64) at org.springframework.batch.item.transform.Composite ItemTransformer.transform(CompositeItemTransformer .java:23) at org.springframework.batch.item.transform.ItemTrans formerItemWriter.doProcess(ItemTransformerItemWrit er.java:21) at org.springframework.batch.item.support.DelegatingI temWriter.write(DelegatingItemWriter.java:42) at org.springframework.batch.item.support.DelegatingI temWriter.write(DelegatingItemWriter.java:43) at org.springframework.batch.core.step.item.BatchList enerFactoryHelper$2.write(BatchListenerFactoryHelp er.java:101) at org.springframework.batch.core.step.item.SimpleIte mHandler.doWrite(SimpleItemHandler.java:100) at org.springframework.batch.core.step.item.SimpleIte mHandler.write(SimpleItemHandler.java:92) at org.springframework.batch.core.step.item.SimpleIte mHandler.handle(SimpleItemHandler.java:66) at org.springframework.batch.core.step.item.ItemOrien tedStep$2.doInIteration(ItemOrientedStep.java:495) at org.springframework.batch.repeat.support.RepeatTem plate.getNextResult(RepeatTemplate.java:346) at org.springframework.batch.repeat.support.RepeatTem plate.executeInternal(RepeatTemplate.java:212) at org.springframework.batch.repeat.support.RepeatTem plate.iterate(RepeatTemplate.java:143) at org.springframework.batch.core.step.item.ItemOrien tedStep.processChunk(ItemOrientedStep.java:488) at org.springframework.batch.core.step.item.ItemOrien tedStep$1.doInIteration(ItemOrientedStep.java:288) at org.springframework.batch.repeat.support.RepeatTem plate.getNextResult(RepeatTemplate.java:346) at org.springframework.batch.repeat.support.RepeatTem plate.executeInternal(RepeatTemplate.java:212) at org.springframework.batch.repeat.support.RepeatTem plate.iterate(RepeatTemplate.java:143) at org.springframework.batch.core.step.item.ItemOrien tedStep.execute(ItemOrientedStep.java:269) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
  3. 0

    Mombu the Microsoft Forum - Integrating w 3rd party TransactionManager

    mombu.com | 11 months ago
    java.sql.SQLException: Failed to create the XA control connection. Error: xp_sqljdbc_xa_init failure, status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_init, state=1, StatusCode:0 (0x00000000) ***. at edu.taylor.jta.TransactionAwareXADataSource.enlist ResourceIfTransactionExists(TransactionAwareXAData Source.java:49) at edu.taylor.jta.TransactionAwareXADataSource.getCon nection(TransactionAwareXADataSource.java:28) at org.springframework.jdbc.datasource.DataSourceUtil s.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtil s.getConnection(DataSourceUtils.java:77) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:164) at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:204) at org.springframework.jdbc.support.SQLErrorCodesFact ory.getErrorCodes(SQLErrorCodesFactory.java:185) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.setDataSource(SQLErrorCodeSQLExc eptionTranslator.java:126) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.<init>(SQLErrorCodeSQLExceptionT ranslator.java:92) at org.springframework.orm.hibernate3.SessionFactoryU tils.newJdbcExceptionTranslator(SessionFactoryUtil s.java:133) at org.springframework.orm.hibernate3.HibernateAccess or.getJdbcExceptionTranslator(HibernateAccessor.ja va:235) at org.springframework.orm.hibernate3.HibernateTempla te.getSession(HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTempla te.execute(HibernateTemplate.java:354) at org.springframework.orm.hibernate3.HibernateTempla te.find(HibernateTemplate.java:817) at org.springframework.orm.hibernate3.HibernateTempla te.find(HibernateTemplate.java:809) at edu.taylor.jta.QuerierObjectImpl.getSomeEntities(Q uerierObjectImpl.java:12) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Database Connection Factory for SQL Server Stored Procedures - Mirth Community

    mirthcorp.com | 9 months ago
    java.sql.SQLException: The executeQuery method must return a result set. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL Query(JtdsStatement.java:429) at net.sourceforge.jtds.jdbc.JtdsStatement.executeQue ry(JtdsStatement.java:1258) at com.mirth.connect.server.util.DatabaseConnection.e xecuteCachedQuery(DatabaseConnection.java:80) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
  6. 0

    Transaction across schemas in a database - Spring Forum

    spring.io | 4 months ago
    java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:810) at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1039) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:850) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1134) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3384) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:93 ) at org.hibernate.id.IncrementGenerator.getNext(Increm entGenerator.java:85) at org.hibernate.id.IncrementGenerator.generate(Incre mentGenerator.java:44) at org.hibernate.event.def.AbstractSaveEventListener. saveWithGeneratedId(AbstractSaveEventListener.java :99) at org.hibernate.ejb.event.EJB3PersistEventListener.s aveWithGeneratedId(EJB3PersistEventListener.java:4 9) at org.hibernate.event.def.DefaultPersistEventListene r.entityIsTransient(DefaultPersistEventListener.ja va:131) at org.hibernate.event.def.DefaultPersistEventListene r.onPersist(DefaultPersistEventListener.java:87) at org.hibernate.event.def.DefaultPersistEventListene r.onPersist(DefaultPersistEventListener.java:38) at org.hibernate.impl.SessionImpl.firePersist(Session Impl.java:622) at org.hibernate.impl.SessionImpl.persist(SessionImpl .java:596) at org.hibernate.impl.SessionImpl.persist(SessionImpl .java:600) at org.hibernate.ejb.AbstractEntityManagerImpl.persis t(AbstractEntityManagerImpl.java:220) at org.springframework.orm.jpa.JpaTemplate$5.doInJpa( JpaTemplate.java:268) at org.springframework.orm.jpa.JpaTemplate.execute(Jp aTemplate.java:184) at org.springframework.orm.jpa.JpaTemplate.persist(Jp aTemplate.java:266) at au.gov.nsw.railcorp.onlineticketing.internal.dao.a dmin.SegmentAccountDao1Impl.updateMe(SegmentAccoun tDao1Impl.java:53) at au.gov.nsw.railcorp.onlineticketing.internal.busin ess.admin.AdminConfigServiceImpl.saveAllSegmentAcc ounts(AdminConfigServiceImpl.java:50) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Connection is closed. at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:124) at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:322) at org.springframework.orm.hibernate3.HibernateAccess or.convertJdbcAccessException(HibernateAccessor.ja va:424) at org.springframework.orm.hibernate3.HibernateAccess or.convertHibernateAccessException(HibernateAccess or.java:410) at org.springframework.orm.hibernate3.HibernateTempla te.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTempla te.executeWithNativeSession(HibernateTemplate.java :374) at org.springframework.orm.hibernate3.HibernateTempla te.find(HibernateTemplate.java:917) at com.donateclearly.nps.dcs.config.DcsDataSource.fin d(DcsDataSource.java:49) at com.donateclearly.nps.dcs.manager.DcsUserManager.g etUserInfo(DcsUserManager.java:106) at com.donateclearly.nps.user.logic.UserFactory.login User(UserFactory.java:302) at com.donateclearly.nps.common.controller.MainContro ller.loginByNps(MainController.java:29) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)

      at java.lang.reflect.Method.invoke()
    2. Java RT
      Method.invoke
      1. java.lang.reflect.Method.invoke(Unknown Source)
      1 frame