 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / General / March 2008[BEA][Oracle JDBC Driver]No more data available to read.
Hi, I am working on - BEA Weblogic version 9.22 & Oracle 10g. I have created a data source(Connection Pool) with below configuration: Initial Capacity: 1 Maximum Capacity: 15 Test Connections on Reserve: Selected Test Frequency: 1 Database Driver: Oracle's Driver (Thin) Version 9.0.1, 9.2.0, 10 When I am trying to invoke any of the store procedure using JDBC's callabale statement, I get an exception: [BEA][Oracle JDBC Driver]No more data available to read. I am not able to figure out what is the root cause. When i see my code, everything seems to be fine. Also the procedures seems to be OK. It will be great if any one can let me know the solution. Thanks. On 13 Mrz., 06:10, "mineshde...@gmail.com" <mineshde...@gmail.com> wrote: > Hi, > I am working on - BEA Weblogic version 9.22 & Oracle 10g. I have [quoted text clipped - 15 lines] > > Thanks. It just looks as if your ResultSet was closed. This may happen because of a closed connection, a timed out connection, (it might be even a multithreading issue). I had this problem some time ago after an admin changed firewalls settings. Just to be sure, the DB-server is available from your webserver ? best regards Markus Tazl > On 13 Mrz., 06:10, "mineshde...@gmail.com" <mineshde...@gmail.com> > wrote: [quoted text clipped - 28 lines] > best regards > Markus Tazl Hi Yes DB server is available from my webserver. What did you do to resolve the problem? Just use the JDBC test your code and procedure. If there is no problem, perhaps you had better check you weblogic setting. Removing the possible causes one by one. > Just use the JDBC test your code and procedure. > If there is no problem, perhaps you had better check you weblogic > setting. > Removing the possible causes one by one. Procedure is fine.... I have double checked it using JDBC. "mineshde...@gmail.com" wrote: >> [BEA][Oracle JDBC Driver]No more data available to read. >> >> I am not able to figure out what is the root cause. When i see my >> code, everything seems to be fine. Also the procedures seems to be OK. "Seems OK" is so non-specific. I trust you know specifically what things you checked, and specifically how your code didn't violate the items you knew to put on your specific checklist. Of course the code isn't OK, or you wouldn't have the bug. Therefore "seems" is an illusion. >> It will be great if any one can let me know the solution. > It just looks as if your ResultSet was closed. > This may happen because of a closed connection, > a timed out connection, (it might be even a multithreading issue). > I had this problem some time ago after an admin > changed firewalls settings. Just to be sure, the DB-server > is available from your webserver ? From <http://java.sun.com/javase/6/docs/api/java/sql/ResultSet.html> > A ResultSet object is automatically closed when the Statement object > that generated it is closed, re-executed, or used to retrieve the next > result from a sequence of multiple results. Could this apply in your case? Are you doing something else with the Statement object while the ResultSet is still using it? (Detachable RowSets are an apparent exception to this.) > best regards > Markus Tazl The RFCs for Usenet specify "-- " (dash dash blank) on its own line as the separator for the sig line(s). Many newsreaders will omit the sig from quoted material in a reply.  SignatureLew > "mineshde...@gmail.com" wrote: > >> [BEA][Oracle JDBC Driver]No more data available to read. [quoted text clipped - 36 lines] > -- > Lew Lew thanks for the reply, I modified a configuration setting of Weblogic Server. I have reduced the Test Frequency Time to 1 . And as of now i am not getting the error. The application is under observation. If this is successful i will surely let everyone know. Secondly, I know seems is not the proper word i have used above. Anyways Thanks for the help Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.