wu xiao wrote:
> PreparedStatement ps = db.prepareStatement("select * from operator where
> The sqlexception is：....column 'id' is not exist..... What's the reason
> please? All of the tables are created in Windows XP.
If you've created the table with a capitalized column name, you will
need to quote it in your SQL:
"select * from operator where \"ID\"=?"
Unquoted identifiers (column names, table names, etc) are forced to
lowercase by the server.
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2005-07-20 23:57:29|
|Subject: Re: Timestamp Conversion Woes Redux|
|Previous:||From: Tom Lane||Date: 2005-07-20 23:47:12|
|Subject: Re: Timestamp Conversion Woes Redux |