| Author |
Message |
 Topic: Getting to a XML element |
ganeshkj
Replies: 14
Views: 8265
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 18, 2004 3:23 am Subject: Getting to a XML element |
Is the problem being resolved ?
What is the message domain being set to ? Is it being set to XML ?
Rgds
Ganesh |
| Topic: Inserting Large XML into Oracle database - Urgent |
ganeshkj
Replies: 8
Views: 5669
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 17, 2004 2:19 am Subject: Inserting Large XML into Oracle database - Urgent |
Thnx...
Let me figure out what could be the problem....
Anyway i have alternate solutions which could be considered..Instead of MQSI doing the insert, need to look at whether this can be replace ... |
| Topic: Inserting Large XML into Oracle database - Urgent |
ganeshkj
Replies: 8
Views: 5669
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 17, 2004 12:40 am Subject: Inserting Large XML into Oracle database - Urgent |
Hi,
Here i am facing problem while inserting from MQSI using ESQL...How will it help from reading Oracle PL/SQL books ? Could you plz suggest ?
Mr. Rowe, could you provide more clarity to your ... |
| Topic: Inserting Large XML into Oracle database - Urgent |
ganeshkj
Replies: 8
Views: 5669
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 16, 2004 9:29 am Subject: Inserting Large XML into Oracle database - Urgent |
Hi,
Currently I have the following in the flow:
Insert statement as
Insert into Database.Tablename(Field1, XMLfield2) Values (value1, XMLValue);
Where XMLValue is a variable defined in ... |
| Topic: error trying to start a debugger |
ganeshkj
Replies: 2
Views: 2236
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 16, 2004 8:37 am Subject: error trying to start a debugger |
Hi,
Some of the process will be using the socket number. COnsult u'r MQSI Admin to check which socket can be used.
rgds
ganesh |
| Topic: Inserting Large XML into Oracle database - Urgent |
ganeshkj
Replies: 8
Views: 5669
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 16, 2004 3:11 am Subject: Inserting Large XML into Oracle database - Urgent |
Hi,
Did not clearly understand by your statement " got round it by binding the XML string to an oracle variable first" ?
Does it mean that i need to use a stored procedure in Oracle and call ... |
| Topic: Inserting Large XML into Oracle database - Urgent |
ganeshkj
Replies: 8
Views: 5669
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 16, 2004 2:38 am Subject: Inserting Large XML into Oracle database - Urgent |
Hi,
I am inserting large XML (more than 4 K in size) to Oracle 9.0 and above database from MQSI 2.1 using the database node. It is showing the following error message: "[DataDirect][ODBC Oracle ... |
| Topic: XMLType Data Insertion..Any limit in the length? |
ganeshkj
Replies: 5
Views: 3312
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 08, 2004 3:18 am Subject: Soln:: |
Guys,
problem while insertion was because of the XSD location mentioned...Seems Oracle 9.2.0.3 version automatically checks for this XSD...
now everything is working fine....Sorry for this m ... |
| Topic: XMLType Data Insertion..Any limit in the length? |
ganeshkj
Replies: 5
Views: 3312
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 08, 2004 1:06 am Subject: XMLType Data Insertion..Any limit in the length? |
Guys,
Figured out it is not MQSI or Driver issue.....it's a oracle problem...I tried inserting from the Sql prompt the samle XML data. It is giving the same error message..
Will post the exact ... |
| Topic: XMLType Data Insertion..Any limit in the length? |
ganeshkj
Replies: 5
Views: 3312
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 04, 2004 1:24 am Subject: XMLType Data Insertion..Any limit in the length? |
Hi,
When i inserted the following XML message, it is inserted successfully.
<XYZMessage><Header><ProcSeqNbr>973674</ProcSeqNbr><TypeSeqNbr>1</TypeSeqNbr>&l ... |
| Topic: XMLType Data Insertion..Any limit in the length? |
ganeshkj
Replies: 5
Views: 3312
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 03, 2004 9:14 am Subject: XMLType Data Insertion..Any limit in the length? |
Hi all,
In Oracle 9.2.0.4, I am inserting value for a XMLType field. When i am inserting smaller message it is inserting perfectly. But if the XML message is little bigger, I am getting the foll ... |
| Topic: Inserting to Oracle 9.2.0.4 |
ganeshkj
Replies: 2
Views: 2211
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 03, 2004 9:09 am Subject: Thnx |
| Thnx alot for the pointer. It worked |
| Topic: Inserting to Oracle 9.2.0.4 |
ganeshkj
Replies: 2
Views: 2211
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 02, 2004 7:49 am Subject: Inserting to Oracle 9.2.0.4 |
Hi,
I am a newbie in this MQSI.
Using the Database Node and ESQL i am trying to insert a record to a oracle database. but it throws the following exception while using Usertrace.
The v ... |
