insert error
------------
Key: DBUTILS-71
URL: https://issues.apache.org/jira/browse/DBUTILS-71
Project: Commons DbUtils
Issue Type: Bug
Affects Versions: 1.3
Environment: windows xp,tomcat,mssql,mysql,sqlite
Reporter: sjy
i have a table maintances(id,tr_userid,trouble,tr_time),id is
autoincrement.when i use code below insert into table
QueryRunner runner = new QueryRunner();
runner.update(conn,"INSERT INTO maintances values(?,?,?)",1,"2","2009-01-01");
successed in mysql,
in mssql has error(near where the wrong syntax);
in sqlite (error is id can't auto increment)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.