Kbase P27948: Second (or later) execution of the preparedStatement object may cause a Java exception
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
SYMPTOM(s):
Progress 9.1x
Using a preparedStatement object in Java
Invoking setString method to bind a string to a parameter in the prepared SQL statement
Second (or later) execution of the preparedStatement object may cause a Java exception
[JDBC Progress Driver]:Data type for parameter 1 has changed since first SQLExecute call. (HY000/0)
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Add ";wa=536870912" to the end of your connection string as shown below:
jdbc:JdbcProgress:T:some_host:some_service:some_database;wa=536870912