-
1. Re: Mapping of Postgres Booleans
pazu Dec 7, 2001 8:29 AM (in response to toastkid)There's already a PostgreSQL mapping in standardjaws.xml. If the field is always returning false, something must be wrong with you app. Or there is a bug in Jaws.
-
2. Re: Mapping of Postgres Booleans
schaefera Dec 7, 2001 1:36 PM (in response to toastkid)What datatype do you use on the table ?
Andy -
3. Re: Mapping of Postgres Booleans
toastkid Dec 11, 2001 6:13 AM (in response to toastkid)The table is autocreated when the Bean is deployed and comes out as type smallint.
-
4. Re: Mapping of Postgres Booleans
schaefera Dec 13, 2001 3:24 PM (in response to toastkid)Try to use type CHAR. You can either overwrite standardjaws.xml or your application jaws.xml.
Andy -
5. Re: Mapping of Postgres Booleans
pfink Dec 18, 2001 11:39 AM (in response to toastkid)Why not use bool?
I mean not to be radical but it is a boolean. -
6. Re: Mapping of Postgres Booleans
knut Feb 15, 2002 4:21 AM (in response to toastkid)We had the problem also and then I found this link:
http://www.kpi.com.au/jbossarchive/0108/0010.html
You can read the whole answer there, the shortversion is:
In standardjaws.xml change from:
<type-mapping>
PostgreSQL
<java-type>java.lang.Boolean</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>INT2</sql-type>
To
<type-mapping>
PostgreSQL
<java-type>java.lang.Boolean</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>BOOL</sql-type>
/Knut -
7. Re: Mapping of Postgres Booleans
tsmets Apr 8, 2002 4:11 AM (in response to toastkid)
I found on this Forum another post referencing this page
http://www.rtner.de/software/jaws-postgresql7.html
My apologies for not quoting the original post but the forum is funny tis morning & I cannot find it "back"
Thomas SMETS,
tsmets @ lautre . net