• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

Exception when using Oracle AQ

 
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to enqueue xml messages to AQ as RAW data type. This works fine for small messages. However, when I try to enqueue a big message (219kb), I get the following:
oracle.AQ.AQOracleSQLExcpetion: data size bigger than max size for this type: 219546
Does anyone know why and how I can avoid this?
Thanks in advance
Rom
 
rom chatterjee
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Found the answer out for tohse that may be interested.
Basically, the problem is that the Java interface to Oracle AQ uses PL/SQL. That in turn has a limit to its buffer size of 32k! So in short there is no nice way around this.
The C++ interface uses OCI. This allows you to queue messages up to 4G. If you need to send big messages (I do) then theres no other option than to go native.
Hope this will save someone the time I spent finding this out
Rom
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic