Announcement Announcement Module
Collapse
No announcement yet.
MSSQL driver error: Null parameters crash Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MSSQL driver error: Null parameters crash

    Hello.
    MSSQL. I'm trying to execute stored proc:
    getJdbcTemplate().update("{spw_updateuserinfo(?, ?)}", new Object[] {userId, userName});
    spw_updateuserinfo only updates record.
    userId == 6, userName == null.
    Dispalayed:
    org.springframework.jdbc.UncategorizedSQLException : PreparedStatementCallback; uncategorized SQLException for SQL [{call spw_updateuserinfo(?,?)}]; SQL state [HY004]; error code [0]; [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.
    Help, plz.

  • #2
    Originally posted by stoweesh
    Hello.
    MSSQL. I'm trying to execute stored proc:
    getJdbcTemplate().update("{spw_updateuserinfo(?, ?)}", new Object[] {userId, userName});
    spw_updateuserinfo only updates record.
    userId == 6, userName == null.
    Dispalayed:
    org.springframework.jdbc.UncategorizedSQLException : PreparedStatementCallback; uncategorized SQLException for SQL [{call spw_updateuserinfo(?,?)}]; SQL state [HY004]; error code [0]; [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.
    Help, plz.
    Use a better driver - specifically jTDS.

    Comment


    • #3
      Thanks a lot, it works!

      Comment

      Working...
      X