Results 1 to 3 of 3

Thread: MSSQL driver error: Null parameters crash

Hybrid View

  1. #1
    Join Date
    Dec 2005
    Posts
    2

    Default 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. #2
    Join Date
    Dec 2005
    Location
    London
    Posts
    22

    Default

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

  3. #3
    Join Date
    Dec 2005
    Posts
    2

    Default

    Thanks a lot, it works!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •