1 Reply Latest reply: Nov 1, 2012 10:13 AM by Mkirtley-Oracle RSS

    Problem after Migrating the data from 10g to 11g

    971874
      Our JAVA application say (version xxx.20.3.1) runs well with the *10 g database* but is throwing exceptions when tried connecting our (xxx.20.3.1) application to migrated database on 11g.

      Below is the portion of the exceptions we are facing

      java.sql.SQLException: ORA-00918: column ambiguously defined

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
      at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
      at com.ocimum.db.datahandler.SelectQuery.executeQuery(SelectQuery.java:559)
      at com.ocimum.tracker.location.sql.LocationSQL.selectSuppliesQuery(LocationSQL.java:2337)
      at com.ocimum.tracker.location.sql.LocationSQL.selectAllInformation(LocationSQL.java:1502)
      at com.ocimum.tracker.location.sql.LocationSQL.selectAllFromLocation(LocationSQL.java:1496)
      at com.ocimum.tracker.location.model.LocationModel.selectAll(LocationModel.java:962)
      at com.ocimum.tracker.location.view.ViewLocationList.showAll(ViewLocationList.java:309)
      at com.ocimum.tracker.location.view.ViewLocationList.updateView(ViewLocationList.java:287)
      at com.ocimum.pgm.location.view.PGMViewLocationList.updateListView(PGMViewLocationList.java:755)
      at com.ocimum.pgm.location.view.PGMViewLocationList$2.executeTransaction(PGMViewLocationList.java:746)
      at com.ocimum.pgm.util.PGMProgressBar$2.run(PGMProgressBar.java:189)


      -----------------------

      Any help in demystifying the root-cause will be thoroughly appreciated !!.

      Thank you.
      Sri