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.
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.