Skip to Content
0
Former Member
Jan 20, 2011 at 04:42 PM

JDBC - XML SQL format. Insert into SQL table when column names contain '@'

473 Views

Hi.

I need to generate a SQL insert statement using XML SQL format.

However, The column names of the target table are:

M5LITM

M5MMCU

M5@FDT

M5@QOP

M5UOM

M5@SRC

M5DCTO

I cannot define a Data Type Element names containing '@', because special characters are not permitted:

The value "M5@FDT" is not permitted for the attribute "name" of the "NCName" type in the "/schema/complexType("DT_xxxxx")/sequence/element("M5@FDT")" element

Any ideas on how I can do this?

Thanks in advance.