Question
Estes Forwarding Worldwide
US
Last activity: 23 Mar 2023 14:47 EDT
How to Find DB Information
How do I find all database information for the DB my application is connected to?
I know the database, table and column that need to be updated, but I require more information, such as schema, in order to inform our DB team how to perform the update.
I've tried tools such as the query runner to find more information, but can't find anything. Looks like a permissions issue:
Accepted Solution
Estes Forwarding Worldwide
US
@DevinD16607791I had to contact the JBoss engineers in order to obtain the DB information.
Lventur
IN
Please try to use Pega API's to get some additional information about database/class. Attached screenshot for reference.
Updated: 22 Mar 2023 10:10 EDT
Pegasystems Inc.
US
Three things are necessary to enable query runner:
1) Additional datasource (whether it sits in context.xml or prweb.xml is irrelevant) – jndi name can be something like: jdbc/PegaRULESReadOnly
2) Addition of two new prconfig entries (which can be implemented directly in prconfig.xml, or as Dynamic System Settings, or as jvm runtime settings. database/databases/PegaRULES/datasourceReadOnly database/databases/PegaDATA/datasourceReadOnly (Value of these settings to match the jndi name created in prior step)
3) For PRPC users to be able to see the Query Runner landing page, need to update their Access Group record to include the role “PegaRULES:DatabaseAdministrator”
Accepted Solution
Estes Forwarding Worldwide
US
@DevinD16607791I had to contact the JBoss engineers in order to obtain the DB information.