File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Girish Varde
Greenhorn
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 823
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 29
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic