Thread: Error while Insertion

Hi All,

I am facing an issue while trying to insert data in a table with 65
columns.
I use a prepared statement for this insert.
Postgres driver 7.3.4

Stack Trace:

 java.sql.SQLException: ERROR:  Attribute "null100" not found

        at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connec
tion.java:505)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Stateme
nt.java:320)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:48)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1S
tatement.java:197)
        at
com.cisco.ccm.car.beans.EBCallDetailRecord.save(EBCallDetailRecord.java:
674)
        at
com.cisco.ccm.car.controller.CtrLoaderUtil.insertBillingRecord(CtrLoader
Util.java:1221)
        at
com.cisco.ccm.car.controller.CtrLoadDumpRecords.processDumpRecords(CtrLo
adDumpRecords.java:683)
        at
com.cisco.ccm.car.controller.CtrLoadDumpRecords.processDump(CtrLoadDumpR
ecords.java:1900)
        at
com.cisco.ccm.car.controller.CtrLoader.run(CtrLoader.java:1121)
        at com.cisco.ccm.car.general.Test.main(Test.java:87)

Please let me know if there are solutions other than upgrading Postgres.


Regards,
Sumita

Richard,

There is no column called "null100", that the query is refering to.
And what do you mean by run the query directly from Java?
We are executing the query through JAVA(SQL Prepared Statement).

Regards,
Sumita

-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.archonet.com]
Sent: Thursday, July 15, 2004 12:13 PM
To: Sumita Biswas
Cc: pgsql-general@postgresql.org
Subject: Re: Error while Insertion


Sumita Biswas wrote:
> Hi All,

Sumita - please don't CC everyone on your first posting. It won't
necessarily help you to get a quicker response.

> I am facing an issue while trying to insert data in a table with 65
> columns. I use a prepared statement for this insert.
> Postgres driver 7.3.4
>
> Stack Trace:
>
>  java.sql.SQLException: ERROR:  Attribute "null100" not found

1. Turn statement logging on in your PostgreSQL logs.
2. Examine the query that causes this problem.
3. If it refers to a column called "null100" check that such a column is

available.
4. It it doesn't refer to such a column, try executing the query
directly via java and see if the error occurs.
5. Report back to the list.

HTH
--
   Richard Huxton
   Archonet Ltd