Loading
ただいま大変多くのお問い合わせをいただいており、ご連絡までにお時間を頂戴しております続きを読む

Database connector: Oracle stored procedure calls silently dropping connections after 8 minutes post CloudHub 2.0 migration.

公開日: Apr 30, 2026
説明

After migrating to CloudHub 2.0, an issue has been observed where stored procedure calls to a backend Oracle database—invoked through the Database connector and JDBC driver—unexpectedly terminate after approximately eight minutes. Notably, these terminations occur without any corresponding error logs, making troubleshooting particularly challenging.

The root cause of this behavior lies at the network layer and is specific to the CloudHub 2.0 infrastructure. During long-running stored procedure executions, the TCP connection can remain idle for extended periods. In such cases, an intermediate network component—such as a load balancer, NAT gateway, or firewall—may silently drop the connection after around eight minutes of inactivity. This results in the abrupt termination of the database call without any application-level error reporting.

 

解決策

1. If using the Oracle connection, pass the required property through Runtime Manager to maintain the TCP connection. Set the JVM argument 'oracle.net.keepAlive=true' in the Mule Runtime to prevent idle timeouts. 

2. Use a Generic connection in the Database Connector and configure the URL with the keepAlive property. For example: jdbc:oracle:thin:@//cloud-services.demos.mulesoft.com:32173/XEPDB1?oracle.net.keepAlive=true. 

ナレッジ記事番号

005321536

 
読み込み中
Salesforce Help | Article