Kbase P161611: _sqlsrv2 process dies when executing PreparedStatement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/04/2010 |
|
Status: Unverified
SYMPTOM(s):
_sqlsrv2 process dies when executing PreparedStatement
_sqlsrv2 process dies when executing PreparedStatement without parameters
FACT(s) (Environment):
Using JDBC PreparedStatement execute() method
OpenEdge 10.1C04 Service Pack
Windows
CAUSE:
bug# OE00196053
FIX:
Upgrade to OpenEdge 10.2A03 or higher.
For the case you cannot upgrade as a workaround in your JDBC application make sure to only execute the PreparedStatement when the parameters are set. Set a boolean variable to false which you set to true as soon as all parameters are set. Run PreparedStatement.execute method only if the specific boolean variable is set to true. After having executed the PreparedStatement set boolean variable back to false.
Code example:
areparamset = false;
try {
preparedStatement.setXXX(...);
areparamset = true;
} catch () {}
if (areparamset)
{
try {
preparedStatement.execute();
}
}
areparamset = false;