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.processE xception(RequestProcessor.java:545)
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:486)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.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.inv oke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.doF orward(ApplicationDispatcher.java:432)
at org.apache.catalina.core.ApplicationDispatcher.for ward(ApplicationDispatcher.java:356)
at org.apache.struts.action.RequestProcessor.doForwar d(RequestProcessor.java:1069)
at org.apache.struts.action.RequestProcessor.processF orwardConfig(RequestProcessor.java:455)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.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.in ternalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.valves.CertificatesValve.invok e(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:509)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)

Help please.
Bye

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).

"Mario" <mariofacu@yahoo.com.ar> wrote in message
news:d066c99b.0309291119.2743cc78@posting.google.c om...
> 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.processE xception(RequestProcessor.
java:545)
> at
org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProces
sor.java:486)
> at
org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
> at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
> at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.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.inv oke(ApplicationDispatcher.
java:684)
> at
org.apache.catalina.core.ApplicationDispatcher.doF orward(ApplicationDispatch
er.java:432)
> at
org.apache.catalina.core.ApplicationDispatcher.for ward(ApplicationDispatcher
..java:356)
> at
org.apache.struts.action.RequestProcessor.doForwar d(RequestProcessor.java:10
69)
> at
org.apache.struts.action.RequestProcessor.processF orwardConfig(RequestProces
sor.java:455)
> at
org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:279)
> at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
> at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.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.in ternalDoFilter(Application
FilterChain.java:247)
> at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterCh
ain.java:193)
> at
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.ja
va:256)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
> at
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.ja
va:191)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.valves.CertificatesValve.invok e(CertificatesValve.java:2
46)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
> at
org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2415)
> at
org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180
)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.
java:171)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172
)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:509)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
> at
org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java
:174)
> at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:223)
> at
org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:594)
> at
org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConne
ction(Http11Protocol.java:392)
> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:565)
> at
org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.jav
a:619)
> at java.lang.Thread.run(Thread.java:534)
>
> Help please.
> Bye