I try to Open an existing JDBC Service (Select, Update) in Developer and it takes an excessively long time to return (20 minutes) or it just hangs the Developer session. The Oracle database is up and the JDBC connection works. If I kill some of my sessions from the IS Admin, then Open JDBC Service returns some of the time. The IS is v6.1. Any idea what’s causing this problem?
Our resident wM infrastructure support determined it was caused by database latency and the following JDBC adapter connection property change has fixed it.
Other Properties driverType=thin;oracle.jdbc.TcpNoDelay=true;restrictGetTables=true;TCP.NODELAY=yes