If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

caught sqlexception ORA-01000: maximum open cursors exceeded

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

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.