Hi all

  I've been suffering from a silly problem for about two months, and I'm 
afraid it's probably due to a stupid thing which I can't spot (you get 
blind to your own code after a while...).

  It seems the boolean values read from my posgres database are allways 
false, whatever the actual state they are in. If modified they get 
written back all right, and then their value is consistant... until I 
restart jboss.

  I know there was some trouble with booleans & postgres some time ago 
(I looked closely in the mailing lists), but I'm quite sure my problem 
doesn't arise from my 'jaws.xml'. This file doesn't contain any type 
mapping anyway (jBoss uses its own 'standardjaws.xml').

  Here is the mapping I use in my 'jaws.xml':
    <cmp-field>
      <field-name>anonymous</field-name>
      <column-name>anonymous</column-name>
      <sql-type>INT2</sql-type>
      <jdbc-type>TINYINT</jdbc-type>
    </cmp-field>

  That correspond to (in my 'ejb-jar.xml'):
    <cmp-field>
      <field-name>anonymous</field-name>
    </cmp-field>

  I think this should be all right, considering 'standardjaws.xml':
       <type-mapping>
           <name>PostgreSQL</name>
           <mapping>
               <java-type>java.lang.Boolean</java-type>
               <jdbc-type>TINYINT</jdbc-type>
               <sql-type>INT2</sql-type>
           </mapping>

  Thanks in advance to any kind soul.



--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
List Help?:          [EMAIL PROTECTED]

Reply via email to