aspose file tools*
The moose likes JSP and the fly likes How to solve recursive SQL level string  Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "How to solve recursive SQL level string  Problem" Watch "How to solve recursive SQL level string  Problem" New topic
Author

How to solve recursive SQL level string Problem

Vinay Naidu
Greenhorn

Joined: Jun 25, 2006
Posts: 5
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

Joined: Nov 24, 2005
Posts: 156
which server you are using? if you are using Oracle Application Server then i guess restart your OC4J.
Vinay Naidu
Greenhorn

Joined: Jun 25, 2006
Posts: 5
Hi

I am Using simply JBoss Application Server 4.0.2 Database oracle 10g
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60063
    
  65

"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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Can you post the code snippet, dealing with DB?
Nikhil Goel
Ranch Hand

Joined: Jul 11, 2003
Posts: 32
Please have a look

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

this will help you .
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
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

Joined: Aug 15, 2004
Posts: 2874
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to solve recursive SQL level string Problem
 
Similar Threads
WAS 6.1 DataSource issue
Not able to drop user Oracle10.2.0.3 Ent Ed.
need to drop number of user from database
getting error while droping the user in oracle.
new jdbc exception