Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-3005

Custom Database Image for PostgresSQL Enterprise not working

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Minor
    • None
    • 7.8.0.GA
    • Cloud, Documentation
    • None
    • Documentation (Ref Guide, User Guide, etc.), Release Notes
    • It must say that in order to use PostgresSQL Plus external database, we cannot use the service + host parameters, but the URL (or jdbcURL) parameter.
    • Hide

      The workaround is to use the postgresql connection string format.

      Show
      The workaround is to use the postgresql connection string format.
    • Hide

      Given Custom Database Image for postgresql using a PostgresSQL Enterprise instance
      When Deploy Kie Server using S2I
      Then Kie Server is unable to start (see logs)

      Show
      Given Custom Database Image for postgresql using a PostgresSQL Enterprise instance When Deploy Kie Server using S2I Then Kie Server is unable to start (see logs)

    Description

      When we create a custom database for postgresql:

      make build postgresql

      And push the image to be accessed by Openshift.
      And using a Posgresql Enterprise instance:

      db.primary_label=postgresplus116
db.port=5432
server_label_primary=postgresplus116
hibernate.dialect=org.hibernate.dialect.PostgresPlusDialect
hibernate.connection.url=jdbc\:edb\://edb-as11.mwqe.upshift.rdu2.redhat.com\:5432/dballo06
hibernate.connection.schema=public
datasource.class.xa=com.edb.xa.PGXADataSource

      The kie server image is properly built but when running the instance is unable to start because:

      Caused by: javax.resource.ResourceException: IJ031083: Wrong driver class [org.postgresql.Driver] for this connection URL [jdbc:edb://edb-as11.mwqe.upshift.rdu2.redhat.com:5432/dballo05]
	at org.jboss.ironjacamar.jdbcadapters@1.4.18.Final-redhat-00001//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:323)
	... 52 more

      I've attached all the logs here.

      The same using a non Enterprise Postgres database is working fine.

      Attachments

        Activity

          People

            rhn-support-fspolti Filippe Spolti
            jcarvaja@redhat.com Jose Carvajal Hilario
            Jakub Schwan Jakub Schwan
            Jakub Schwan Jakub Schwan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: