[jboss-jira] [JBoss JIRA] Commented: (JBAS-1536) Wrong SQL Type for Boolean Mapping for Derby Database
[ 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