Batch Insert JDBC service is getting hanged

Hi All,

I have a batch insert JDBC adapter service, when I am calling the sevice from a flow its getting hanged. Volume of record is substantially low (1 to 40 records). I tried to disable the adapter connection but again it hanged too. Even am not able to relaod the package. I don’t see anything wrong in the server log apart from connected to database with Local_Transaction. Now if I call another adapter service (select) using same connection its getting hanged too.
I am using explicit transactions but couldn’t able to identify the real cause of this problem.
Server details are : IS 6.1 ,JDBC adapter ver 6.0.3 and database Oracle 9

Please let me know your thoughts.


Could you provide the adapter connection parameters. Also check if database is running fine by using third party tool.

The Database is up and running. Here are the parameters.

Connection Type- JDBC Adapter Connection
DataSource Class- oracle.jdbc.pool.OracleDataSource
networkProtocol -
Other Properties- driverType=thin

Enable Connection Pooling- true
Minimum Pool Size- 0
Maximum Pool Size- 10
Pool Increment Size- 1
Block Timeout (msec)- 1000
Expire Timeout (msec)- 1000
Startup Retry Count- 0
Startup Backoff Timeout (sec)- 10