Re: strange problem using Oracle AQ with java

I am using AQ successfully with 8.1.7.1. I think a lot of this has to do with how you set your queue table up, and the options specified when queueing/dequeueing from it. Also, I think the 8.1.7.1 patch fixed some issues, like the queue table never getting cleaned up.

-Peter

Pete Hawdon wrote:
>
> Hello all,
>
> I have a problem that's been very frustrating.
>
> I am using Advanced Queueing on Oracle 8i v8.1.7 .
>
> I have created a queue table and a queue, via JDBC (thin driver on client).
>
> No problem so far.
>
> I have a flat file of records that I am parsing and creating XML messages
> from.
>
> These messages are then ENQUEUED into the Oracle queue, again via JDBC thin
> driver on client.
>
> No problem so far.
>
> My test file has 11 records in, that results in 11 XML messages. I do a row
> count on the queue table using SQLPlus and get 11 rows.
>
> I have another java class that performs DEQUEUEs on the queue.
>
> I do a DEQUEUE using this java class and i get a NullPointerException
> exception. (The dequeue fails).
>
> I do another 5 DEQUEUES and get NullPointerException each time (each dequeue
> fails)
>
> I do a 7th dequeue and it extracts a message succesfully from the queue. I
> can then do another 10 dequeues succesfully.
>
> If i rerun the ENQUEUE operation to repopulate the queue with 11 more
> messages then i get the same problem again,
> ie 6 NullPointerException problems and on the seventh run it works!
>
> Any ideas??????
Received on Wed Jul 25 2001 - 07:45:55 CDT