JDBC send data to oracle, oracle only accept column name in Upper case

[Former Member]

Hi experts,

I am doing a scenario File --> XI --> JDBC, JDBC send data to a Oracle 10g database, I have configured JDBC receiver to use XML-SQL format. in oracle database , table "EMPLOYEE" has a column "NAME", but when I send data to oracle using JDBC receiver, the column is "name", then XI complains

" 'EMPLOYEE' (structure 'insert'): java.sql.SQLException: FATAL ERROR: Column 'name' does not exist in table 'EMPLOYEE'.

can anyone help me to let oracle accpet column "name". I can't change colum in JDBC receiver from "name" to "NAME".

Thanks a lot.

[bhavesh_kantilal]

Hi,

The best way to check how Xi is creatuing the Query is to use the LogSQLStatement.

In the receiver JDBC adapter, select table and in the table add the variable LogSQLStatement with value True.

This is explained in note : 801367

Regards

Bhavesh

[prateek]

<i>can anyone help me to let oracle accpet column "name"</i>

Making Oracle case insensitive is not possible (in my opinion). By default all object names are stored in UPPER case in the rdbms dictionary.

When XI searches for column name in Oracle, this search is case sensitive. So u have to configure accordingly.

Regards,

Prateek