Skip to Content
Former Member
Oct 20, 2008 at 06:56 AM

problem in XI -> JDBC (oracle) Scenario, case sensitive column name


I had a XI -> JDBC scenario, connecting to a SQL server, where the query was being generated using Message Mapping (XML SQL Format),

now the database has been migrated from SQL server to Oracle, and we are using the same XI scenario, but now the problem is, the query generated using message mapping doesnt work because it seems the query (UPDATE statement) requires the field name as having All capital letters, i mean the Column name in query to Oracle has become case sensitive,

can u help me out