Professional Web Applications Themes

DB2 Codepage conversion problem with XML - IBM DB2

Hi all, i have the following problem. I'm using a DB2-Client V7 on a Linux-Server from a Java-Application. This application connected to zOS(OS390)/DB2 V7 with the App-Driver (db2java.zip). Because I can't use Unicode on the zOS/DB2, I have disable Unicode in the "db2cli.ini" on the DB2-Client (disableunicode=1). More detailed Information about the systems: Linux-Server: java: 1.4.1_04, Java HotSpot(TM) Client VM mixed mode os: Linux version 2.4.21 on i386 encoding: ISO-8859-15 DB2-Client: driver: IBM DB2 JDBC 2.0 Type 2 (App-Driver from ../java12/db2java.zip) version: 07.02.0008 isolation: read committed opened to: jdbc:db2:adb set in "db2cli.ini" "disableunicode=1" in the "[common]"-section z/OS: os-version: sorry, don't ...

  1. #1

    Default DB2 Codepage conversion problem with XML


    Hi all,



    i have the following problem.



    I'm using a DB2-Client V7 on a Linux-Server from a Java-Application.

    This application connected to zOS(OS390)/DB2 V7 with the App-Driver
    (db2java.zip).

    Because I can't use Unicode on the zOS/DB2, I have disable Unicode in
    the "db2cli.ini" on the DB2-Client (disableunicode=1).





    More detailed Information about the systems:



    Linux-Server:

    java: 1.4.1_04, Java HotSpot(TM) Client VM mixed mode

    os: Linux version 2.4.21 on i386

    encoding: ISO-8859-15



    DB2-Client:

    driver: IBM DB2 JDBC 2.0 Type 2 (App-Driver from
    ../java12/db2java.zip)

    version: 07.02.0008

    isolation: read committed

    opened to: jdbc:db2:adb

    set in "db2cli.ini" "disableunicode=1" in the "[common]"-section



    z/OS:

    os-version: sorry, don't know the version



    DB2:

    database: DB2 OS/390

    version: 07.01.0001

    codepage: 273 (EBCDIC 8-Bit ?)





    When I store data in a char-field on the zOS-Side everything works
    great. Also characters over 0xFF was converted/translated. All these
    characters where stored in the zOS/DB2 as 0x3F (I know, that I lost

    the information what character it was, but it is ok).



    But now my problem begin.

    When the Java-Application read the data, it pd the data with a XML-
    Pr. Everything works fine until it get a character with the code
    0x3F, because of codepage conversion the java-application get a
    character with a hexcode 0x1A, and the XML-Pr throws an

    exception that 0x1A is an illegal XML character.



    Here the error:

    Error: editor.proxy: Error while reading sgml

    Unzulässiges XML-Zeichen: 

    org.xml.sax.SAXPException: Unzulässiges XML-Zeichen: 

    at org.apache.crimson.pr.InputEntity.fatal(InputE ntity.java:1100)

    at

    org.apache.crimson.pr.InputEntity.pdConten t(InputEntity.java:59-
    3)

    at org.apache.crimson.pr.Pr2.content(Pr2. java:1826)

    at org.apache.crimson.pr.Pr2.maybeElement(Par ser2.java:1507)

    at org.apache.crimson.pr.Pr2.content(Pr2. java:1779)

    at org.apache.crimson.pr.Pr2.maybeElement(Par ser2.java:1507)

    at org.apache.crimson.pr.Pr2.pInternal(Pa rser2.java:500)

    at org.apache.crimson.pr.Pr2.p(Pr2.ja va:305)

    at

    org.apache.crimson.pr.XMLReaderImpl.p(XMLR eaderImpl.java:442)

    at

    org.xml.sax.helpers.XMLReaderAdapter.p(XMLRead erAdapter.java:223)

    cma2 Guest

  2. #2

    Default Re: DB2 Codepage conversion problem with XML

    You might consider other drivers (StarSQL for example -
    [url]www.starquest.com[/url]) to see if the problem is related to the driver.

    Bob

    cma2 <member38827dbforums.com> wrote in message news:<3349126.1063133691dbforums.com>...
    > Hi all,
    >
    >
    >
    > i have the following problem.
    >
    >
    >
    > I'm using a DB2-Client V7 on a Linux-Server from a Java-Application.
    >
    > This application connected to zOS(OS390)/DB2 V7 with the App-Driver
    > (db2java.zip).
    >
    > Because I can't use Unicode on the zOS/DB2, I have disable Unicode in
    > the "db2cli.ini" on the DB2-Client (disableunicode=1).
    >
    >
    >
    >
    >
    > More detailed Information about the systems:
    >
    >
    >
    > Linux-Server:
    >
    > java: 1.4.1_04, Java HotSpot(TM) Client VM mixed mode
    >
    > os: Linux version 2.4.21 on i386
    >
    > encoding: ISO-8859-15
    >
    >
    >
    > DB2-Client:
    >
    > driver: IBM DB2 JDBC 2.0 Type 2 (App-Driver from
    > ../java12/db2java.zip)
    >
    > version: 07.02.0008
    >
    > isolation: read committed
    >
    > opened to: jdbc:db2:adb
    >
    > set in "db2cli.ini" "disableunicode=1" in the "[common]"-section
    >
    >
    >
    > z/OS:
    >
    > os-version: sorry, don't know the version
    >
    >
    >
    > DB2:
    >
    > database: DB2 OS/390
    >
    > version: 07.01.0001
    >
    > codepage: 273 (EBCDIC 8-Bit ?)
    >
    >
    >
    >
    >
    > When I store data in a char-field on the zOS-Side everything works
    > great. Also characters over 0xFF was converted/translated. All these
    > characters where stored in the zOS/DB2 as 0x3F (I know, that I lost
    >
    > the information what character it was, but it is ok).
    >
    >
    >
    > But now my problem begin.
    >
    > When the Java-Application read the data, it pd the data with a XML-
    > Pr. Everything works fine until it get a character with the code
    > 0x3F, because of codepage conversion the java-application get a
    > character with a hexcode 0x1A, and the XML-Pr throws an
    >
    > exception that 0x1A is an illegal XML character.
    >
    >
    >
    > Here the error:
    >
    > Error: editor.proxy: Error while reading sgml
    >
    > Unzulässiges XML-Zeichen:
    >
    > org.xml.sax.SAXPException: Unzulässiges XML-Zeichen:
    >
    > at org.apache.crimson.pr.InputEntity.fatal(InputE ntity.java:1100)
    >
    > at
    >
    > org.apache.crimson.pr.InputEntity.pdConten t(InputEntity.java:59-
    > 3)
    >
    > at org.apache.crimson.pr.Pr2.content(Pr2. java:1826)
    >
    > at org.apache.crimson.pr.Pr2.maybeElement(Par ser2.java:1507)
    >
    > at org.apache.crimson.pr.Pr2.content(Pr2. java:1779)
    >
    > at org.apache.crimson.pr.Pr2.maybeElement(Par ser2.java:1507)
    >
    > at org.apache.crimson.pr.Pr2.pInternal(Pa rser2.java:500)
    >
    > at org.apache.crimson.pr.Pr2.p(Pr2.ja va:305)
    >
    > at
    >
    > org.apache.crimson.pr.XMLReaderImpl.p(XMLR eaderImpl.java:442)
    >
    > at
    >
    > org.xml.sax.helpers.XMLReaderAdapter.p(XMLRead erAdapter.java:223)
    DB2 Guest

Similar Threads

  1. MD5 conversion problem
    By Peter Afonin in forum ASP.NET Security
    Replies: 15
    Last Post: September 1st, 09:48 PM
  2. Conversion problem
    By David_COHEN4@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: April 18th, 02:55 PM
  3. Font conversion problem
    By Jack_Harich@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: April 1st, 03:59 PM
  4. Response.CodePage
    By Steve Kushubar in forum ASP
    Replies: 4
    Last Post: September 26th, 09:37 AM
  5. case conversion problem
    By James Edward Gray II in forum PERL Beginners
    Replies: 7
    Last Post: September 11th, 07:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139