Forum Discussion

kbw's avatar
kbw
Contributor
15 years ago

JDBC Request errors when semicolon is included in SQL

When you end your sql statement with a semicolon in JDBC Requests, soapUI fails to run the request and reports the following error:

"Error getting response; java.sql.SQLSyntaxErrorException: ORA-00911: invalid character"

Removing the semicolon will allow the JDBC request to run successfully, however soapUI shouldn't cause an error when you properly end your statement with a semicolon.

Example:
select * from tbl_address where id=999;

soapUI Version: 3.6 beta 2