Jaffa's Data Types

Home Contact Us FAQs Site Map

Source Forge:

Jaffa Site
news introduction documentation javadocs downloads contributors acknowledgements mail lists legal

Jaffa Runtime
TagLib Guide Presentation Middleware Business Logic Persistence Security Configuration

Jaffa RAD
Getting Started Standards Build Tools Generation Engine Domain Generation Component Generation Application Generation Load Testing

Sub-Projects
SampleApp Together TextPad

Business Logic / Datatypes

org.jaffa.datatypes

We have come up with a concise set of datatypes as listed in the table below. The table also lists the corresponding SQL Datatype and the Java class for a logical datatype

You may not agree these, but when building a business application, i greatly simplyfies the process, and the reason Jaffa is open source is so you can extend this list if you want

Jaffa Prefered Data Types

Jaffa Logical Datatype	SQL Datatype	Java class
org.jaffa.datatypes.Defaults.BOOLEAN	java.sql.Types.VARCHAR	java.lang.Boolean
org.jaffa.datatypes.Defaults.STRING	java.sql.Types.VARCHAR	java.lang.String
org.jaffa.datatypes.Defaults.INTEGER	java.sql.Types.BIGINT	java.lang.Long
org.jaffa.datatypes.Defaults.DECIMAL	java.sql.Types.DOUBLE	java.lang.Double
org.jaffa.datatypes.Defaults.DATEONLY	java.sql.Types.DATE	Org.jaffa.datatypes.DateOnly
org.jaffa.datatypes.Defaults.DATETIME	java.sql.Types.TIMESTAMP	Org.jaffa.datatypes.DateTime
org.jaffa.datatypes.Defaults.CURRENCY	java.sql.Types.DOUBLE	Org.jaffa.datatypes.Currency
org.jaffa.datatypes.Defaults.RAW	java.sql.Types.VARBINARY	byte[]
org.jaffa.datatypes.Defaults.LONG_STRING	java.sql.Types.LONGVARCHAR	java.lang.String
org.jaffa.datatypes.Defaults.LONG_RAW	java.sql.Types.LONGVARBINARY	byte[]
org.jaffa.datatypes.Defaults.CLOB	java.sql.Types.CLOB	java.lang.String
org.jaffa.datatypes.Defaults.BLOB	java.sql.Types.BLOB	byte[]

Notes:

It is recommended to use instances of the listed Java classes inside Data Transfer Objects (DTOs) for transferring data between the different layers of the architecture
The Jaffa Logical Datatypes are specified in the mapping files used by the Persistence Engine, which then uses the appropriate SQL datatype to load/store instances of the corresponding Java class
We’ve created a couple of custom classes for wrapping date fields, adding the much needed arithmetic and logical functionality, without sacrificing the immutability of a datatype
The Boolean datatype is assumed to be a CHAR(1) in the database having the values T/F. This will be enhanced in a future release to support the BIT field and Y/N values
The class org.jaffa.datatypes.Defaults has helper methods to get the Java class for a Jaffa Logical Datatype and vice versa
The class org.jaffa.persistence.engines.jdbcengine.querygenerator.TypeDefs has a helper method to return the SQL Datatype for a given Jaffa Logical Datatype