You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Julien Aymé (JIRA)" <ji...@apache.org> on 2010/07/21 08:29:51 UTC
[jira] Commented: (DBUTILS-71) insert error
[ https://issues.apache.org/jira/browse/DBUTILS-71?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12890567#action_12890567 ]
Julien Aymé commented on DBUTILS-71:
------------------------------------
Hi,
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.
Regards,
Julien
> 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 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.