This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Not implemented (type is Types.OTHER)" Watch "java.sql.SQLException: Not implemented (type is Types.OTHER)" New topic
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Not implemented (type is Types.OTHER)
 
Similar Threads
Error: SQL type is not supported by this driver
Servlet and JDBC error
Unhandled token type: ROW
file selected by JFileChooser and storing that image file in ms-access
storing image file in ms-access using jdbc