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

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

      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

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

                Created:
                Updated: