I don't think this has anything to do with the java part; you'll
probably see the same with psql alone.
I guess you really want to do something like
insert into test1 (name, age) values ('Granma', 100);
if name and age are the names of the columns you want to set. Note the quotes
for the string.
On Sat, Apr 28, 2001 at 12:58:54PM +0100, suhail sarwar wrote:
> I am getting this sql exception "Attribute 'name' not found" and I can't seem to figure it out at all. I have a java program that creates a table in postgresql using a prepared statement and that bit works. Then I have added another prepared statement to populate the table with values (see below):
> PreparedStatement stt = db.prepareStatement("INSERT INTO Test1 " + "VALUES (100, name, age)");
In response to
pgsql-novice by date
|Next:||From: suhail sarwar||Date: 2001-04-29 15:00:04|
|Subject: Multiple SQL statements in a java program for postgresql DB|
|Previous:||From: Steve Waldman||Date: 2001-04-28 20:10:31|
|Subject: Re: Attribute 'name' not found ERROR for postgres and java|