aspose 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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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.
 
Similar Threads
how to call a stored procedure which return cursor
Error: SQL type is not supported by this driver
Adding a record to a database-new to JDBC
Database Abstract Factory
Storedprocedures returns cursor