Opps: missing the first char in the corrupted data string.
( Textpad can't display it. )
111111 ----- >@1111
I also find it's allways the first three characters in a string are corrupted. Updating DATE type data through jboss by using oracle 188.8.131.52 driver is ok.
Curious. The first char still can't be pasted in the post.
It just can't be displayed. it is 0C in hex.
were you able to find a resolution to your issue? We have experienced a similiar problem. This problem appears to be an Oracle bug, not a JBoss issue. We have a quick fix, but I'm not to happy with it.
We have been able to recreate the issue simply by the order of the parameters in a SQL UPDATE statement. For example if the last parameter is of type TIMESTAMP, the column value preceeding the TIMESTAMP will be corrupted. Example:
UPDATE TABLE_NAME SET ID = ?, VARCHAR_COLUMN = ?, TIMESTAMP_VALUE = ?
So in order to resolve the issue, reorder the SQL statement (TIMESTAMP not last parameter). In the case of a CMP entity bean, change the order <cmp-field> nodes in the jbosscmp-jdbc.xml file.
- We have been able to recreate this issue with any driver after Oracle 9.0.1
- the example provided is a brief example, I can post a detailed example if requested.
Does anyone have any more details or a solution to this problem?