Question

6
Replies
2350
Views
ROHITHJETTI Member since 2011 5 posts
Capgemini
Posted: 4 years ago
Last activity: 2 years 11 months ago
Closed
Solved

org.postgresql.util.PSQLException: This connection has been closed when installing pega719

Hello Team,

We are trying to install Pega719 in Linux with postgreSQL db. we have correctly installed postgreSQL DB & created rules and data schema.

PLJava

------------------------------------------------

Contains a sql script, java archive and related shared library to enable Postgres 9.3 to be con

figured to support Java User Defined Functions (UDF).

This is a pre-installation step that needs to be performed before Pega 7 installation is attemp

ted. These steps assume a supported version of Java is

already installed and accessible (java -version).

        For Linux:

        1)created a symbolic link for libjvm.so in /lib64

                ln -s /usr/java/jdk1.6.0_45/jre/lib/amd64/server/libjvm.so /lib64/libjvm.so

        2) Copied pljava.so and pljava.jar, deploy.jar files from the ResourceKit folder to the <Postgres Home>/lib directory (typically /usr/pgsql-9.3/lib)

        3) Updated the postgres.conf file located in data directory (typically /var/lib/pgsql/9.3/data) with the settings below where

<Postgres Home>           is the path to the Postgres lib directory using normal Linux single slashes as path

seperators

                work_mem = 5MB

                pljava.classpath='<Postgres Home>/lib/pljava.jar'

But, while performing installation, installation is getting struck at the below specified point. Can somebody please help me on this.

Thanks you very much in advance.

_________________________________________________________________________________________________________________

Install UDF Jar:

     [java] 2015-12-26 21:23:24,690 (              DatabaseLibraryLoader)    INFO - Loading user-defined functions into the database.

     [java] 2015-12-26 21:23:24,725 (              DatabaseLibraryLoader)    INFO - Using a Postgres database.

     [java] 2015-12-26 21:23:26,269 (              DatabaseLibraryLoader)    INFO - Jar is not already loaded.

     [java] 2015-12-26 21:23:26,552 (              DatabaseLibraryLoader) WARNING - Encountered a database problem when attempting to load jar onto PostgreSQL: This connection has been closed.

     [java]

     [java] org.postgresql.util.PSQLException: This connection has been closed.

     [java] at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:750)

     [java] at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:709)

     [java] at com.pega.pegarules.install.DatabaseLibraryLoader.installJarOnPostgres(DatabaseLibraryLoader.java:279)

     [java] at com.pega.pegarules.install.DatabaseLibraryLoader.runMainProgramWithoutExiting(DatabaseLibraryLoader.java:226)

     [java] at com.pega.pegarules.install.DatabaseLibraryLoader.main(DatabaseLibraryLoader.java:144)

     [java] 2015-12-26 21:23:26,552 (              DatabaseLibraryLoader)    INFO -

     [java] *****************************************************************************************************

     [java]

     [java] Encountered database error attempting to load UDF library onto PostgreSQL, clean schema before running again.

     [java]

     [java] *****************************************************************************************************

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn