Question
Cognitonic Systems
AU
Last activity: 9 Nov 2022 10:48 EST
SQL Query Runner
while trying to execute a query in query runner , configuration map error is displayed
how to fix this issue
NCS Pte. Ltd
SG
HI @KrishnaMohanK2527: Have you looked into the below? Does this helps?
Thanks
Cognitonic Systems
AU
Pegasystems Inc.
IN
Cognitonic Systems
AU
@SrinidhiM Personal edition 8.7
Updated: 4 Nov 2022 9:56 EDT
Pegasystems Inc.
GB
@KrishnaMohanK2527 please see the following 7.3.1 Personal Edition Database Access and JDBC URL and the following Query Runner help in Pega Infinity Personal Edition post.
I also found this external article DB configuration for Pega Personal Edition 8
You could also consider using the Community Edition instead, which is the software we recommend.
Accepted Solution
Updated: 9 Nov 2022 10:48 EST
Cognitonic Systems
AU
For personal Edition ,working after making below changes:
add below in context.xml file:
<Resource name="jdbc/PegaRULESReadOnly" auth="Container" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" type="javax.sql.DataSource" maxActive="100" maxIdle="10" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/postgres" username="postgres" password="postgres"/> * url, username, password should be of your postgres details.
add below in prconfig.xml file:
<env name="database/databases/PegaRULES/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly" /> <env name="database/databases/PegaDATA/dataSourceReadOnly" value="java:comp/env/jdbc/PegaRULESReadOnly" />