This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Callable statement return xml result Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Callable statement return xml result" Watch "Callable statement return xml result" New topic
Author

Callable statement return xml result

Nagu Spartan
Ranch Hand

Joined: Jan 08, 2010
Posts: 40
Hi

In java, CallableStatement how to get XML formated output from Stored procedure (SQL Server 2005).


Thanks & Regards,
Nagarajan T.
Prabhakar Reddy Bokka
Ranch Hand

Joined: Jul 26, 2005
Posts: 189

Your stored proc will return an object. that is a String or CLOB or BLOB.

From Java, you will take that String(in your case XML as a String), and process it.
It can be CLOB or BLOB also when your XML is too large in size.


SCJP 5, SCWCD 5
Nagu Spartan
Ranch Hand

Joined: Jan 08, 2010
Posts: 40
It takes only 4000 character... if my output from stored procedure is more than 4000 character means, it take 4000 character and remaining is truncated.



Prabhakar Reddy Bokka wrote:Your stored proc will return an object. that is a String or CLOB or BLOB.

From Java, you will take that String(in your case XML as a String), and process it.
It can be CLOB or BLOB also when your XML is too large in size.

Prabhakar Reddy Bokka
Ranch Hand

Joined: Jul 26, 2005
Posts: 189

thats where CLOB comes into picture. CLOB do not have any limit.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Callable statement return xml result
 
Similar Threads
Pronounciation of "Buzz Words"
making XML Doc from JDBC Results
Ajax Jqery xml response - not able to read response
Castor Mapping
iText problem with html-table to pdf