Announcement Announcement Module
Collapse
No announcement yet.
ms sqlserver JDBC driver supports batching? Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • ms sqlserver JDBC driver supports batching?

    I use spring jdbc and ms sqlserver JDBC driver,but I encounter a error
    org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [update Bookreview set F_IsAvaliable = 0 where F_reviewID = ?] in task 'executing PreparedStatementCallback [org.springframework.jdbc.core.JdbcTemplate$SimpleP reparedStatementCreator@1d3ac6e]'; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
    org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:90)
    org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:228)
    org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:439)
    org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:452)
    org.springframework.jdbc.core.JdbcTemplate.batchUp date(JdbcTemplate.java:683)

  • #2
    AFAIK, the default ms jdbc driver is very faulty and contains a lot of bugs. Try using jTDS : http://jtds.sourceforge.net/ - I heard only good words about it.

    P.S. in your case the driver is the problem not Spring.

    Comment


    • #3
      thanks

      Comment

      Working...
      X