When the SQL sink kamelets (tried with mariadb and sqlserver) are used in a KameletBinding with InMemoryChannel source, the port property is set to 8080 on the sink, which causes database connections to fail.
Specifiyng the port explicitely does not help either.
What did help was editing the kamelet itself and changing the name of the property to e.g. mariadbPort. Seems like the kamelet is picking up a property set by something else in the route.
Here's the errors:
Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=mariadb-tnb)(port=8080)(type=master) : Socket fail to connect to host:mariadb-tnb, port:8080. No route to host (Host unreachable)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host mssql-tnb, port 8080 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".