Re: simple insert operation

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <aydin(dot)toprak(at)intengo(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: simple insert operation
Date: 2005-09-08 22:11:52
Message-ID: s32070ea.096@gwmta.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi Ayd*n,

Others have addressed your compile errors, but I see something which might cause you problems at run time.

Identifiers which are not "quoted" will be treated as lower case in PostgreSQL, so your query will try to access "passtable"."idcol" instead of "passTable"."idCol". If you created the table without using quotes it will be in lower case and you will be OK referencing it without quotes no matter what capitalization you use; however, if the table really exists in your database with the camel case identifiers, you must use quotes.

-Kevin


>>> Ayd*n Toprak <aydin(dot)toprak(at)intengo(dot)com> 09/08/05 2:58 AM >>>

String sqlQuery = "INSERT INTO passTable (idCol , pass) VALUES
(3, 5)";

Browse pgsql-jdbc by date

  From Date Subject
Next Message Aydın Toprak 2005-09-09 06:03:59 Re: simple insert operation
Previous Message Dave Cramer 2005-09-08 18:15:21 Re: SELECT COUNT(*) does a scan?