Hi All,
I have a table in which Through java program I am creating xml from the database.The data in the Database getting inserted from xls sheet.The xls sheet data is present in this manner:

"
If source_id = SR3 then RETAIL
Else If geo_cd = a then SVC
V then SVC
S then SVC
x then SVC
j then SVC
p then SVC
F then SVC
G then SVC
H then SVC
Else If ISERVICES_FLAG of the first item = J then ITMS
F then ISVC
G then ISVC
Else Check if any of the order_item has qwq = N
If items found with qwq = N then
MISC
Else
WEBSTR"


As we are putting data from xls to Database so in database after select query we are getting data for bizlogic like:




Through java prog we are generating xml from the database.
Our code is like below:
ResultSet result2=st2.executeQuery("select bizlogic from popup_bizlogic where id='"+value+"'");
sb.append("<businesslogic>\n");
while(result2.next())
{
String bizlogic=result2.getString("bizlogic");
sb.append("<bizlogicval>"+ bizlogic+"</bizlogicval>\n");
}

So the xml generated like below:

<bizlogicval>If source_id = SR3 then RETAIL
Else If geo_cd = a then SVC
V then SVC
S then SVC
x then SVC
j then SVC
p then SVC
F then SVC
G then SVC
H then SVC
Else If ISERVICES_FLAG of the first item = J then ITMS
F then ISVC
G then ISVC
Else Check if any of the order_item has applestore_flag = N
If items found with applestore_flag = N then
MISC
Else
WEBSTR</bizlogicval>

Here plz notice data in xml is coming as present in xls sheet.But while displaying the xml in the UI it is not showing line break.

In the UI it is showing:

If source_id = SR3 then RETAIL Else If geo_cd = a then SVC V then SVC S then SVC x then SVC j then SVC p then SVC F then SVC G then SVC H then SVC Else If ISERVICES_FLAG of the first item = J then ITMS F then ISVC G then ISVC Else Check if any of the order_item has applestore_flag = N If items found with applestore_flag = N then MISC Else WEBSTR


But I want to show it in the UI as present in xls sheet.Can it possible to put a line break forcible in the xml generated so that in the UI it will come as in xls sheet.

Pr2184.