Azure SQL MI로 Runnable JAR통해 Azure API 호출/파싱 시 간헐적 연결 끊김 발생
Azure SQL MI로 Runnable JAR통해 Azure API 호출/파싱 시 간헐적 연결 끊김 발생합니다.
해당 문제를 해결할 방법을 알 수 있을까요?
MI의 Configure : remote query timeout 설정은 변경해봤지만 동일합니다.
에러로그
com.microsoft.sqlserver.jdbc.SQLServerException: 연결이 닫혔습니다.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1090)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:3195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:958)
at com.sun.proxy.$Proxy0.rollback(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:68)
at com.sun.proxy.$Proxy0.rollback(Unknown Source)
at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.rollback(JdbcTransaction.java:72)
at com.ibatis.sqlmap.engine.transaction.TransactionManager.end(TransactionManager.java:87)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:734)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:176)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:153)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:835)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:410)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:58)
at com.cbms.sqlmap.SqlDAO.insertObject(SqlDAO.java:75)
at com.cbms.util.AzureAPIUtil.azureApiDataInsert(AzureAPIUtil.java:545)
at com.cbms.batch.AzureAPIBillingInfo.getBillingInvoicesTransactions(AzureAPIBillingInfo.java:823)
at com.cbms.batch.AzureAPIBillingInfo.getBillingInvoices(AzureAPIBillingInfo.java:661)
at com.cbms.batch.AzureAPIBillingInfo.getBillingProfiles(AzureAPIBillingInfo.java:333)
at com.cbms.batch.AzureAPIBillingInfo.getBillingAccounts(AzureAPIBillingInfo.java:146)
at com.cbms.batch.AzureAPIBillingInfo.getInitTestBillingInfoData(AzureAPIBillingInfo.java:38)
at com.cbms.batch.AzureAPIBillingInfo.main(AzureAPIBillingInfo.java:26)