This discussion is archived
1 Reply Latest reply: Oct 10, 2008 1:29 PM by 664637 RSS

oracle.jdbc.driver.DatabaseError.throwSqlException

609889 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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