Integration: OIM - OIA
Use Case: Import Users/Accounts etc
Exception:
Cause: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
Expected Solution:
Use Case: Import Users/Accounts etc
Exception:
Cause: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
Expected Solution:
- Verify connection parameters in oimjdbc.properties
- Verify password property in iam-context.xml (proper line must be commented out for password)
- Make sure that oimjdbc.properties should not have spaces around "=" for
- oim.jdbc.username
- oim.jdbc.url
- oim.jdbc.driverClassName
- oim.jdbc.password.encrypted