The parser error is from the backend not JDBC (as it doesnt parse anything
other than PreparedStatement's).
I think it's the sub-select that's causing the problem, as it's not
supported in 6.5.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@it.maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council
-----Original Message-----
From: BogdanKRomski [mailto:b.kromski@gaschka.pl]
Sent: Tuesday, August 22, 2000 12:47 PM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] JDBC problem
Hello
I'm using the Postgresql 6.5 and i try to perform statement
INSERT into KEY_ITEM (key_item_id,keyName) values(((SELECT
MAX(key_item_id) FROM KEY_ITEM)+1),?)
and I get the message :
Error: ERROR: parser: parse error at or near "select"
I'm not sure but part "(SELECT MAX(key_item_id) FROM KEY_ITEM)+1)" of
statement does't work
thanks for all informations
Bogdan Kromski
ps. on Oracle and Sybase it is working correct