[Exception] interface No.: DM02; error code: ERR_EAI_02_014; error Description: cocould not roll back JDBC transaction; nested exception isjava. SQL. SQLException: unable to read more data from the socket; nested exception is org. springframework. transaction. transactionSystemException: cocould not roll back JDBC transaction; nested exception isjava. SQL. SQLException: unable to read more data from the socket: stack information: com. szp. eai. exception. SZPEAIException: exception cocould not roll back JDBC transaction when saving the work order to the intermediate database; nested exception isjava. SQL. SQLException: unable to read more data from the socket; nested exception isorg. springframework. transaction. transactionSystemException: cocould not roll backJDBC transaction; nested exception is java. SQL. SQLException: unable to read more data from the socket
This interface fails to connect to the database because the target database is RAC. The configuration of this interface is as follows:
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.33.241) (PORT = 1521 )))
(CONNECT_DATA =
(SERVICE_NAME = orcl11)
))
It should be changed:
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.33.241) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.33.239) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.33.240) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl11)
))