It makes me want to slam my head in a car door a few times. Alright, so that is some good information, but when I add TRANSLATE=1 or ForceTranslation = 1 into the connection string I get an invalid property exception. Is my connection string properly formed as you see it? I have to add the schema names to the mapping file as you can see by my earlier screenshot.
Definitely can't change the table... errr... I mean file structure. There are a ton of rpg programs running off of this. Man this is annoying. On Aug 19, 2:48 pm, MattO <[email protected]> wrote: > Ryan, > > Okay, so even though you didn't tell me which column you are having > issues with I am going to assume it is the ABALKY column that has the > problem. I *BELIEVE* the issue is the code page of 65535. Really > that should probably be code page 37 (US English) like the other > fields, but someone may have accidently? made the wrong code page > value. Code page 65535 from what I can tell means that it should be > treated as binary data. Here is a snippet that leads me to believe > that: > > *HEX: The CCSID 66535 is used, which indicates that the character data > in the fields is treated as bit data and is not converted. > > This is from this > page:http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/cl/c... > > So as I see it you have two options. > > 1. Change the code page for that column to 37 like the other CHAR > columns (this would require potentially a lot of work, any RPG program > that is bound to that table or CHAIN to it would have to be recompiled > I assume, but I'm not an RPG master but this is one of those things I > despise the AS400 for). > > 2. Add a flag to your connection string to tell it how to convert > binary data. This is probably the simplest option. adding > TRANSLATE=1; to your connection string should fix the issue. (see the > third link below for why). > > See here for more information: > > http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic...http://www.ibm.com/developerworks/data/library/techarticle/dm-0506cho... > > and finally the good part: > > http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic... > > Isn't the AS400 FUN!!!! (I'm being very sarcastic here). > > On Aug 19, 12:39 pm, rhartzog <[email protected]> wrote: > > > > > Thank you MattO, here is the information you have requested: > > > Key column: > > Column: ABAN8 > > Data Type: Zoned > > Field Length: 8 0 (yes a space is between those two numbers) > > Code Character Set: null > > > No problems displaying information: > > Column: ABALPH > > Data Type: CHAR > > Field Length: 40 > > Code Character Set: 37 > > > Problems displaying information: > > Column: ABALKY > > Data Type: CHAR > > Field Length: 20 > > Code Character Set: 65535 > > > 2) I took a screenshot of my hibernate.cfg > > file:http://lh5.ggpht.com/_HHLbJSECQBs/TG1nAn5p8FI/AAAAAAAAATY/dqugRhiflhA... > > > 3) -- Generate SQL > > -- Version: V5R4M0 060210 > > -- Generated on: 08/19/10 12:04:01 > > -- Relational Database: DWHOMES > > -- Standards Option: DB2 UDB iSeries > > CREATE TABLE TESTDATA.F0101 ( > > -- SQL150B 10 REUSEDLT(*NO) in table F0101 in TESTDATA ignored. > > ABAN8 NUMERIC(8, 0) NOT NULL DEFAULT 0 , > > -- SQL150D 10 EDTCDE in column ABAN8 ignored. > > ABALKY CHAR(20) CCSID 65535 NOT NULL DEFAULT '' , > > ABALPH CHAR(40) CCSID 37 NOT NULL DEFAULT '' , ... > > > 4) Looks like V5R4 from item #3 above. I am using version 12.0.0.0 of > > the IBM.Data.DB2.iSeries.dll > > > 5) A screenshot of the mapping file. I have tried various definitions > > with the problematic > > column.http://lh5.ggpht.com/_HHLbJSECQBs/TG1r1AGDT2I/AAAAAAAAATk/ceHT9vWi3_I... > > > I am not even sure my session factory is set up properly, so if > > something looks wrong it probably is. > > > Thanks again, > > Ryan > > > On Aug 19, 8:00 am, MattO <[email protected]> wrote: > > > > Welcome to DB2/AS400 hell, I'm in the same boat (sinking) as you. All > > > joking aside, here is what I would do to help trouble shoot the > > > issue. It may be a character code set translation issue (which your > > > DB2 driver must use) > > > > 1. Login to the AS400 and do a DSPFFD (display phsyical file > > > description) on the table in question, then copy and paste the results > > > of that column information. The info I'm looking for is fieldname, > > > data type, field length, and coded character set. > > > 2. Copy and paste your connection string that you are using in here, > > > this is important as it controls how character sets are decoded. > > > 3. Go into iSeries navigator and go to Databases>>your > > > database>>Schemas>>Library>>Tables, then find the table in question > > > and right click on it and click on "Generate SQL". Then hit the > > > "Generate" button. Copy the information from the creation script for > > > the field in question to this forum post. > > > 4. List the version of AS400 you are running (V5R4, V6R1, etc) and > > > tell me the version of the IBM.DB2.Iseries .NET driver you are using > > > 5. Also paste in your HBM XML mapping file so I can compare all the > > > information. > > > > Once we have that we may be able to get to the bottom of whats going > > > on. > > > > On Aug 18, 8:28 pm, rhartzog <[email protected]> wrote: > > > > > I am very new to trying to access data on a db2 sitting on an AS400 > > > > server. There is a column which shows in EZVIEW as data type "A" with > > > > a length of 12. Using iNavigator and looking at the table definition > > > > it shows as character 12. When I map this to a string property it > > > > writes out as System.Byte[] so I am a bit confused. There is very > > > > little in the way of documentation or examples for using NH with db2 > > > > so I am coming up short on finding any help with this. Any help with > > > > how to map these data types or mapping to a db2 in general would be > > > > greatly appreciated.- Hide quoted text - > > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
