Why can enable Oracle JDBC Adapter Connection NO_TRANSACTION

, ,
1

We create a JDBC Adapter Connection(JDBC:Test) with NO_TRANSACTION connect to Oracle database enable well.
But it can not enable if we change NO_TRANSACTION to LOCAL_TRANSACTION.
All of other LOCAL_TRANSACTION connection can enable except this connection.
We got below message when enable the connection:

[ART.118.5063] Adapter Runtime (Connection): Unable to start connection JDBC:Test: after 2 attempt(s).
[ADA.1.208] Cannot disconnect from the database. "
(17002) Io exception: Connection timed out"
Io exception: Connection timed out

Would anyone tell me why ?

2

Hi Jordan,

can you please provide a bit more informations about your IS/JDBC Adapter version and the Oracle database and driver version?

Please provide some more informations about the connection(s), so we can try to detect some configuration mistakes.

Does deleting and re-creating the connection solve the issue?

Regards,
Holger

3

Dear Holger,

We had solve it due to our network issue.
Thank you for response.