[
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(Keyword 'where' syntax error near);
tracks
Caused
by:java.sql.SQLException:com.microsoft.sqlserver.jdbc.SQLServerException:关键字'where'附近有语法错误。Query:,"INSERT
INTO maintances(tr_userid,trouble,tr_time) values(?,?,?)
Parameters:[1,2,2009-01-01]
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:599)
at
com.softwarementors.extjs.djn.demo.Maintance.insertMaintance(Maintance.java:49)
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(tr_userid,trouble,tr_time)
values(?,?,?)",1,"2","2009-01-01");
successed in mysql,sqlite
in mssql has error(Keyword 'where' syntax error near);
> 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(Keyword 'where' syntax error near);
> tracks
> Caused
> by:java.sql.SQLException:com.microsoft.sqlserver.jdbc.SQLServerException:关键字'where'附近有语法错误。Query:,"INSERT
> INTO maintances(tr_userid,trouble,tr_time) values(?,?,?)
> Parameters:[1,2,2009-01-01]
> at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
> at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:599)
> at
> com.softwarementors.extjs.djn.demo.Maintance.insertMaintance(Maintance.java:49)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
