sql server odbc: I´m using Jboss and SQL Server i have an entity Java bean with a Date
field. This is the code:

/**
* @ejb.persistence
* column-name="FECHA"
* jdbc-type="DATE"
* sql-type="datetime"
*/
public abstract java.sql.Date getFecha( );
public abstract void setFecha( java.sql.Date date );


/**
* @ejb.value-object
*/
public void setStringDate( String d ) throws ParseException{
java.sql.Date date = java.sql.Date.valueOf( d );
setFecha( date );
}

/**
* @ejb.value-object
*/
public String getStringDate() {
java.sql.Date date = getFecha();
SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
return sdf.format(date);
}

but when I trie to set a date I get the following error message:

javax.servlet.ServletException: null; CausedByException is:
Internal error setting parameters for field fecha; CausedByException
is:
SQL Exception : [Microsoft][ODBC SQL Server Driver]Optional feature
not implemented; - nested throwable: (javax.ejb.EJBException: Internal
error setting parameters for field fecha; CausedByException is:
SQL Exception : [Microsoft][ODBC SQL Server Driver]Optional feature
not implemented)
at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)

Help please.

SQL Server does not support a DATE type, therefore the SQL Server ODBC
Driver does not support the SQL_DATE binding. You might want to look into
using the datetime data type instead (the cooresponding ODBC types are
SQL_C_TIMESTAMP and SQL_TYPE_TIMESTAMP).

[quoted text, click to view]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.
java:545)
[quoted text, click to view]
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:486)
[quoted text, click to view]
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:684)
[quoted text, click to view]
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch
er.java:432)
[quoted text, click to view]
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher
..java:356)
[quoted text, click to view]
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:10
69)
[quoted text, click to view]
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProces
sor.java:455)
[quoted text, click to view]
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
[quoted text, click to view]
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
[quoted text, click to view]
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
[quoted text, click to view]
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
[quoted text, click to view]
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
[quoted text, click to view]
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
[quoted text, click to view]
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
[quoted text, click to view]
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
[quoted text, click to view]
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
[quoted text, click to view]
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
[quoted text, click to view]
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
[quoted text, click to view]
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
[quoted text, click to view]