mysql - Oracle ADF - Tomcat 6.x - MySql 5.5 - java.lang.AbstractMethodError

Question

我们使用 Oracle ADF web 应用开发了

• jDeveloper 11.1.2.4
• MySql 5.5

在谷歌的大量帮助下，我们在这篇文章中将我们的应用程序部署到了 tomcat 上。 Oracle ADF onto Tomcat 6.x

在上面的帖子中，他使用了 Oracle Db。我们使用 Oracle 部署了一个测试应用程序。它运行良好。但是我们的原始应用程序必须与 MySql 一起使用。我们已经设置了我们的连接配置如下。在 conf/context.xml 中

<ResourceLink global="jdbc/webApp" name="jdbc/MySqlCOnDSDS" type="javax.sql.DataSource"/>

conf/server.xml

<Resource name ="jdbc/webApp" auth="Container" 
    type="javax.sql.DataSource" 
    driverClassName="com.mysql.jdbc.Driver" 
    url="jdbc:mysql://localhost:3306/easyrun" 
    username="teja" password="teja" 
    maxActive="20" maxIdle="10" maxWait="10000"/>

当我们尝试运行我们的页面 (first.jsf) 时，我们收到以下错误。

javax.servlet.ServletException: Servlet execution threw an exception
    oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:173)
    oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:125)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
    oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:293)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:199)
    org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
root cause

java.lang.AbstractMethodError: org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.isClosed()Z
    oracle.jbo.server.QueryCollection.setResultSetState(QueryCollection.java:5624)
    oracle.jbo.server.QueryCollection.hasNextInResultSet(QueryCollection.java:4859)
    oracle.jbo.server.ViewObjectImpl.hasNextForCollection(ViewObjectImpl.java:7306)
    oracle.jbo.server.QueryCollection.hasNext(QueryCollection.java:4768)
    oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1294)
    oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
    oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
    oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
    oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1413)
    oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1319)
    oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1304)
    oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:7211)
    oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBindingIfNeeded(DCJboDataControl.java:1366)
    oracle.adf.model.binding.DCIteratorBinding.executeQueryIfNeeded(DCIteratorBinding.java:2219)
    oracle.jbo.uicli.binding.JUCtrlHierBinding.getRootNodeBinding(JUCtrlHierBinding.java:92)
    oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding$FacesModel.addRowKeyChangeListener(FacesCtrlHierBinding.java:616)
    oracle.adfinternal.view.faces.renderkit.rich.TableRendererUtils.registerRowKeyChangeListener(TableRendererUtils.java:2715)
    oracle.adfinternal.view.faces.renderkit.rich.TableRenderer.encodeAll(TableRenderer.java:758)
    oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)
    org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)
    org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)
    org.apache.myfaces.trinidad.component.UIXCollection.encodeEnd(UIXCollection.java:617)
    javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)
    org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:624)
    oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:3201)
    org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:641)
    oracle.adf.view.rich.render.RichRenderer.encodeAllChildrenInContext(RichRenderer.java:3062)
    oracle.adfinternal.view.faces.renderkit.rich.FormRenderer.encodeAll(FormRenderer.java:274)
    oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)
    org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)
    org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)
    javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)
    org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:624)
    oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:3201)
    org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:641)
    oracle.adf.view.rich.render.RichRenderer.encodeAllChildrenInContext(RichRenderer.java:3062)
    oracle.adfinternal.view.faces.renderkit.rich.DocumentRenderer.encodeAll(DocumentRenderer.java:1275)
    oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)
    org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)
    org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)
    javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)
    javax.faces.component.UIComponent.encodeAll(UIComponent.java:1677)
    oracle.adfinternal.view.faces.component.AdfViewRoot.encodeAll(AdfViewRoot.java:91)
    com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:399)
    org.apache.myfaces.trinidadinternal.application.ViewDeclarationLanguageFactoryImpl$ChangeApplyingVDLWrapper.renderView(ViewDeclarationLanguageFactoryImpl.java:350)
    com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
    javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:273)
    org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:165)
    oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:1035)
    oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:342)
    oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:236)
    javax.faces.webapp.FacesServlet.service(FacesServlet.java:509)
    oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:173)
    oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:125)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
    oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:293)
    org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:199)
    org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

请帮助我们..

提前致谢。

Answer 1

Tomcat 6 数据源实现未升级为与 Java 1.6 一起使用。

您可以按照以下步骤切换到 Apache 数据源实现:

1. 下载 commons-dbcp 1.4 并将其复制到 $CATALINA_HOME/lib
2. 下载 commons-pool 1.5.5 并将其复制到 $CATALINA_HOME/lib
3. 更改您的“资源”标签以包含以下属性:factory="org.apache.commons.dbcp.BasicDataSourceFactory"