I have a fairly easy application that has several database hits within the jsp via a bean which opens and closes connection. The only problem is when I constantly do a search (on my datawarehouse) with the same user I get "java.sql.SQLException: ORA-01000: maximum open cursors exceeded" as an error. I can't find any documenation on it. Can anyone help?
.i have nested loop the loop .Around 100 times the application hits the database correctly and than the error i hv done everything closing resultset etc etc..pl tell me what problem is this
1]is this oracle problem??? if so how to overcome it
2]If problem in my application what should i do to overcome the same
or anything else???/ guide me...