I was able to generate a SQL Map Broker in Integrator 3.4.1 using a JDBC channel to a Synchrony Database database “test”, table “item”, user “synchrony”. However, I was not able to use execute the same SQL Map Broker in an integration task. The error encountered in Integrator trace or message log is the following:
ERROR 20090504 18.37.04.74 procengine(procengine(hierchmsgenv))
[MON - 1040]: Unable to open Channel (Company.composer.JDBC)
ERROR 20090504 18.37.04.74 procengine(procengine(hierchmsgenv))
[JDX - 17010]: Connection failed for Channel (Company.composer.JDBC). Driver=(com.mysql.jdbc.Driver), Url=(jdbc:mysql://synplatform:3306/test?jdbcCompliantTruncation=false), User=****, Password=****
Does anyone know why and how to fix this problem?
