Package org.frankframework.util

Class DB2XMLWriter

java.lang.Object

org.frankframework.util.DB2XMLWriter

public class DB2XMLWriter
extends Object

Transforms a java.sql.Resultset to a XML stream. Example of a result:

 <result>
        <fielddefinition>
                <field name="FIELDNAME"
                          type="columnType"
                          columnDisplaySize=""
                          precision=""
                          scale=""
                          isCurrency=""
                          columnTypeName=""
                          columnClassName=""/>
                 <field ...../>
        </fielddefinition>
        <rowset>
                <row number="1">
                        <field name="FIELDNAME">value</field>
                        <field name="FIELDNAME" null="true" ></field>
                        <field name="FIELDNAME">value</field>
                        <field name="FIELDNAME">value</field>
                </row>
        </rowset>
</result>

Note: that the fieldname and columntype are always capital case!

Author:

Johan Verrips

Field Summary

Fields

Modifier and Type	Field	Description
protected static org.apache.logging.log4j.Logger	log

Constructor Summary

Constructors

Constructor	Description
DB2XMLWriter()

Method Summary

Modifier and Type	Method	Description
static void	addFieldDefinitions(SaxElementBuilder root, ResultSetMetaData rsmeta)
String	getBlobCharset()
static String	getFieldType(int type)
String	getNullValue()	Get the presentation of a Null value
static String	getRowXml(IDbmsSupport dbmsSupport, ResultSet rs, int rowNumber, ResultSetMetaData rsmeta, String blobCharset, boolean decompressBlobs, String nullValue, boolean trimSpaces, boolean getBlobSmart)
static void	getRowXml(SaxElementBuilder rows, IDbmsSupport dbmsSupport, ResultSet rs, int rowNumber, ResultSetMetaData rsmeta, String blobCharset, boolean decompressBlobs, String nullValue, boolean trimSpaces, boolean getBlobSmart)
String	getXML(IDbmsSupport dbmsSupport, CallableStatement callableStatement, boolean alsoGetResultSets, Map<Integer,Parameter> outputParameters, int maxRows, boolean includeFieldDefinition)
void	getXML(IDbmsSupport dbmsSupport, CallableStatement callableStatement, boolean alsoGetResultSets, Map<Integer,Parameter> outputParameters, int maxRows, boolean includeFieldDefinition, ContentHandler handler, boolean prettyPrint)
String	getXML(IDbmsSupport dbmsSupport, ResultSet rs)	Retrieve the Resultset as a well-formed XML string
String	getXML(IDbmsSupport dbmsSupport, ResultSet rs, int maxRows)	Retrieve the Resultset as a well-formed XML string
String	getXML(IDbmsSupport dbmsSupport, ResultSet rs, int maxRows, boolean includeFieldDefinition)
void	getXML(IDbmsSupport dbmsSupport, ResultSet rs, int maxRows, boolean includeFieldDefinition, ContentHandler handler, boolean prettyPrint)
boolean	isDecompressBlobs()
boolean	isGetBlobSmart()
boolean	isTrimSpaces()
void	setBlobCharset(String string)
void	setDecompressBlobs(boolean b)
void	setDocumentName(String s)
void	setGetBlobSmart(boolean b)
void	setNullValue(String s)	Set the presentation of a Null value
void	setRecordName(String s)
void	setTrimSpaces(boolean b)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

log

protected static org.apache.logging.log4j.Logger log

Constructor Details

DB2XMLWriter

public DB2XMLWriter()

Method Details

getFieldType

public static String getFieldType(int type)

getXML

public String getXML(@Nonnull
 IDbmsSupport dbmsSupport,
 @Nullable
 ResultSet rs)

Retrieve the Resultset as a well-formed XML string

getXML

public String getXML(@Nonnull
 IDbmsSupport dbmsSupport,
 @Nullable
 ResultSet rs,
 int maxRows)

Retrieve the Resultset as a well-formed XML string

getXML

public String getXML(@Nonnull
 IDbmsSupport dbmsSupport,
 @Nullable
 ResultSet rs,
 int maxRows,
 boolean includeFieldDefinition)

getXML

public void getXML(@Nonnull
 IDbmsSupport dbmsSupport,
 @Nullable
 ResultSet rs,
 int maxRows,
 boolean includeFieldDefinition,
 ContentHandler handler,
 boolean prettyPrint)
            throws SAXException

Throws:

SAXException

getXML

public String getXML(@Nonnull
 IDbmsSupport dbmsSupport,
 @Nonnull
 CallableStatement callableStatement,
 boolean alsoGetResultSets,
 @Nonnull
 Map<Integer,Parameter> outputParameters,
 int maxRows,
 boolean includeFieldDefinition)

getXML

public void getXML(@Nonnull
 IDbmsSupport dbmsSupport,
 @Nonnull
 CallableStatement callableStatement,
 boolean alsoGetResultSets,
 @Nonnull
 Map<Integer,Parameter> outputParameters,
 int maxRows,
 boolean includeFieldDefinition,
 @Nonnull
 ContentHandler handler,
 boolean prettyPrint)
            throws SAXException

Throws:

SAXException

addFieldDefinitions

public static void addFieldDefinitions(SaxElementBuilder root,
 ResultSetMetaData rsmeta)
                                throws SAXException,
SQLException

Throws:

SAXException

SQLException

getRowXml

public static String getRowXml(IDbmsSupport dbmsSupport,
 ResultSet rs,
 int rowNumber,
 ResultSetMetaData rsmeta,
 String blobCharset,
 boolean decompressBlobs,
 String nullValue,
 boolean trimSpaces,
 boolean getBlobSmart)
                        throws SenderException,
SQLException,
SAXException

Throws:

SenderException

SQLException

SAXException

getRowXml

public static void getRowXml(SaxElementBuilder rows,
 IDbmsSupport dbmsSupport,
 ResultSet rs,
 int rowNumber,
 ResultSetMetaData rsmeta,
 String blobCharset,
 boolean decompressBlobs,
 String nullValue,
 boolean trimSpaces,
 boolean getBlobSmart)
                      throws SenderException,
SQLException,
SAXException

Throws:

SenderException

SQLException

SAXException

setDocumentName

public void setDocumentName(String s)

setRecordName

public void setRecordName(String s)

setNullValue

public void setNullValue(String s)

Set the presentation of a Null value

getNullValue

public String getNullValue()

Get the presentation of a Null value

setTrimSpaces

public void setTrimSpaces(boolean b)

isTrimSpaces

public boolean isTrimSpaces()

setDecompressBlobs

public void setDecompressBlobs(boolean b)

isDecompressBlobs

public boolean isDecompressBlobs()

setGetBlobSmart

public void setGetBlobSmart(boolean b)

isGetBlobSmart

public boolean isGetBlobSmart()

getBlobCharset

public String getBlobCharset()

setBlobCharset

public void setBlobCharset(String string)