This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to solve recursive SQL level string Problem

 
Vinay Naidu
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello sir

I am Using One Jsp Page That Page Fetch The all Details But some Times Show half Of The Details Only at The Time These Errors Fired.

1)ORA-00604: error occurred at recursive SQL level string
2)ORA-00018:maximum number of sessions exceeded.

I click The Refresh Then Show to All Details
 
sachin yadav
Ranch Hand
Posts: 156
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
which server you are using? if you are using Oracle Application Server then i guess restart your OC4J.
 
Vinay Naidu
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I am Using simply JBoss Application Server 4.0.2 Database oracle 10g
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64683
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"vinay chk",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you post the code snippet, dealing with DB?
 
Nikhil Goel
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please have a look

http://www.orafaq.com/forum/t/21841/2/

this will help you .
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Nikhil Goel:
Please have a look

http://www.orafaq.com/forum/t/21841/2/

this will help you .


After looking to your code, I got to know that it is nothing to do with JSP. You would, hopefully, get some help in JDBC Forum.

Thanks.
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
After going through few searches I got to know that its difficult to find the solution over the net.

You can try the same code, or something similar, on some other Oracle DB.

Wish you all the best.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic