[JBoss-dev] [ jboss-Bugs-911014 ] DB2/400 mapping problems

[SourceForge.net <no...@so...>]

Bugs item #911014, was opened at 2004-03-06 18:29
Message generated for change (Comment added) made by pilhuhn
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=911014&group_id=22866

Category: JBossCMP
Group: v3.2
>Status: Closed
Resolution: None
Priority: 5
Submitted By: Robert Upshall (rupshall)
Assigned to: Heiko W.Rupp (pilhuhn)
Summary: DB2/400 mapping problems

Initial Comment:
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.


----------------------------------------------------------------------

>Comment By: Heiko W.Rupp (pilhuhn)
Date: 2004-11-20 11:00

Message:
Logged In: YES 
user_id=217112

Seems to be fixed in 4.0 

----------------------------------------------------------------------

Comment By: Robert Upshall (rupshall)
Date: 2004-03-08 16:31

Message:
Logged In: YES 
user_id=444991

I am not %100 sure but it is my understanding that DB2/400
is a little different than other DB2.  I think it is a
little more limited.

----------------------------------------------------------------------

Comment By: Heiko W.Rupp (pilhuhn)
Date: 2004-03-08 15:35

Message:
Logged In: YES 
user_id=217112

Do you know if DB2/400 differs here from other DB2 versions?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=911014&group_id=22866