next up previous contents
Next: About this document ... Up: Full listings of Switches Previous: Switches in MapToJava   Contents

List of xml to Java/SQL mappings

XML Java SQL notes
string java.lang.String varchar (n) n is specified in the len attribute
integer int int -
date java.sql.Timestamp date db uses GMT..
long long number (38,0) -
boolean boolean varchar (1) the 'T'/'F' is stored and retrieved
float float float -
double double double -
longstring java.lang.String clob when a string could be then 4000 characters

note: to create a vector use the following syntax

<field name="children" type="" collection="vector"/>
And for an array use collection=''array'' The type refers to the type of each element and the collection="vector" makes this a vector.