Castor DDL Generator - Type Mapping

License Codehaus OpenEJB OpenJMS OpenORB Tyrex

Old releases

General

Release 1.3

Release 1.3rc1

Release 1.2

Main

Home

About

Features

Download

Dependencies

Reference guide

Publications

JavaDoc

Maven 2 support

Maven 2 archetypes

DTD & Schemas

Recent HTML changes

News Archive

RSS news feed

Project Wiki

Development/Support

Mailing Lists

SVN/JIRA

Contributing

Support

Continuous builds

Prof. services

Related projects

Spring ORM support

Spring XML factories

WS frameworks

XML

XML Code Generator

JDO

Introduction

First steps

Using JDO

JDO Config

Types

JDO Mapping

JDO FAQ

JDO Examples

JDO HOW-TOs

Tips & Tricks

Other Features

JDO sample JAR

Tools

Schema generator

Advanced JDO

Caching

OQL

Trans. & Locks

Design

KeyGen

Long Trans.

Nested Attrs.

Pooling Examples

LOBs

Best practice

DDL Generator

Using DDL Generator

Properties

Ant task

Type Mapping

The Examples

3rd Party Tools

JDO Tests

XML Tests

Configuration

About

License

User stories

Contributors

Marketplace

Status, Todo

Changelog

Library

Contact

Project Name

Castor DDL Generator - Type Mapping

Documentation Author(s):
Ralf Joachim

Type Mapping
JDBC Types not supported by Castor

Type Mapping

This section describes the mapping between Castor sql type java.sql.Types constant, java data type, sql type of supported database.


Castor Type	JDBC Type	Java Object Type	MySQL	PostgreSQL	Oracle	Derby	MSSQL	SapDB	DB2	Sybase	HSQL	PointBase
BIT	BIT	java.lang.Boolean	TINYINT(1)	BOOLEAN	BOOLEAN	CHAR FOR BIT DATA	BIT	BOOLEAN		BIT	BIT	BOOLEAN
TINYINT	TINYINT	java.lang.Byte	TINYINT	SMALLINT	SMALLINT	SMALLINT	TINYINT	SMALLINT	SMALLINT	TINYINT	TINYINT	SMALLINT
SMALLINT	SMALLINT	java.lang.Short	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT
INTEGER	INTEGER	java.lang.Integer	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER
BIGINT	BIGINT	java.lang.Long	BIGINT	BIGINT	NUMERIC	BIGINT	BIGINT	INTEGER	BIGINT	INTEGER	BIGINT	NUMERIC
FLOAT	FLOAT	java.lang.Double	FLOAT	DOUBLE PRECISION	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT
DOUBLE	DOUBLE	java.lang.Double	DOUBLE	DOUBLE PRECISION	DOUBLE PRECISION	DOUBLE	DOUBLE PRECISION	DOUBLE PRECISION	DOUBLE	DOUBLE PRECISION	DOUBLE PRECISION	DOUBLE PRECISION
REAL	REAL	java.lang.Float	REAL	REAL	REAL	REAL	REAL	DOUBLE PRECISION	REAL	REAL	REAL	REAL
NUMERIC	NUMERIC	java.math.BigDecimal	NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC
DECIMAL	DECIMAL	java.math.BigDecimal	DECIMAL	NUMERIC	DECIMAL	DECIMAL	DECIMAL	DECIMAL	DECIMAL	DECIMAL	DECIMAL	DECIMAL
CHAR	CHAR	java.lang.String	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR	CHAR
VARCHAR	VARCHAR	java.lang.String	VARCHAR	VARCHAR	VARCHAR2	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR
DATE	DATE	java.sql.Date	DATE	DATE	DATE	DATE	DATETIME	DATE	DATE	DATETIME	DATE	DATE
TIME	TIME	java.sql.Time	TIME	TIME	DATE	TIME	DATETIME	TIME	TIME	DATETIME	TIME	TIME
TIMESTAMP	TIMESTAMP	java.sql.Timestamp	TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP
BINARY	BINARY	byte[]	BINARY	BYTEA	RAW	CHAR [n] FOR BIT DATA	BINARY	BLOB	CHAR [n] FOR BIT DATA	BINARY	BINARY	BLOB
VARBINARY	VARBINARY	byte[]	VARBINARY	BYTEA	LONG RAW	VARCHAR [] FOR BIT DATA	VARBINARY	BLOB	VARCHAR [] FOR BIT DATA	VARBINARY	VARBINARY	BLOB
LONGVARBINARY	LONGVARBINARY	byte[]	VARBINARY	BYTEA	LONG RAW	LONG VARCHAR FOR BIT DATA	IMAGE	BLOB	LONG VARCHAR FOR BIT DATA	VARBINARY	LONGVARBINARY	BLOB
OTHER	OTHER	java.lang.Object	BLOB	BYTEA	BLOB	BLOB	IMAGE	BLOB	BLOB	IMAGE	OTHER	BLOB
JAVA_OBJECT	JAVA_OBJECT	java.lang.Object	BLOB	BYTEA	BLOB	BLOB	IMAGE	BLOB	BLOB	IMAGE	OBJECT	BLOB
BLOB	BLOB	java.io.InputStream	BLOB	BYTEA	BLOB	BLOB	IMAGE	BLOB	BLOB	IMAGE	OBJECT	BLOB
CLOB	CLOB	java.sql.Clob	TEXT	TEXT	CLOB	CLOB	TEXT	CLOB	CLOB	TEXT	OBJECT	CLOB

JDBC Types not supported by Castor

The following JDBC types are not supported by Castor yet and can therefore not been found in above table.


-	ARRAY
-	DISTICT
-	REF
-	STRUCT

Copyright © 1999-2005 ExoLab Group, Intalio Inc., and Contributors. All rights reserved.

Java, EJB, JDBC, JNDI, JTA, Sun, Sun Microsystems are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and in other countries. XML, XML Schema, XSLT and related standards are trademarks or registered trademarks of MIT, INRIA, Keio or others, and a product of the World Wide Web Consortium. All other product names mentioned herein are trademarks of their respective owners.