File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes The specified SQL type is not supported by this driver. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "The specified SQL type is not supported by this driver." Watch "The specified SQL type is not supported by this driver." New topic
Author

The specified SQL type is not supported by this driver.

Dan Howard
Greenhorn

Joined: Oct 10, 2004
Posts: 15
Hi everyone,

I'm trying to update a table with a datetime field in an MS-SQL database but I'm getting: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver."

I'm assigning the value like this:



The "be" object is returning a proper java.util.Date object.

The error is occurring on the line:


Any ideas???
Dan Howard
Greenhorn

Joined: Oct 10, 2004
Posts: 15
Of course, just after posing I realized the problem.

It should be:

r.updateTimestamp("LastDate", new Timestamp(be.getLastDate().getTime()));

I am still getting this error though if I assign null to any of these date fields.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
may be your field in the database is defined as not null?? check it out.
and yes one more thing are you gettin the same error, that you were gettin previously? if not please paste the stack.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: The specified SQL type is not supported by this driver.