Error in is while executing process model

,
1

HI ALL,

aM USING mW7.1.1

2009-07-28 16:53:27 IST [ISP.0090.0003C] This is small order
2009-07-28 16:53:28 IST [ISP.0090.0003C] This is small order
2009-07-28 17:12:53 IST [CommonLib.MWS.0002W] DB Server disconnected. Will try to reconnect
2009-07-28 17:12:53 IST [CommonLib.MWS.0001W] [wm-cjdbc36-0007][Oracle JDBC Driver]No more data available to read.
2009-07-28 17:13:12 IST [LGU.0002.0016C] Error releasing cluster lock: Exception encountered trying to release excusive lock for target(WmLogUtil043901ab-84c7-4703-9808-c2837d1f3e5c), exception(java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver]Connection reset by peer: socket write error)
2009-07-28 17:14:02 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc36-0007][Oracle JDBC Driver]Connection reset by peer: socket write error

REGARDS,
ANIL KUMAR ELLENDULA

2

Hi Anil,

There are several things that you can check:

1- Check the db connection whether db is bounce or not.
2- Optimize the JDBC connection pool settings according to the volume of data you are trying to fetch.
3- If data volume is too large then try to fetch it in chunks.

Regards,

Arsalan.

3

my db connection is fine and jdbc connection pool setting is good.

how to Optimize the JDBC connection pool settings according to the volume of data you are trying to fetch.
If my data volume is too large then how to fetch it in chunks.

please reply me above answers to me.