sexta-feira, 19 de setembro de 2014

Hibernate/JPA: Mapeamento de tipos Java para SQL

Fonte: http://docs.oracle.com/cd/E19159-01/819-3672/gbxjk/index.html

Java Type Java DB, Derby, CloudScape Oracle DB2 Sybase MS-SQL Server MySQL Server 
boolean,java.lang.BooleanSMALLINTNUMBER(1)SMALLINTBITBITTINYINT(1)
int,java.lang.IntegerINTEGERNUMBER(10)INTEGERINTEGERINTEGERINTEGER
longjava.lang.LongBIGINTNUMBER(19)INTEGERNUMERIC(19)NUMERIC(19)BIGINT
float,java.lang.FloatFLOATNUMBER(19,4)FLOATFLOAT(16)FLOAT(16)FLOAT
double,java.lang.DoubleFLOATNUMBER(19,4)FLOATFLOAT(32)FLOAT(32)DOUBLE
short,java.lang.ShortSMALLINTNUMBER(5)SMALLINTSMALLINTSMALLINTSMALLINT
bytejava.lang.ByteSMALLINTNUMBER(3)SMALLINTSMALLINTSMALLINTSMALLINT
java.lang.NumberDECIMALNUMBER(38)DECIMAL(15)NUMERIC(38)NUMERIC(28)DECIMAL(38)
java.math.BigIntegerBIGINTNUMBER(38)BIGINTNUMERIC(38)NUMERIC(28)BIGINT
java.math.BigDecimalDECIMALNUMBER(38)DECIMAL(15)NUMERIC(38)NUMERIC(28)DECIMAL(38)
java.lang.StringVARCHAR(255)VARCHAR(255)VARCHAR(255)VARCHAR(255)VARCHAR(255)VARCHAR(255)
char,java.lang.CharacterCHAR(1)CHAR(1)CHAR(1)CHAR(1)CHAR(1)CHAR(1)
byte[],java.lang.Byte[],java.sql.BlobBLOB(64000)LONG RAWBLOB(64000)IMAGEIMAGEBLOB(64000)
char[],java.lang.Character[],java.sql.ClobCLOB(64000)LONGCLOB(64000)TEXTTEXTTEXT(64000)
java.sql.DateDATEDATEDATEDATETIMEDATETIMEDATE
java.sql.TimeTIMEDATETIMEDATETIMEDATETIMETIME
java.sql.TimestampTIMESTAMPDATETIMESTAMPDATETIMEDATETIMEDATETIME

Nenhum comentário:

Postar um comentário