Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML to DB2

user12862658Apr 12 2010 — edited Apr 12 2010

Hello,

I try to insert the data of a XML file into a DB2 database.

I configured the topology manager with this URL :

jdbc:snps:xml?s=XML_SCHEMA&d=C:\Directory\my_xsd.xsd&dod=true&ldoc=false&dp_driver=com.ibm.db2.jcc.DB2Driver&dp_url=jdbc:db2://HOST:PORT/database:currentschema=my_current_shema;translate binary=true;sendCharInputsUTF8=1;&dp_user=my_user&dp_password=my_password&dp_schema=my_current_shema&dp_doc=Y&dp_ct=Y&dp_tbl=Y&dp_ci=Y&dp_tbl=Y&dp_iidb=Y&dp_dtods=Y&dp_ups=Y&dp_ubu=Y

I have this error message when I click on the button "Test" :
"com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2026][11146] Can't convert a Unicode string to Ebcdic string"

I don't know why the DB2 driver try to convert teh string (which string?) in EBCDIC.

Is there someone who can help me please?

Thank you in advance.

Edited by: user12862658 on 12 avr. 2010 08:04

Edited by: user12862658 on 12 avr. 2010 08:04

Edited by: user12862658 on 12 avr. 2010 08:05

Edited by: user12862658 on 12 avr. 2010 08:05

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2010

Added on Apr 12 2010

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration, #xml

2 comments

1,437 views