-
Bug
-
Resolution: Done
-
Blocker
-
fuse-7.6-GA
-
%
-
fuse-7.7-build2
Some SQL connector exceptions are shown only in DEBUG mode like the following exceptions:
- SQLErrorCodeSQLExceptionTranslator
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
The integration pod shows a SUCCESS in the activity and the no ERROR in the log, we should turn the integration pods to DEBUG, to understand the root cause.
e.g;
2020-04-09 09:32:21.853 DEBUG 1 --- [ XNIO-3 task-1] s.j.s.SQLErrorCodeSQLExceptionTranslator : Translating SQLException with SQL state '23000', error code '1062', message [Duplicate entry '150' for key 'PRIMARY']; SQL was [] for task [PreparedStatementCallback] 2020-04-09 09:01:03.062 DEBUG 1 --- [ XNIO-3 task-1] org.apache.camel.processor.Pipeline : Message exchange has failed: so breaking out of pipeline for exchange: Exchange[i-M4T9wxMDE_2GTdPVnekz] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'debezium'@'10.128.2.31' for table 'products'
