MSSQL2000: the driver does not support the specified SQL type

Source: Internet
Author: User
Com. ibatis. common. jdbc. exception. NestedSQLException: --- theerroccurredinconfuser. xml. --- Contents. --- ChecktheupdateUser-InlineParameterMap. --- Checktheparametermappingfortheid

Com. ibatis. common. jdbc. exception. nestedSQLException: --- The error occurred in conf/User. xml. --- The error occurred while applying a parameter map. --- Check the updateUser-InlineParameterMap. --- Check the parameter mapping for the 'id'

Com. ibatis. common. jdbc. exception. NestedSQLException:
--- The error occurred in conf/User. xml.
--- The error occurred while applying a parameter map.
--- Check the updateUser-InlineParameterMap.
--- Check the parameter mapping for the 'id' property.
--- Cause: java. SQL. SQLException: [Microsoft] [SQLServer 2000 Driver for JDBC] The specified SQL type is not supported by this driver.
Caused by: java. SQL. SQLException: [Microsoft] [SQLServer 2000 Driver for JDBC] The specified SQL type is not supported by this driver.
At com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.exe cuteUpdate (GeneralStatement. java: 91)
At com. ibatis. sqlmap. engine. impl. SqlMapExecutorDelegate. update (SqlMapExecutorDelegate. java: 504)
At com. ibatis. sqlmap. engine. impl. SqlMapSessionImpl. update (SqlMapSessionImpl. java: 90)
At com. ibatis. sqlmap. engine. impl. SqlMapClientImpl. update (SqlMapClientImpl. java: 68)
At ibatis. dao. UserTestCase. testUpdateUser (UserTestCase. java: 136)
At sun. reflect. NativeMethodAccessorImpl. invoke0 (Native Method)
At sun. reflect. NativeMethodAccessorImpl. invoke (Unknown Source)
At sun. reflect. DelegatingMethodAccessorImpl. invoke (Unknown Source)
At java. lang. reflect. Method. invoke (Unknown Source)
At junit. framework. TestCase. runTest (TestCase. java: 154)
At junit. framework. TestCase. runBare (TestCase. java: 127)
At junit. framework. TestResult $1. protect (TestResult. java: 106)
At junit. framework. TestResult. runProtected (TestResult. java: 124)
At junit. framework. TestResult. run (TestResult. java: 109)
At junit. framework. TestCase. run (TestCase. java: 118)
At junit. framework. TestSuite. runTest (TestSuite. java: 208)
At junit. framework. TestSuite. run (TestSuite. java: 203)
At org. eclipse. jdt. internal. junit. runner. RemoteTestRunner. runTests (RemoteTestRunner. java: 478)
At org. eclipse. jdt. internal. junit. runner. RemoteTestRunner. run (RemoteTestRunner. java: 344)
At org. eclipse. jdt. internal. junit. runner. RemoteTestRunner. main (RemoteTestRunner. java: 196)
Caused by: java. SQL. SQLException: [Microsoft] [SQLServer 2000 Driver for JDBC] The specified SQL type is not supported by this driver.
At com. microsoft. jdbc. base. BaseExceptions. createException (Unknown Source)
At com. microsoft. jdbc. base. BaseExceptions. getException (Unknown Source )?
?????? This problem is very strange, because I have no problem in DAO unit testing, but the above problem occurs during integration testing.
Then, I find in the network, I found a (http://www.iteye.com/post/134608) mentioned in the middle, for a driver to try.
Of course, I tried it. I can see the log. The original id value is NULL, so there is a problem. The final problem also occurs. Be careful in development and be careful.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.