| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC Adapter and Binary data |
« View previous topic :: View next topic » |
| Author |
Message
|
| christian witschel |
 Posted: Wed Dec 07, 2005 12:46 am Post subject: JDBC Adapter and Binary data |
 |
|
Apprentice
Joined: 07 Dec 2005
Posts: 27
|
Hi,
I am moving Data from one Database (Oracle 9i) to another.
All in all, it is the table EXPORT_DATA with fields ID (Varchar2(20)) and DATA (RAW) that have to go into IMPORT_DATA with ID (Varchar2(20)) and DATA (RAW).
according to the documentation binary fields in a database are not supported natively by the JDBC Adapter, but
| Quote: |
If BYTEARRAY=true, the connector will read and write binary data to the database. Since there is no support for binary data in the WebSphere Business Integration system, the binary data is converted to a String and then sent to the integration broker. The format of this string is a hexadecimal number with 2 characters per byte. For example, if the binary data in the database is 3 bytes with the (decimal) values (1, 65, 255), the string will be "0141ff".
|
I specified in the BO for the field DATA CN=DATA:BYTEARRAY=true.
Next I tested the whole scenario.
The Data in the BO that is created and send to the Broker is a long String that (like described in the docs) represents the hex values of the binary data. So reading works.
Writing however does not work. The Adapter write the String as is into the DB. So where on the source side I had the value "DEF ASDW" I now have something like "0204FE" ... (Example is made up)
Why does the JDBC Adapter not convert the String back into binary?
Any help is greatly appreciated. |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
