Issue with JDBC connection after DB restores its state

shriraksha · April 10, 2012, 2:36pm

Hi All,

Does anyone faced issue with JDBC adapter services not working after DB restores? Currently, it is requiring to refresh the JDBC connection after DB comes up for properly executing adapter services. It is happening with WM8 version.

Regards,
Shriraksha A N

Samuel_Tobias · April 14, 2012, 12:19am

Did you go into the JDBC Connections from the IS to ensure your path is the same? The DB server/'s must be listed in there for you connection to work.

Akshith_Arremreddy · April 16, 2012, 7:31pm

Yup, I have been seeing this issue from JDBC Adapter 6.1 till now and for some reason i still can not find one standard solution for this. Different things worked for me at different client implementations.

Things that i have tried in past and helped me in resolving the issue.

Reload the JDBC connection.
Enable and disable the connection.
Create a service which will get all the list of JDBC connections and reload them. Add this service to the WmJDBCAdapter package startup services.
Restart the IS (If your repository is a database).
Make sure the minimum connection pool setting on the JDBC Connection is set to 0.
Work with the database team to run the sql profiler (or any other debugging tool) and see what exactly is happening between the calls.

Cheers,
Akshith

Samuel_Tobias · May 8, 2012, 11:56pm

I question if the JDBC Adapter>Connections is a true reflection of the connectivity to the DB. I’m thinking what it’s saying is if a connection is there, connect to it. Not an actual statue of the connection. We are working through some of that now with poor results.

reamon · May 9, 2012, 1:24am

That page is the configuration, not the status. That page defines the parameters used to make connections and the size/configuration of the connection pool.

The run-time status of a pool and the connections is not available with out-of-the-box Administrator pages (unless 8.x has added something–someone chime in with info if it has).

Akshith_Arremreddy · May 9, 2012, 6:03pm

I have an IS 8.x but it still uses JDBC Adapter 6.5 and I do not see any changes in the Connection settings page that will provide a run-time status of a pool.