tags:

views:

18

answers:

0

I'm using XMLInputFactory to read data (sql query's) from xml file.

In some cases, the data is truncated. For example:

select CASE WHEN count(*) > 0 THEN 'LX1VQMSSRV069 OK' ELSE 'LX1VQMSSRV069 NOK' END from [PIWSLog].[dbo].[log]

is read as (text is truncated after the last '.'):

select CASE WHEN count(*) > 0 THEN 'LX1VQMSSRV069 OK' ELSE 'LX1VQMSSRV069 NOK' END from [PIWSLog].[dbo]

I've tested with several string and it seems that the problem is with the char's in [].[].[]..

I'm readind data using:

mySQLquery = event.asCharacters().getData();

Another situation is if the string has '\n'. Like, if it has two '\n', the event.asCharacters().getData(); reads correctly, but if it has three '\n' it truncates the string after the second '\n'. This is very odd!

Any idea what's the problem and how can I solve it?

Thanks