JDBC Gateway connection failed
@Vicky Li
@Thanongsak Chamung
@Warlin Garcia
@Eduard Lebedyuk
@Enrico Parisi
@Luis Angel Pérez Ramos
We are getting this error. All the drivers, URL and credential are tested and existed. it works fine sometime but also getting this error more often. Please advise the root cause and its respective solution. The business service that is using out of the box Java service (classname: EnsLib.JavaGateway.Service adapter classname: EnsLib.JavaGateway.ServiceAdapter) is throwing this error.
The configured "SOMEDSN" has passed the JDBC Connection test successfully with the external database (ORACLE)
Type: Error
Text: Error initializing result update service. tSC=ERROR #JDBC Gateway connection failed for "SOMEDSN": Unknown status code: <UserErrors>JDBC Gateway connection failed for "SOMEDSN)
Session: (none)
Job: 27421
$$^zProcessInput+12 ^Ens.BusinessService.1 +1
$$^zOnTask+1^Ens.
$$^zOnTask+29^Ens.
DO^zStart+62^Ens.Job.1 +2
Comments
Do you have Stay Connected setting equal to -1? Try setting it to a lower value, i.e. 30.
@Eduard Lebedyuk do you think this would the cause of this error? What i am thinking is the DB connection open and Close is not in sync. It tries to open the DB connection while it is not closed properly or not even closed.
Is there a way i can check the connection is open or not before initiating/opening it again or establishing the connection with an external DB?.
Longrunning tcp connections might be an issue. I would definitely try setting it to something lower.