[jboss-jira] [JBoss JIRA] Commented: (JBAS-1536) Wrong SQL Type for Boolean Mapping for Derby Database

[Tomas Gustavsson (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBAS-1536?page=comments#action_12361151 ] 
            
Tomas Gustavsson commented on JBAS-1536:
----------------------------------------

a SMALLINT seems to work for me. I found it by googling.
I have tested by adding the following to my jbosscmp-jdbc.xml.
-----
<cmp-field>
  <field-name>markedAsRecoverable</field-name>
  <jdbc-type>BIT</jdbc-type>
  <sql-type>SMALLINT</sql-type>
</cmp-field>
-----

Cheers,
Tomas
www.ejbca.org


> Wrong SQL Type for Boolean Mapping for Derby Database
> -----------------------------------------------------
>
>                 Key: JBAS-1536
>                 URL: http://jira.jboss.com/jira/browse/JBAS-1536
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: CMP service
>    Affects Versions: JBossAS-4.0.1 Final
>         Environment: JBoss4.0.1; JDK1.5.0update1;Windows XP SP2;Derby 10.0.2.1 Embedded
>            Reporter: Ingo Bruell
>             Fix For: JBossAS-4.2.1.CR1
>
>
> The SQL datatype 'BOOLEAN' is not a valid datatype for the derby database.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira