You need to use java.sql.Timestamp instead of java.sql.Date -Seth
--On Saturday, July 27, 2002 12:04 AM +0530 Narayan Singh <[EMAIL PROTECTED]> wrote: > Dear all, > This is my first mail to the group. I have an entity EJB which uses > CMP. One of the CMP fields is of java.sql.Date type.I am using MS SQL > 2000 server as database server. I created a table in which the > corresponding mapping column is of type DATETIME.I am using JBOSS2.2 and > JDBC-ODBC bridge. I am unable to create the entity EJB. The following is > the trace of exceptions i got. I think this problem is faced by some of u > already..I will thankful to u if u find some solution to fix this problem > ************************ > > [JAWS] java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional > feature not implemented > [JAWS] at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterDate(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setDate(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(Unknown > Source) [JAWS] at > sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(Unknown Source) [JAWS] > at > org.opentools.minerva.jdbc.PreparedStatementInPool.setObject(PreparedStat > eme ntInPool.java:282) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java > :33 4) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters(JDB > CCr eateEntityCommand.java:165) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java: > 159 ) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreat > eEn tityCommand.java:135) > [JAWS] at > org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersis > ten ceManager.java:122) > [JAWS] at > org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceMa > nag er.java:207) > [JAWS] at > org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441) > [JAWS] at java.lang.reflect.Method.invoke(Native Method) > [JAWS] at > org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityConta > ine r.java:639) > [JAWS] at > org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntityS > ync hronizationInterceptor.java:160) > [JAWS] at > org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstance > Int erceptor.java:87) > [JAWS] at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:1 > 35) [JAWS] at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorC > MT. java:263) > [JAWS] at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:8 > 6) [JAWS] at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor. > jav a:164) > [JAWS] at > org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) > [JAWS] at > org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316) > [JAWS] at > org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPCon > tai nerInvoker.java:369) > [JAWS] at java.lang.reflect.Method.invoke(Native Method) > [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) > [JAWS] at sun.rmi.transport.Transport$1.run(Unknown Source) > [JAWS] at java.security.AccessController.doPrivileged(Native Method) > [JAWS] at sun.rmi.transport.Transport.serviceCall(Unknown Source) > [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown > Source) [JAWS] at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) > [JAWS] at java.lang.Thread.run(Unknown Source) > [JAWS] java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional > feature not implemented > [JAWS] at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterDate(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setDate(Unknown Source) > [JAWS] at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(Unknown > Source) [JAWS] at > sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(Unknown Source) [JAWS] > at > org.opentools.minerva.jdbc.PreparedStatementInPool.setObject(PreparedStat > eme ntInPool.java:282) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java > :33 4) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters(JDB > CCr eateEntityCommand.java:165) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java: > 159 ) > [JAWS] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreat > eEn tityCommand.java:135) > [JAWS] at > org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersis > ten ceManager.java:122) > [JAWS] at > org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceMa > nag er.java:207) > [JAWS] at > org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441) > [JAWS] at java.lang.reflect.Method.invoke(Native Method) > [JAWS] at > org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityConta > ine r.java:639) > [JAWS] at > org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntityS > ync hronizationInterceptor.java:160) > [JAWS] at > org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstance > Int erceptor.java:87) > [JAWS] at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:1 > 35) [JAWS] at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorC > MT. java:263) > [JAWS] at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:8 > 6) [JAWS] at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor. > jav a:164) > [JAWS] at > org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) > [JAWS] at > org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316) > [JAWS] at > org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPCon > tai nerInvoker.java:369) > [JAWS] at java.lang.reflect.Method.invoke(Native Method) > [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) > [JAWS] at sun.rmi.transport.Transport$1.run(Unknown Source) > [JAWS] at java.security.AccessController.doPrivileged(Native Method) > [JAWS] at sun.rmi.transport.Transport.serviceCall(Unknown Source) > [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown > Source) [JAWS] at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) > [JAWS] at java.lang.Thread.run(Unknown Source) > > *************************** > Thanx in advance > Regards, > N Narayan Singh > > > > > > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
