Uploaded image for project: 'Cloud Enablement'
  1. Cloud Enablement
  2. CLOUD-3462

[os-eap-launch] Add workaround for the 'Method setURL not found' failure

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • EAP72 7.2.3.GA
    • EAP7
    • None

    Description

      When attempting to create external PostgreSQL xa datasource to use ssl in RH-SSO 7.3.5 running on OpenShift 3.11, the following exception is logged:

      WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 66) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection
	at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:531)
	at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:438)
	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1328)
	...
Caused by: javax.resource.ResourceException: IJ031102: Failed to load XA datasource: org.postgresql.xa.PGXADataSource
	at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:662)
	at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:515)
	... 54 more
Caused by: java.lang.NoSuchMethodException: Method setURL not found
	at org.jboss.jca.adapters.jdbc.util.Injection.inject(Injection.java:139)
	at org.jboss.jca.adapters.jdbc.util.Injection.inject(Injection.java:68)
	at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:657)
	... 55 more

      According to package list (page 19) [1], the JDBC driver for PostgreSQL we ship with RH-SSO image is postgresql-jdbc-9.2.1002-6.el7_5.noarch. The issue is not present with newer driver [2].

      I am opening this to update the PostgreSql driver we ship with RH-SSO image.
      I found a similar issue for the RHPAM project (RHPAM-904) and I am linking it to this Jira.

      [1] https://access.redhat.com/containers/?tab=package-list#/registry.access.redhat.com/redhat-sso-7/sso73-openshift/images/1.0-19
      [2] https://jdbc.postgresql.org/download/postgresql-42.2.9.jar

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. RHPAM-904 database exception using rhpam70-kieserver-externaldb.yaml when connecting to PostgreSQL

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              kwills@redhat.com Ken Wills
              rhn-support-mavassil Maria Vassileva
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: