users@glassfish.java.net

RE: JPA: boolean property as NUMBER(1,0) in Oracle dialect

From: Gordon Yorke <gordon.yorke_at_oracle.com>
Date: Mon, 17 Sep 2007 10:59:17 -0400

Hello Witold,
   Oracle DB does not have a native Boolean type and NUMBER(1,0) is the popular method of representing a boolean. PostgreSQL does have a native boolean type so it is used by the platform.
--Gordon

-----Original Message-----
From: Witold Szczerba [mailto:pljosh.mail_at_gmail.com]
Sent: Monday, September 17, 2007 10:00 AM
To: users_at_glassfish
Subject: JPA: boolean property as NUMBER(1,0) in Oracle dialect


Hi there,
why does TopLink Essentials map boolean entity property as NUMBER(1,0)
instead of real boolean column type for Oracle database?
That is really annoying, once I converted my database from Oracle to
PostgreSQL, but TopLink Essentials for PostgreSQL want boolean instead
of NUMBER(1,0).
What is that mess for?

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net