| Author |
Message
|
| fjb_saper |
 Posted: Mon Dec 22, 2003 2:58 pm Post subject: Oracle API 32K limitation urgent |
 |
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
We are sending out messages via JMS to multiple systems one of them using the oracle to MQ bridge. It appears that there is a limitation of 32k for the message size on that API.
Does anyone know how to break that limitation. I would have to have to introduce extra coding just because the message is too big to fit the oracle API.
Thanks
F.J.  |
|
| Back to top |
|
 |
| kman |
| Posted: Mon Dec 22, 2003 11:13 pm Post subject: |
|
|
Partisan
Joined: 21 Jan 2003
Posts: 309
Location: Kuala Lumpur, Malaysia
|
| For sending and receiving larger messages, you can use msg grouping. But before that, is that limitation an Oracle API limitation, or an MQ limitation? What version of MQ are you using? Which Oracle MQ bridge are you referring? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Dec 23, 2003 6:33 am Post subject: Oracle API 32K Limitation Urgent |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Hi Kman,
The limitation I am referring seems to be an Oracle limitation.
I dug up the part that's causing us the problem:
Oracle Procedural Gateway Version 9.2.0.2 on Oracle Db 9.2.0.4 running on Sun Solaris.
MQ handles my messages fine(max msg size 4MB on both ends). How ever the Oracle 9i bridge to MQ being used by the collegue will not allow messages beyond 32k. I know there is a gateway that uses JMS between MQ and oracle but that's not being used (not even installed).
Looks to me that short from splitting the message at the source, or writing some Java code on the target there is little to do. If you know of any configurable solution that would not require any changes in coding I would be grateful.
Thanks
F.J.  |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Jan 08, 2004 3:45 pm Post subject: Oracle API 32K limitation |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Hi guys,
This is how we fixed it:
Do not use the oracle procedural gateway
USE THE MESSAGING GATEWAY FROM ORACLE 
worked for inbound out of the box.
Worked great after installing the patch for outbound
Enjoy  |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Thu Jan 08, 2004 4:33 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
|
| Back to top |
|
|
|
|
