The CHAR definition works with PostgreSQL 7.1, but breaks in postgres 7.2. This is because they fixed a driver bug where they silently truncated values that were too long. I have a patch on deck to split the mappings into a 7.1 version and a 7.2 version. I'll be pulling that patch into the 2.4 brach shortly.
-danch Andreas Schaefer wrote: > Hi Geeks > > ATTENTION: Only applies to 2.4 because in 3.0 this > is already fixed. > > A while ago I enountered a problem with PostgreSQL > and the support for "java.lang.Boolean". > When I define a PostgreSQL table attribute with > data type "Bool" the mapping in "standardjaws.xml" is > not working. > Therefore I would like to change from: > > <name>PostgreSQL</name> > <mapping> > <java-type>java.lang.Boolean</java-type> > <jdbc-type>TINYINT</jdbc-type> > <sql-type>INT2</sql-type> > </mapping> > > to: > > <name>PostgreSQL</name> > <mapping> > <java-type>java.lang.Boolean</java-type> > <jdbc-type>CHAR</jdbc-type> > <sql-type>BOOLEAN</sql-type> > </mapping> > > Any objects ? At least I want to document why using > INT2/TINYINT or BOOL/CHAR etc. > > Thanx > > xxxxxxxxxxxxxxxxx > Andreas Schaefer > Senior Consultant > JBoss Group, LLC > xxxxxxxxxxxxxxxxx > > > > _______________________________________________________________ > > Sponsored by: > ThinkGeek at http://www.ThinkGeek.com/ > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
