#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    Banglore
    Posts
    0
    Rep Power
    0
    hello,
    i am using tomcat-apache on linux. i have an emply.jsp where i open the connection and connect to oracle database and retrive the result from EMP and close the connection. it works fine for 3-4 times. but on continuously executing the same file will hang the browser and bumps an error saying document had no data. Is this tomcat-apache configuration performance problem if yes then what to configure.

    Comments on this post

    • Gran Roguismo agrees
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    London,UK
    Posts
    0
    Rep Power
    0
    Sounds like you're running out of available connections in Oracle. It would be a good idea to make a connection pool to reuse existing connections, this will reduce the overhead of making new connections all the time.
    Also you could also increase the number of connections available in Oracle.

    ------------------
    Philos

    Comments on this post

    • Gran Roguismo agrees

IMN logo majestic logo threadwatch logo seochat tools logo