java.sql.SQLException: Not implemented (type is Types.OTHER)
Joined: Jul 09, 2004
Hello all. My insert statement is runnig correctly for mysql database. But it is giving me error "Error executing update. Cause: java.sql.SQLException: Not implemented (type is Types.OTHER)" when I am using MS-Sql Server database. I have provided all driver/ jars and other queries are running fine. Which is the data type supported by mysql and not supported by MS-Sql server? Can you please guide me for tackling this error? Thanks in advance. Girish Varde
Joined: Aug 02, 2004
Can you post a code snippet illustrating what you're doing, please? The error message seems to be complaining about the type of one of the parameters to your insert PreparedStatement. Are you using MySQL-specific JDBC code, trying to insert something unusual or using setNull() or setObject() with a parameter of java.sql.Types.OTHER?
Joined: Aug 19, 2004
This seems to be a driver level issue. The microsoft's JDBC driver for SQL Server 2000 will definitely NOT support Types.OTHER. I have faced the problem myself.
We could narrow down the problem further if you gave details about the driver you are using and the kind of data type that you are dealing with through Types.OTHER.