commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julien Aymé (JIRA) <>
Subject [jira] Commented: (DBUTILS-71) insert error
Date Wed, 21 Jul 2010 06:29:51 GMT


Julien Aymé commented on DBUTILS-71:


I don't think this is a DBUTILS issue, rather a SQL issue.
In order to make your code more independant from the database you use, you should specify
the columns to insert into:

"INSERT INTO maintances(tr_userid, trouble, tr_time) values(?,?,?)"

Note that you should ask your questions on the user list before creating an issue, if you
are not sure this is an issue.


> insert error
> ------------
>                 Key: DBUTILS-71
>                 URL:
>             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 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