Details
-
Bug
-
Resolution: Done
-
Major
-
JBossAS-3.2.6 Final
-
None
Description
SourceForge Submitter: rupshall .
I am attempting to configure JBoss to connect to a
DB2/400 database, I am using JBoss 3.2.3 and iSeries OS
version v5r2m0. I have found 2 mapping problems with
the DB2/400 section of standardjbosscmp-jdbc.xml
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>SMALLINT</sql-type>
</mapping>
and
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>SMALLINT</sql-type>
</mapping>
The above mappings work perfectly for me but the
default ones did not, I obtained the mappings from
this IBM site
http://www-306.ibm.com/software/data/db2/udb/ad/v8/java/ad/rjvjdata.htm#TBLJVREGOU
so I think they should be accurate.