Kbase P52974: java.sql.SQLException: [JDBC Progress Driver]:-20217 when up
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Windows 32 Intel
SYMPTOM(s):
Updating LVARBINARY field fails with java.sql.SQLException
_sqlsrv2 crashes with memory violation (49)
[JDBC Progress Driver]:-20217
[JDBC Progress Driver]:Server not reachable or possible RPC error
at com.progress.sql.jdbc.JdbcProgressPreparedStatement.executeUpdate(Jdb
cProgressPreparedStatement.java:144)
CAUSE:
unsupported Update statement was used in code:
"PreparedStatement upStmt = curConn.prepareStatement( "update
blobtest set FILEDATA = ? where FILENAME = 'Empty'");
byte[] bs2 = newtext.getBytes();
InputStream bis2 = new ByteArrayInputStream(bs2);
upStmt.setBinaryStream(1, bis2, bs2.length);
int res3 = upStmt.executeUpdate();"
FIX:
Progress SQL-92 Guide and Reference says in chapter 2:
"There is no support for an UPDATE of a LVARBINARY column on a
table which contains a column of data type LVARBINARY.
Obtain the functionality of an UPDATE on an LVARBINARY
column by using the DELETE and INSERT statements for the record."