Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rohith Jetti (ROHITHJETTI)
Capgemini

Capgemini
IN
ROHITHJETTI Member since 2011 5 posts
Capgemini
Posted: Dec 26, 2015
Last activity: Oct 4, 2018
Posted: 26 Dec 2015 11:08 EST
Last activity: 4 Oct 2018 11:08 EDT
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.

Show More

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.


Show Less
To see attachments, please log in.
Installation and Deployment

Posted: 8 years ago
Posted: 26 Dec 2015 21:55 EST
Veera Gangababu Gollapalli (Gangababu)
PEGA
Principal Technical Solutions Engineer
PEG
IN

Hi,

Did you place the postgres related jar's in application server lib directory? From the stacktrace it looks like jar has been loaded properly.

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

To see attachments, please log in.
Posted: 8 years ago
Posted: 26 Dec 2015 22:12 EST
Rohith Jetti (ROHITHJETTI)
Capgemini

Capgemini
IN

Hello Babu,

Thank you very much for your  quick response over weekend.

As of now, i am just on the trying to setup pega719 with postgre database.

while installation itself, it's failing. I didn't yet setup Application server.

Even, I have placed postgre jdbc jar(postgresql-9.4.1207.jre6.jar) file in <postgre_home>/lib directory as well. getting java returned : 1 error in the error log. Is this anything related to java ? i have installed java jdk-8u66.

Thanks,

Rohith

To see attachments, please log in.
Posted: 8 years ago
Posted: 28 Dec 2015 8:20 EST
Gowrishankar Ramasamy (GowrishankarR29)
Citicorp Services India Private Limited

Citicorp Services India Private Limited
IN

Hi Rohith,

          Have you configured any connection pooling ?.

Thanks,

Gowrishankar.

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 31 Dec 2015 3:00 EST
Rohith Jetti (ROHITHJETTI)
Capgemini

Capgemini
IN

Thank you Babu, shankar.

This installation is completed successflly, this was failing due pljava install scripts. i have resolved this now

Thanks,

Rohith

To see attachments, please log in.
Posted: 7 years ago
Posted: 27 Oct 2017 7:45 EDT
Brahmeswara Rao (Brahmesh@)
Skandiabanken
Brahmeswara Rao
Skandiabanken
SE

Hi ,

Is there any guidelines to migrate the oracle to Postgre ?.

Seems,Postgre doesn't support store procedure so we need to convert Store Proc's to functions.

For connect-sql instances(like RDB-Open ,RDB-Save) ,Do we need change the package name for connect-SQL rules ?

How to call the functions which are converted from connect-sql rules.?

Thanks,

Brahmesh.

To see attachments, please log in.

Related content:

Question Solved

org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the

Question

SEVERE: Connection error: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and po

Question Solved

org.postgresql.util.PSQLException: ERROR: function sqlj.get_classpath(character varying) does not exist

Question

SEVERE: Connection error: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Support Doc

org.postgresql.util.PSQLException error when pr_index_operators table size expands significantly

Question Solved

get error Unable to load class: org.postgresql.Driver when installing Pega 8.64

Question Solved

Problem with Pega Platform PE installation - can't connect to PostgreSQL

Question

Has screen capture been fixed for direct feedback in Pega 7.1.9?

Question Solved

PEGA 8.1 Installation with PostgreSQL 9.6 DB

Question Solved

There has been

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice