Close popover
Rohith Jetti (ROHITHJETTI)

ROHITHJETTI Member since 2011 5 posts
Posted: December 26, 2015
Last activity: October 4, 2018

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.



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 in /lib64

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

        2) Copied 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


                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] org.postgresql.util.PSQLException: This connection has been closed.

     [java] at org.postgresql.jdbc.PgConnection.checkClosed(

     [java] at org.postgresql.jdbc.PgConnection.setAutoCommit(

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

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

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

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

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


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


     [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.

System Administration Installation and Deployment
Moderation Team has archived post