This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLException: Not implemented (type is Types.OTHER) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLException: Not implemented (type is Types.OTHER)" Watch "java.sql.SQLException: Not implemented (type is Types.OTHER)" New topic

java.sql.SQLException: Not implemented (type is Types.OTHER)

Girish Varde

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?

Prashant Jain

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
I agree. Here's the link:
subject: java.sql.SQLException: Not implemented (type is Types.OTHER)
It's not a secret anymore!