Results 1 to 3 of 3
  1. #1
    namalsera is offline Member
    Join Date
    Jan 2011
    Posts
    3
    Rep Power
    0

    Default java code running 24x7

    I have a program read the data from queue and then run a stored proc to update the oracle DB(10g) This runs 24X7 and 360 days.
    Also per day It process around 150,000 transactions.
    Code work as follows.
    connect to the queue (Websphere MQ)
    connect to the data base (Oracle)
    inside a lood it read the data from queue
    and then run the stored proc to update the tables.
    then it wait in the queue until it receive next message.
    this is how it works.

    There are 7 seven programs running in the sun os. used nohup to submit the programs.

    Some time all this 7 programs get hangs, when it try to run the stored proc.

    Is there any better way to change the program logic to avoid this senario( When we kill and re-run, it works properly. Al so this happen after running 4 to 5 days.)

    Please help me.

  2. #2
    travishein's Avatar
    travishein is offline Senior Member
    Join Date
    Sep 2009
    Location
    Canada
    Posts
    684
    Rep Power
    6

    Default

    hanging after time,. I think it might be possible something somewhere is not closing a jdbc connection, statement, resultset, and this is slowly exausting the resources of the database connection object, which would cause this hang experience after a while.

  3. #3
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    20

Similar Threads

  1. Replies: 0
    Last Post: 01-05-2011, 10:53 PM
  2. Java Code running problem
    By socboy6579 in forum New To Java
    Replies: 11
    Last Post: 10-26-2010, 04:07 AM
  3. Run Java code 24x7
    By ersachinjain in forum Advanced Java
    Replies: 6
    Last Post: 08-24-2010, 08:54 AM
  4. Replies: 6
    Last Post: 02-06-2009, 08:05 PM
  5. problem while running java code..
    By Jjava in forum New To Java
    Replies: 0
    Last Post: 02-08-2008, 06:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •