JDBC-ODBC bridge doesn't support setDate. Lame. You can either generate a SQL string instead of using a PreparedSatement. Pass the 'quoted' java.sql.Date.
ex: "UPDATE theTable SET theDate = '" + javaSqlDateObject + "'"; Or you could get a JDBC driver specifically for SQL Server. Greg -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]]On Behalf Of Emmanuel Eze Sent: Tuesday, May 07, 2002 7:25 AM To: [EMAIL PROTECTED] Subject: PreparedStatement Error I get the following error message when i call the setDate() method of the PreparedStatement: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented I am connecting to an MS SQL Server 2000 using JDBC-ODBC brige. Does anyone know a fix? Emma =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
