Calling A Stored Procedure In Java With A Blob Field | franzone.com

Calling A Stored Procedure In Java With A Blob Field
Author : Jonathan Franzone
No Comments

Here is the situation. You are writing a program in Java. You need to access data in a Microsoft SQL Server via stored procedure and the data has an XML field. A what field? SQL Server 2005 introduces a new datatype for XML. It is essentially a blob field that you can perform XML operations on. For the Java program though, it doesn’t really care about that functionality and can just access it to write it out to a file (or process it inline).