File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Why it is making soo many tansactions?

 
Amirr Rafique
Ranch Hand
Posts: 324
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have created a basic Spring applicatin to read from Oracle AQ. I am experiencing following issues. Kindly help me on this

1)- Messages placed on the queue (by PL/SQL code) prior to starting of my spring application are not dequeued by it.
2)- A message that is successfull read from the queue should be removed from the queue. This is not happening. All messages remain in Queue Table.
3)- Once a message is read, the process goes in block/waiting state, as shown by the log below, if any message is place on queue during that period, that message is ignored.


4)- Why it is making soo many tansactions? While waiting on queue


below is my spring config


Kindly help me out
Thanks
 
Amirr Rafique
Ranch Hand
Posts: 324
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
any idea guys
 
Mark Spritzler
ranger
Sheriff
Posts: 17276
6
IntelliJ IDE Mac Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In your message listener bean you have

container-class="org.springframework.data.jdbc.jms.listener.oracle.AdtMessageListenerContainer" destination-type="topic">

destination-type="topic" but you say it is a Queue. Queues and Topics work differently, Topics can keep messages on the Topic after just one listener receives it.

Maybe that is why.

Mark
 
Amirr Rafique
Ranch Hand
Posts: 324
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mark,
it is a Topic but even if there is no other listener and no new message on Topic, my transaction manager keeps on creating transaction.....
 
Mark Spritzler
ranger
Sheriff
Posts: 17276
6
IntelliJ IDE Mac Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are not making sense, in your first post you say you are putting a message on the Queue, then it is a Topic, then there is no messages.

Do you have your Topic configured to be a persistent one, so that it uses a database to save Messages? Maybe that is causing it.


Maybe it is not the Topic creating Transactions but some other code. You aren't using any Scheduler?

It also looks like the Transaction is committing something, so what query is running?

Unfortunately, this might be a case of there is too much information missing to help, and too much too post. In a forum, and might require someone with eyes on it to help fix it.

Good Luck.

Thanks

Mark
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic