1 Reply Latest reply: Oct 10, 2008 3:29 PM by 664637 RSS

    oracle.jdbc.driver.DatabaseError.throwSqlException

    609889
      Hi All,

      I am facing this problem Please tell me how i can solve this. I will be really glad if i got answer from you.

      ------------------------------------------------------------------
      <log code="0" component="DB Upload" context="SCR-003"

      datetime="Mon, 21 Jan 2008 12:33:48" type="Fatal Error">

      <message>Unable to upload file to database;

      oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)

      oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)

      oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)

      oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)

      oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)

      oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:791)

      oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)

      oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2901)

      oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2973)

      com.dupont.agtrax.upload.trialdata.TrialDocsUploadDAO.create(TrialDocsUploadDAO.java:206)

      com.dupont.agtrax.upload.pluggable.ExecuteTrialUpload.execute(ExecuteTrialUpload.java:83)

      com.dupont.agtrax.fsm.StateControler.runTrialData(StateControler.java:218)

      com.dupont.agtrax.fsm.StateControler.run(StateControler.java:100) </message>

      </log>

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

      Thank you,

      regards,
      Bala
        • 1. Re: oracle.jdbc.driver.DatabaseError.throwSqlException
          664637
          I am also facing same error while my trigger is calling an Oracle Store Procedure

          Illegal Access Exception: (Open Connection).
          java.sql.SQLException: ORA-29541: class INPUT_TABLE.InputSourceInsertTrigger coul
          d not be resolved
          ORA-04088: error during execution of trigger 'INPUT_TABLE.INPUT_SOURCE_INSERT'

          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:213)
          at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
          tement.java:952)
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
          nt.java:1160)
          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
          aredStatement.java:3285)
          at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
          edStatement.java:3368)
          at XmlInsert.main(XmlInsert.java:51)

          Please help ..

          Thanks
          Amiya