Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Servlet and JDBC error

 
Rashmi Trivedi
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All
I am having lot of problem when i am trying to insert date in MS SQL Server database.

On MS SQL Server the column is Change Date and datetime data type.

i get the string variable from HTML form and then convert into java.sql.Date format.

and then insert into SQL Server as setDate.

I am getting following problem:

java.lang.illegalException

java.sql.slqexception - MS SQL Server (ODBC driver error)- Optional features are not installed or implemented.

Please help me out here as i am stuck and do not have much clue as to what to do.

thanks in advance and your help is very much appreciated.

regards,
Rashmi Trivedi
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rashmi,
I don't have access to SQL server, but sharing which JDBC driver you are using might help you get an answer.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic