We are getting an
unexpected issue that seems to be a change between 1.7.1 and 1.7.2 - we had code
working quite well and shipping for 1.7.1 that is now broken
Prepared
statement:
insert into
tablefoo ( id, name, value ) values ( ?, ?, ?); call identity();
This statement used
to work but does not anymore (blows up with current 1.7.2 rc6b (and
previous)
sample schema
definition:
create table
tablefoo (
id integer IDENTITY,
name varchar not null,
value varchar null
)
Error message
generated:
java.sql.sqlexception: Unexpected token: CALL in
statement [insert into tablefoo ( id, name, value
) values ( ?, ?, ?); call identity();]
Andrew Chandler
Manager DataCollection Group Phone : 650-470-8920x1535
Visionael Corporation Fax : 650-470-8921
410 Cambridge Ave Email : [EMAIL PROTECTED]
Palo Alto, CA. 94306 WEB : www.visionael.com
