Derby types mappping tests

[Рябицкий Евгений <er...@diasoft.ru>]

Schema generation is using this query to create test table on Derby:

INFO: CREATE TABLE TYPES_MAPPING_TEST1 
(AAAID INTEGER NOT NULL, 
BIT_COLUMN SMALLINT, 
BOOLEAN_COLUMN SMALLINT, 
TINYINT_COLUMN SMALLINT
PRIMARY KEY (AAAID))

Why everything is mapped to SMALLINT?
There is BIT, BOOLEAN and TINYINT types in Derby.

http://db.apache.org/ojb/docu/guides/jdbc-types.html

Evgeny.

RE: Derby types mappping tests

[Рябицкий Евгений <er...@diasoft.ru>]

Ah yeah... sory I am wrong... there is no such types... sad...
Super db... never use it....


http://db.apache.org/derby/docs/10.5/ref/

Evgeny.


-----Original Message-----
From: Рябицкий Евгений [mailto:eryabitskiy@diasoft.ru] 
Sent: Thursday, January 14, 2010 3:32 PM
To: dev@cayenne.apache.org
Subject: Derby types mappping tests

Schema generation is using this query to create test table on Derby:

INFO: CREATE TABLE TYPES_MAPPING_TEST1 
(AAAID INTEGER NOT NULL, 
BIT_COLUMN SMALLINT, 
BOOLEAN_COLUMN SMALLINT, 
TINYINT_COLUMN SMALLINT
PRIMARY KEY (AAAID))

Why everything is mapped to SMALLINT?
There is BIT, BOOLEAN and TINYINT types in Derby.

http://db.apache.org/ojb/docu/guides/jdbc-types.html

Evgeny.

Re: Derby types mappping tests

[Andrus Adamchik <an...@objectstyle.org>]

I don't remember the actual details, but the link you sent is from OJB  
project, not Derby.

Andrus

On Jan 14, 2010, at 2:31 PM, Рябицкий Евгений wrote:

> Schema generation is using this query to create test table on Derby:
>
> INFO: CREATE TABLE TYPES_MAPPING_TEST1
> (AAAID INTEGER NOT NULL,
> BIT_COLUMN SMALLINT,
> BOOLEAN_COLUMN SMALLINT,
> TINYINT_COLUMN SMALLINT
> PRIMARY KEY (AAAID))
>
> Why everything is mapped to SMALLINT?
> There is BIT, BOOLEAN and TINYINT types in Derby.
>
> http://db.apache.org/ojb/docu/guides/jdbc-types.html
>
> Evgeny.
>