I have two agents (10G and 11G versions) running in the same machine. The jdbc connection string is working properly on 10G. However, the same connection is not working in 11g.
Made sure that the both agents were using the same drivers but the result is the same. The output I getting from testing the connecting in Topology is this:
"ODI-40522: Exception class java.sql.SQLException occurred saying: data exception: string data, right truncation"