[DBUTILS-71] insert error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3

Environment

windows xp,tomcat,mssql,mysql,sqlite

• Assignee: Unassigned
• Reporter: sjy
• Created: 21/Jul/10 06:07
• Updated: 02/Aug/10 01:28
• Resolved: 02/Aug/10 01:26

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);i test in mssql2000,mssql2005,use new and old jdbc, the same result.
stacktrace
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)