| Author |
java.sql.SQLException: Not implemented (type is Types.OTHER)
|
Girish Varde
Greenhorn
Joined: Jul 09, 2004
Posts: 23
|
|
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
|
 |
Julian Kennedy
Ranch Hand
Joined: Aug 02, 2004
Posts: 823
|
|
Hi Girish,
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?
Jules
|
|
Prashant Jain
Greenhorn
Joined: Aug 19, 2004
Posts: 29
|
|
hi girish!
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.
Prashant Jain
prashantjainn@yahoo.com
|
|
 |
|
|
subject: java.sql.SQLException: Not implemented (type is Types.OTHER)
|
|
|
0
