| 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="com.foo.Person" 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.