Batch Insert JDBC service is getting hanged

, ,
1

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.

Thanks,
Joy

2

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

3

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

Connection Type- JDBC Adapter Connection
Transaction Type- LOCAL_TRANSACTION
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

Thanks,
Joy