Author |
Message
|
gunjand |
Posted: Mon Nov 05, 2012 3:41 pm Post subject: Unable to read large clob message from db |
|
|
Novice
Joined: 21 May 2009 Posts: 23
|
Hi,
We are inserting XML as CLOB in Oracle table and while reading it is failing if the length of message is greater than 21846. While doing further research we found that it has an additional space after length of 21845 and while parsing the message it's failing. We cannot visualize the space if we check the data in database.
We also tried setting value of MQSI_LOB_BUFFER_INCREMENT_SIZE variable to larger value, but still it does not help.
Environment: Message broker 6.1
 |
|
Back to top |
|
 |
kash3338 |
Posted: Mon Nov 05, 2012 10:18 pm Post subject: |
|
|
Shaman
Joined: 08 Feb 2009 Posts: 709 Location: Chennai, India
|
How are you inserting the XML from the ESQL? Are you CASTing the message to BLOB before doing it or as CHAR? What is the DB being used and whats its version, there is option of XML datatype in Database, which enables to store the XML as-is. |
|
Back to top |
|
 |
gunjand |
Posted: Tue Nov 06, 2012 10:04 am Post subject: |
|
|
Novice
Joined: 21 May 2009 Posts: 23
|
Inserting as BLOB by casting the data. DB used is Oracle (11.1 version) |
|
Back to top |
|
 |
kash3338 |
Posted: Wed Nov 07, 2012 12:55 am Post subject: |
|
|
Shaman
Joined: 08 Feb 2009 Posts: 709 Location: Chennai, India
|
gunjand wrote: |
Inserting as BLOB by casting the data. DB used is Oracle (11.1 version) |
In Oracle 11g you have the option of storing the XML as a XML type itself. Thats a best way to store your XML messages.
Even when you store as CLOB, first reset your message to BLOB in the flow and before inserting in DB cast as CHAR and store it. Only then you will be able to get back the same message. |
|
Back to top |
|
 |
mqjeff |
Posted: Wed Nov 07, 2012 4:06 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
kash3338 wrote: |
gunjand wrote: |
Inserting as BLOB by casting the data. DB used is Oracle (11.1 version) |
In Oracle 11g you have the option of storing the XML as a XML type itself. Thats a best way to store your XML messages. |
Broker doesn't support native XML data types. |
|
Back to top |
|
 |
mgk |
Posted: Wed Nov 07, 2012 4:16 am Post subject: |
|
|
 Padawan
Joined: 31 Jul 2003 Posts: 1642
|
|
Back to top |
|
 |
mqjeff |
Posted: Wed Nov 07, 2012 4:23 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
|
Back to top |
|
 |
kash3338 |
Posted: Wed Nov 07, 2012 8:57 am Post subject: |
|
|
Shaman
Joined: 08 Feb 2009 Posts: 709 Location: Chennai, India
|
We have done this and even CHAR can be used to insert into DB XML column which is not mentioned in the link  |
|
Back to top |
|
 |
|