P4
A DESCRIPTION OF THE REQUEST :
The JDBC 3.0 specification and API documentation (JavaDoc) for java.sql.CallableStatement class describes the escape syntax for calling a database stored procedure differently
Spec: {call <procedure-name>[(<arg1>,<arg2>, ...)]}.
JavaDoc: {call <procedure-name>[<arg1>,<arg2>, ...]}.
The difference is the parentheses for parameter list.
JUSTIFICATION :
Some JDBC drivers (e.g. JNetDirect JSQLConnect) works fine with both syntax variants, but others (e.g. Microsoft JDBC Driver for MS SQL Server) fails w/o parentheses. That makes application code driver-dependent.
CUSTOMER SUBMITTED WORKAROUND :
Please, fix the API documentation.
The JDBC 3.0 specification and API documentation (JavaDoc) for java.sql.CallableStatement class describes the escape syntax for calling a database stored procedure differently
Spec: {call <procedure-name>[(<arg1>,<arg2>, ...)]}.
JavaDoc: {call <procedure-name>[<arg1>,<arg2>, ...]}.
The difference is the parentheses for parameter list.
JUSTIFICATION :
Some JDBC drivers (e.g. JNetDirect JSQLConnect) works fine with both syntax variants, but others (e.g. Microsoft JDBC Driver for MS SQL Server) fails w/o parentheses. That makes application code driver-dependent.
CUSTOMER SUBMITTED WORKAROUND :
Please, fix the API documentation.