Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

The specified SQL type is not supported by this driver.

 
Dan Howard
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic