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)

spring.io | 4 months ago
  1. 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)
  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

    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)

    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

      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)

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