Hi Experts,

My JDBC Connection is getting hanged … when the connection is idle for more than a hour…

And whenever its down document strucked in queue and a force restart will only solve the problem.

How to clear the queue?

Is it the Database problem or its JDBC Adapter Problem…???

wM 6.5 build 394
JDBC Adapter 6.5

Connection Property

Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName xxxxx
user xxxx
password xxxxx
databaseName xxxx
portNumber xxx
networkProtocol tcp
Other Properties driverType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 25
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 600000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

I using lots of Adapter Services and 2-3 insert notification…

Pls help me out … this BUG…

we are moving to prod…near by… need to solve this…

Thanks

– Shaik

By looking at your connection parameters, I am almost sure that “Minimum Pool Size =1” is causing that problem. What happen is when you set up minimum pool size to one than even there is no connection between IS and database like in case database goes down then IS forcefully tries to keep one pool connection alive which makes the JDBC connection stale. By setting “Minimum Pool Size = 0” would solve that problem.

setting minimum pool size = 0 may fix the hang problem, but it may have very negative impact on the performance (since every time you need to open new connection.
I’d guess you have a firewall between your WM server and DB, and it will timeout the connection over certain period of time.
To avoid it’s timing out, you can create a ping service to run, say, every 5 minutes. this will prevent it timing out. for this case, you can keep the setting minpoolSize =1 (not more than 1, since the ping will only reset one connection).
HTH,
Tong

Thanks for the reply…

But according to my wM Admin team suggestion i removed Connection Pooling also …

But its not affecting it…

Is it some Firewall/Network Issue?

Pls Suggest…

–Shaik

what is your polling frequency ?
If your wM IS and DB are located in two different geographies and your you do polling tooo aggressive( say 10 sec ) if may cause notification to get hang. In past I have faced a couple of issues with polling notification getting hanged because of polling across WAN if network is slow.

what does wM guru recommended in above scenario, lets say there is a network latency between IS and DB and their is a business need to integrate two system in real time (accepted time is 2-3 minutes). Should we use polling notification or batch process ? or let custom application create a flat file , put it the FTP and wM IS do file polling ?

diging further i came across similar cases reported on advantage. wM support recommended to upgarde JVM to later release of 1.4.0.09 for their customer having HP UNIX on their floors. Not sure which jvm you are using. I attaching a consolidated list of similar cases reported to wM. Hope it helps some one.
Polling Notification Issue.doc (39.5 KB)