We are facing problems with the JDBC adapter, for unknown reason when the service is running the JDBC Adapter Stuck and block the database table, when other PC request the same information a timeout happens.
The only way to fix the issue is restarting the Integration Server and I know that this is not a good solution.
We are using IS 6.0.1 and the JDBC Adapter is 6.0.3
We are connecting into Oracle 9i database.
Any of you are facing the same problem? What do you do to fix the issue?