I suggest you use the Microsoft SQL Server JDBC drivers instead of the JDBC-ODBC bridge.
-dain Seth Sites wrote: > 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-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
