Posted Wednesday, December 31, 1969 @ 23:59:59
I have problem updating the column when the column is in the where clause, e.g.the update sql string is
update TESTME set COL1=?,ACHAR=?,AINT=?,AFLOAT=?,ADATE=? where COL1=?
the debug prints out as below:
Data updated: oldvalue: bbb new value: bbbrr
Executing sql update TESTME set COL1=?,ACHAR=?,AINT=?,AFLOAT=?,ADATE=? where COL1=? with arguments:
Argument 1: Datatype in database:12. Datatype of cell data: java.lang.String. Value:bbbrr
Argument 2: Datatype in database:1. Datatype of cell data: java.lang.String. Value:ggg
Argument 3: Datatype in database:4. Datatype of cell data: java.lang.Integer. Value:123
Argument 4: Datatype in database:6. Datatype of cell data: java.lang.Double. Value:23.34000015258789
Argument 5: Datatype in database:12. Datatype of cell data: java.sql.Timestamp. Value:2002-01-01 00:00:00.0
Argument 6: Datatype in database:12. Datatype of cell data: java.lang.String. Value:bbbrr
as you can see, the Argument 6 should contains the Old value bbb but it wrongly use the new value bbbrr, hence the update will never work - or work wrongly - i.e. update something it should not!!!
Sounds like a bug to me - Is there a work round to this?
Many thanks