Retrieving XML thru Java Programs- the formatting problems

[nayudusrini]

Hi,

I am trying to retrieve XML from SQL server 2000 Database with AUTO XML, the output produced is having some typical problems.

1. The resultant XML document is not returned as a single row, but as number of rows, with each row of size of 2033 bytes. Though it was fine with me,the real problem is,it is randomly removing or adding the spaces between elements, which makes it a invalid XML document.

Example: <EmployeesEmployeeID=&quot;4&quot;

here it should be <Employees EmployeeID=&quot;4&quot;. but it occuring randomly.

the problem is, it is even splitting single word and giving it in two different rows when that row size exceeds 2033 bytes. so we can't explicitly insert spaces into it.

I ran many example Queries given in SQL server Help and online documentation, but still I am facing the same problem.

I would greatly appreciate if anybody can answer this.

(This is for an application, not just for educational purpose).

Thanks a lot.

Srini