Place of defining Schema Name
Hi All,
I have an issue one connecting the external db. We connect external DB in PEGA. We declare JNDI connection string in JBoss server. It is fine without/with putting schema as dbo in our development environment. But when we move to another environment like SIT, without having schema info "Test Connection" failed. Refer to db_error.PNG and db_error_2.PNG as attached. (removed sensitive info)
Kindly guide me in which attributes or configuration made mandatory as schema field.
Thanks and Best Regards,
Aung
Accepted Solution
PEG
GB
I believe, if the user credentials supplied for the database has a default schema then it will use that. If the user doesn't have a default schema then you'll need to enter one.
But unless I'm mistaken you'll need to save the rule before using the Test Connection button.
Pegasystems Inc.
US
Looks like either your table is not created in database or the class (that is mapped to the table) does not exist. The error stack in the log should indicate the details.
Accenture
AU
Hi KevinZheng,
The table exists because if i dont put dbo in the schema field, I could not connect and if I put the dbo in the schmea field it works fine. But in another environment it does not matter, whether dbo is put under schema field or not.
May I know where can be the different configuration. and where can I check error stack that you mentioned?
Thanks and Best Regards,
Aung
Accepted Solution
PEG
GB
I believe, if the user credentials supplied for the database has a default schema then it will use that. If the user doesn't have a default schema then you'll need to enter one.
But unless I'm mistaken you'll need to save the rule before using the Test Connection button.