Hello, I want to use JBoss with a MSAccess-DB. I'm using: Windows XP JBoss-4.0.3-SP1 (The newest) JBoss-EJB3.0-RC3 Eclipse 3.1.1 MS Access 2000 Sun's JDBC/ODBC-Driver
I've tried the following two steps: 1. Edit a "*-ds.xml" and put it into "server/all/deploy": | <datasources> | <local-tx-datasource> | <jndi-name>TestDS</jndi-name> | <connection-url>jdbc:odbc:Test</connection-url> | <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class> | <metadata> | <type-mapping>MS ACCESS2000</type-mapping> | </metadata> | </local-tx-datasource> | </datasources> | The MS ACCESS2000 - type mapping looks like the MS SQLServer2000 - type mapping. 2. In my project edit "persistence.xml" and put it into the "*.ejb3/META-INF": | <?xml version="1.0" encoding="UTF-8"?> | <entity-manager> | <jta-data-source>java:/TestDS</jta-data-source> | <properties> | <property name="hibernate.hbm2ddl.auto" value="none"/> | <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/> | </properties> | </entity-manager> | When I deploy the application it's all ok, but when I start the application I get the following errors: 11:07:28,359 WARN [AbstractBatcher] exception clearing maxRows/queryTimeout | java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optionales Feature wurde nicht implementiert. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) | at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) | at sun.jdbc.odbc.JdbcOdbc.SQLGetStmtOption(JdbcOdbc.java:4417) | at sun.jdbc.odbc.JdbcOdbcStatement.getStmtOption(JdbcOdbcStatement.java:1208) | at sun.jdbc.odbc.JdbcOdbcStatement.getQueryTimeout(JdbcOdbcStatement.java:697) | at org.jboss.resource.adapter.jdbc.WrappedStatement.getQueryTimeout(WrappedStatement.java:281) | at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:224) | at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:160) | at org.hibernate.loader.Loader.doQuery(Loader.java:714) | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223) | at org.hibernate.loader.Loader.doList(Loader.java:2147) | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026) | at org.hibernate.loader.Loader.list(Loader.java:2021) | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) | at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298) | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020) | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) | at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:38) | at org.jboss.ejb3demo.AuthorsBean.getAllAuthors(AuthorsBean.java:38) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:109) | at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:32) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:66) | at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:134) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:61) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:32) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:91) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:204) | at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107) | at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:37) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:88) | at $Proxy88.getAllAuthors(Unknown Source) | at org.jboss.ejb3demo.web.AuthorServlet.showArticles(AuthorServlet.java:75) | at org.jboss.ejb3demo.web.AuthorServlet.doPost(AuthorServlet.java:50) | at org.jboss.ejb3demo.web.AuthorServlet.doGet(AuthorServlet.java:38) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) | at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) | at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) | at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) | at java.lang.Thread.run(Thread.java:595) | 11:08:16,828 WARN [JDBCExceptionReporter] SQL Error: -3516, SQLState: 3700011:08:16,828 ERROR [JDBCExceptionReporter] [Microsoft][ODBC Microsoft Access Driver] Fehlendes Semikolon (;) am Ende der SQL-Anweisung. | 11:08:16,828 ERROR [[AuthorServlet]] Servlet.service() for servlet AuthorServlet threw exception | javax.ejb.EJBException: null; CausedByException is: | could not insert: [org.jboss.ejb3demo.Author] | at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:46) | at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:70) | at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:134) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:61) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:32) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:91) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:204) | at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107) | at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:37) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:88) | at $Proxy88.addArticle(Unknown Source) | at org.jboss.ejb3demo.web.AuthorServlet.createArticles(AuthorServlet.java:61) | at org.jboss.ejb3demo.web.AuthorServlet.doPost(AuthorServlet.java:52) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) | at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) | at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) | at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) | at java.lang.Thread.run(Thread.java:595) | org.hibernate.exception.SQLGrammarException: could not insert: [org.jboss.ejb3demo.Author] | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985) | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2404) | at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37) | at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) | at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269) | at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167) | at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101) | at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131) | at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87) | at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38) | at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:590) | at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:568) | at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:130) | at org.jboss.ejb3.entity.InjectedEntityManager.persist(InjectedEntityManager.java:97) | at org.jboss.ejb3demo.AuthorsBean.addArticle(AuthorsBean.java:20) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:109) | at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:32) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:66) | at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:134) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:61) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:32) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:91) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:204) | at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107) | at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:37) | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) | at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:88) | at $Proxy88.addArticle(Unknown Source) | at org.jboss.ejb3demo.web.AuthorServlet.createArticles(AuthorServlet.java:61) | at org.jboss.ejb3demo.web.AuthorServlet.doPost(AuthorServlet.java:52) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) | at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) | at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) | at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) | at java.lang.Thread.run(Thread.java:595) | Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Fehlendes Semikolon (;) am Ende der SQL-Anweisung. | at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) | at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) | at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3150) | at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:183) | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1952) | ... 63 more Is there anymore that I have to do??? Greetings Karl View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3917818#3917818 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3917818 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
