I am facing a problem when my BPEL applications tried to connect to the database. I m using OC4j Server. I m using ver 10.1.3.4.
Error: BPEL JCA Listener was unable prepare delivery of inbound message to BPEL Process 'bpel://localhost/Pactor/MsgHandler~1.35/' due to: Cannot fetch a dat
asource connection.
The process domain was unable to establish a connection with the datasource with the connection URL "jdbc/BPELServerDataSource". The exception reported is:
Unable to get a physical connection from the database...there are no connections available.
Please check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (use
r/password) is currently valid.
The database connection is full during load on BPEL application and i m using the below timeout properties properties.
Timeouts
Inactivity Timeout (seconds) : 120
Wait For Used Connection Timeout (seconds) : 0
Max Active Time for a Used Connection (seconds) :0
Abandoned Connection Timeout (seconds) : 900
the below forum says not to use Abandoned Connection Timeout. Please let me know where its good to use with my problem or I should not use it?
714665