Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.3
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      windows xp,tomcat,mssql,mysql,sqlite

      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)

      1. QueryHelper.java
        4 kB
        sjy
      2. Maintance.java
        2 kB
        sjy
      3. Configurations.java
        3 kB
        sjy

        Activity

        sjy made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        sjy made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        sjy made changes -
        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.
        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)


        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)


        sjy made changes -
        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)


        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.
        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)


        sjy made changes -
        Attachment QueryHelper.java [ 12450037 ]
        Attachment Configurations.java [ 12450038 ]
        Attachment Maintance.java [ 12450039 ]
        sjy made changes -
        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 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)


        sjy made changes -
        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(near where the wrong syntax);
        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);
        sjy made changes -
        Field Original Value New Value
        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 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)
        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(near where the wrong syntax);
        sjy created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            sjy
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 168h
              168h
              Remaining:
              Remaining Estimate - 168h
              168h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Development