Kbase P124629: Preparing a statement by setting the parameters of a WHERE condition causes Unsupported data convers
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/06/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
SYMPTOM(s):
Preparing a statement by setting the parameters of a WHERE condition
Getting error Unsupported data conversion
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Unsupported data conversion.
Using preparedStatement
CAUSE:
Setting an integer parameter using setTime
FIX:
On the java side compute and integer value from Time object representing the number of seconds since midnight and use setInt to set the value on the integer parameter