Java Exception on saving DB table rule (Rule-Admin-DB-table)
We have made a connection to external database. However, when trying to save the DB table rule to map class mapping, when no schema name is given, the rule saves just fine. However, when i give schema name, system is throwing me java exception. Has one faced this issue and able to resolve this?
Appreciate all the help.
***Edited by Moderator Marissa to update platform capability tags****
Thanks for the resonse. Yes. Connectivity and everything else works fine as long as you don't specify the schema name. DB table instance is failing to save only when the schema name is specified. The exception is being thrown out of 'CheckForWarnings' activity from 'Data-Admin-DB-Table' class.
check the DB connection. means the database connectivity . Sysadmin -> database. open the db & try to test. you change the drop down to use jdbc connection pool & provide the JNDI name like java:/jdbc/<dbname>
DB connection works great. I am talking about DB Table (Sysadmin-database table) where we map classes to tables. There, if I don't specify the schema name, the rule saves fine (again, I am not talking about connectivity here). If I mention the schema name and save the rule, I am seeing an exception from activity - CheckForWarnings.