德比10.10与JBoss的JNDI连接为7.1 :错误的驱动程序类[类org.apache.derby.jdbc.ClientDriver]

Question

我已经创建了JNDI connection with JBoss AS 7.1并能够获得DataSource。但是，当我试图获得连接时，我得到的是错误。

请告诉我哪里做错了。

这里是我在eclipse上收到的异常.

18:21:28,648在尝试获得新连接时警告org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277) org.jboss.jca.core.connectionmanager.pool.strategy.OnePool IJ000604: Throwable : null: javax.resource.ResourceException:无法在org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761) at org上创建连接.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl( org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129) at com.student.dbtest.DBConnectionTest.doPost(DBConnectionTest.java:53) classes: at com.student.dbtest.DBConnectionTest.doGet(DBConnectionTest.java:36) classes: at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) )jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) jbossweb-7.0.13.Final.jar: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) jbossweb-7.0.13.Final.jar: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) jbossweb-7.0.13.Final.jar: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) jbossweb-7.0.13.Final.jar: at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) jbossWeb7.1.1.Final.jar:7.1.1.Final at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) jbossweb-7.0.13.Final.jar: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) jbossweb-7.0.13.Final.jar: at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) jbossweb-7.0.13.Final.jar：：org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) jbossweb-7.0.13.Final.jar: at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) jbossweb-7.0.13.Final.jar: at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) jbossweb-7.0.13.Final.jar: at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) -7.0.13.final.jar: at java.lang.Thread.run(未知来源) rt.jar:1.6.0_45 由: org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:251) . 26处的javax.resource.ResourceException:错误的驱动程序类org.apache.derby.jdbc.ClientDriver引发

Answer 1

正如例外情况所述，对于这个连接URL，您有错误的驱动程序类。

Derby支持两种类型的部署:嵌入式部署和客户机/服务器部署。

http://db.apache.org/derby/docs/10.10/getstart/cgsquck70629.html

这两种不同类型的部署使用不同的JDBC驱动程序类名和不同的JDBC连接URL语法。

下面是关于嵌入式驱动程序和嵌入URL的一些信息：overview.html

以下是关于客户端驱动程序和客户端URL的一些信息：http://db.apache.org/derby/docs/10.10/getstart/twwdactivity2.html