Re: Error while Insertion

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(at)archonet(dot)archonet(dot)com]
Sent: Thursday, July 15, 2004 12:13 PM
To: Sumita Biswas
Cc: pgsql-general(at)postgresql(dot)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