commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sjy (JIRA)" <>
Subject [jira] Created: (DBUTILS-71) insert error
Date Wed, 21 Jul 2010 06:08:50 GMT
insert error

                 Key: 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.

View raw message