I'm evaluating JDBC 3.0 trial version of the HXTT Access driver. When I execute following querys on an empty table "BasisTyp" it works as expected:
insert into BasisTyp (idBasisTyp, name) values (5, 'ABCD');
delete from BasisTyp where name like '%ABCD';
select name from BasisTyp;
-> No Result.
But when I use a prepared statement for deleting the inserted row, the row still exists.
PreparedStatement prepStmt = con.prepareStatement("delete from BasisTyp where name like ?");
prepStmt.setString(1, "%ABCD");
prepStmt.executeUpdate();
Prepared statements are working if the % is not at the beginning of the string. Is there a hint? Or is this fixed in a full version?
Thanks for help.
|
Checked. It happened only when name is an indexed column, and like pattern begin with % .
Fixed. Please download the latest package.
|