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
"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
