nl.nn.adapterframework.util

Class DB2XMLWriter

java.lang.Object

nl.nn.adapterframework.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 and Description
protected static org.apache.logging.log4j.Logger	log

Constructor Summary

Constructors

Constructor and Description
DB2XMLWriter()

Method Summary

Modifier and Type	Method and 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, ResultSet rs) Retrieve the Resultset as a well-formed XML string
String	getXML(IDbmsSupport dbmsSupport, ResultSet rs, int maxlength) Retrieve the Resultset as a well-formed XML string
String	getXML(IDbmsSupport dbmsSupport, ResultSet rs, int maxlength, boolean includeFieldDefinition)
void	getXML(IDbmsSupport dbmsSupport, ResultSet rs, int maxlength, 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 Detail

log

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

Constructor Detail

DB2XMLWriter

public DB2XMLWriter()

Method Detail

getFieldType

public static String getFieldType(int type)

getXML

public String getXML(IDbmsSupport dbmsSupport,
                     ResultSet rs)

Retrieve the Resultset as a well-formed XML string

getXML

public String getXML(IDbmsSupport dbmsSupport,
                     ResultSet rs,
                     int maxlength)

Retrieve the Resultset as a well-formed XML string

getXML

public String getXML(IDbmsSupport dbmsSupport,
                     ResultSet rs,
                     int maxlength,
                     boolean includeFieldDefinition)

getXML

public void getXML(IDbmsSupport dbmsSupport,
                   ResultSet rs,
                   int maxlength,
                   boolean includeFieldDefinition,
                   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)