[jira] Updated: (DBUTILS-71) insert error

["sjy (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DBUTILS-71?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

sjy updated DBUTILS-71:
-----------------------

    Description: 
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(tr_userid,trouble,tr_time) values(?,?,?)",1,"2","2009-01-01");
successed in mysql,sqlite
in mssql has error(near where the wrong syntax);


  was:
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)



> 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
>   Original Estimate: 168h
>  Remaining Estimate: 168h
>
> 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(tr_userid,trouble,tr_time) values(?,?,?)",1,"2","2009-01-01");
> successed in mysql,sqlite
> in mssql has error(near where the wrong syntax);

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.