Re: "Invalid column name" inserting a row with weblogic/oracle

From: bsaastad (member45644_at_dbforums.com)
Date: 10/28/03

  • Next message: rpcxdr: "Re: Type_forward_only" 
    Date: Tue, 28 Oct 2003 14:56:53 -0500

    Joe,

    It looks like this is a problem with either the oracle driver or
    possibly the oracle/jdbc/jvm installation. When I do as you suggested
    (explicitly load the oracle driver and get my connection from there)
    taking Weblogic completely out of the picture I still get the "invalid
    column name" error with a much more concise exception:

    [INSERT INTO POOL_R (POOL_ID,POOL_NM,POOL_DESC,REV_BY,REV_DT) VALUES
    (100, 'FRED', 'TEST POOL NAME FOR FRED', 'test-user', {ts '2003-10-28
    11:02:00.328'})]

    java.sql.SQLException: ORA-00904: invalid column name

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError-
            .java:134)

            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

            at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)

            at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)

            at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol-
            .java:1094)

            at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleSta-
            tement.java:2132)

            at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStat-
            ement.java:2015)

            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac-
            leStatement.java:2877)

            at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleState-
            ment.java:858)

            at com.billing.tm.persist.BatchTest.doInsert(BatchTest.java:97)

            at com.billing.tm.persist.BatchTest.main(BatchTest.java:189)

    I've also posted this to Oracle's MetaLink forum.

    -Brian 

    --
Posted via http://dbforums.com
  • Next message: rpcxdr: "Re: Type_forward_only"