Leading Blanks - JDBC Receiver

[Former Member]

Hello all,

we have a strange behaviour when readin gdata out of a database!

We use a jdbc-receiver adapter to select values of different tables (usage of a multiselect-structure) .

Now we have found out that leading blanks of varchar fields in the database tables (inserted by business people to format content) cannot be found in the response of the select statement.

we are on XI3.0 SPS 20

database is Orcale 10g

oracle driver 10.2.0.2

thanx i nadvance

jo

[justin_santhanam · Accepted solution]

Jo,

R u seeing the data in SXI_Monitor? You won't see the data with spaces in XML, the spaces are not visible. I faced the same issue, try to write the data into some file, there u will see the spaces. What u want to do after fetching the data from DB?

raj.