1. Using resultset to encapsulate data and pass by coderanch.comHello, I am working on an academic distributed database project. I will appreciate if someone can give me advice on this. I receive a distributed query from user and gather the required data from nodes. Now I want to put it in a Resultset and pass it to the user (so that he can iterate over it etc.). 1- Is it ... | ||
2. Difference between resultset and preparedStatment coderanch.com | ||
3. Getting the Keys in a Resultset coderanch.comHi Scott, Thanks for the reply.. I forgot to mention in my post that we are connecting to the database by remote and have limited access on system database tables that holds the data about the tables. We are just given a set or a list of tables that we need to query to determine its Keys and display it. So ... | ||
4. How to handle larg ResultSet coderanch.comHave you tried using the setMaxRows() method on your Statement object? Pick a reasonable number and apply it to all queries that the users input. No user is going to be able to look at 10 million rows anyway, so limiting them to (say) 10 thousand rows shouldn't be a problem. I don't know if that causes the database to only ... | ||
5. Clarrifications about ResultSet object? coderanch.com | ||
6. ClassCastException when casting my resultset to OracleResultSet coderanch.comI am working on some code that creates an empty blob in the database and then selects it to write to it. I have successfully used the exact same code before in an application I have created. I am adding it to a different application and I get the following error: java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrappedResultSet I thought maybe it was not loading the ... | ||
7. how to pass a resultset object in a function coderanch.comHai Ranchers, I have a requirment of passing a resultset object to a function. When I try to access the resultset object in the receiving end, I am getting an error like closed resultset cannot be accessed. I can understand that we pass a reference to the calling function but is there a way to pass the resultset object and its ... | ||
8. Problems with ResultSet.getBlob coderanch.comI am inserting files in databases and reading them back. I am having problems reading the blobs. In MySQL getBlob() fails with an exception and my solution was to use getObject() and cast to byte[]; that works perfect. But now, I am trying to do the same with Microsoft Access; getBlob() fails as before and (byte[])getObject() still works but the contents ... | ||
9. can't use data from resultSet coderanch.comI am a newbie, i want to retrieve data from a resultSet and compare it to another string then make decision to do something. SOMEONE COME TO MY RESCUE. The code is as below try {"com.mysql.jdbc.Driver" con =java.sql.DriverManager.getConnection("jdbc:mysql://localhost/bus_service", "root", ""); st = con.createStatement(); String query = "SELECT seat_no, seat_state FROM bus_booking WHERE _to LIKE 'dd' AND date_of_travel LIKE 'ff' AND departing_time ... | ||
10. problem in resultset coderanch.com | ||
11. ResultSet problem coderanch.comHi all, After I used a ResultSet object to store data from the database. I use the following code to print the rows one by one: while(rs.next()){ out.print(rs.getString(0)); out.print(rs.getString(1)); ... } The problem is, I will get an invalide cursor error. Then comes my investigation. The ResultSet should contain one row as validated using actual SQL against the database. rs.next() returns ... | ||
12. RESULTSET PROBLEM coderanch.com | ||
13. ResultSet coderanch.comwhile (rs.next()) { bookObject = new Book(); bookObject.setBookID(rs.getString("Book_Id")); bookObject.setBookName(rs.getString("Book_Name")); bookObject.setPrice(rs.getInt("Price")); bookObject.setQuantity(rs.getInt("Quantity")); bookObject.setCategoryName(Category.valueOf(rs .getString("Category_Name"))); rs1 = st1 .executeQuery("select Author_Name from Authors where Book_Id='"+ rs.getString("Book_Id")+"'"); while (rs1.next()) { authors.add(rs1.getString(1)); } bookObject.setAuthorName(authors); listOfBooks.add(bookObject); } the above code gives me an sqlexception because the statement "rs.getString("Book_Id")" is called twice, if you see, i had to change the second call to getString("Book_Id") with this code: rs1 ... | ||
14. resultset doubt coderanch.com | ||
15. How ResultSet works? PreparedStatment handicaps? coderanch.comOriginally posted by Antonio Fornie: 1 When I get a ResultSet from a select query with, for example, 20 rows. How many rows are loaded in memory at a time. I've heard I won't have the 20 rows in memory at a time, but in that case, is JDBC accessing the DB again and again to get the same cursor in ... | ||
16. Resultsets nested within resultsets? coderanch.comHi Guys, Due to the nature of how my system works, one way to overcome many of the problems was to use a resultset within a resultset. At the time it seemed fine but now I have realised that the main resultset will only go through one record even if there are several records in the database. When I comment out ... | ||
17. Question on resultset coderanch.comCan someone please explain what is the root cause of the below problem? if(resultSet.getClob(10) != null){ long dataLength = resultSet.getClob(10).length(); String sqlStmt = resultSet.getClob(10).getSubString(1,(int)dataLength); requestHelper.setSql(sqlStmt); requestHelper.setClob(resultSet.getClob(10)); } //This piece of code is not working. I get the below error [9/15/08 14:38:14:531 IST] 34ed34ed SystemErr R COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result ... | ||
18. No ResultSet set was produced coderanch.comhere is my Code : public class UpdateSecondary { DbStuff dbstuff = new DbStuff(); PreparedStatement pS= null ; ResultSet rS = null; public void GetFromPrimary(String seq) { String args = seq; Vector | ||
19. Resultset to flat file. coderanch.comResultset to flat file. (Java in General forum at JavaRanch) A friendly place for programming greenhorns! Register / Login Java Forums Java Java in General Resultset to flat file. Post by: Richard Miranda, Greenhorn on Aug 10, 2004 14:48:00 I'm writing a program to write a database Resultset to a flat file. I figure there must be several people ... | ||
20. ResultSet to XML coderanch.comI dont know what you are developing, but if you use a DB you might want to explore the possibility of letting the database handle XML generation for you. I've recently seen this done in MS SQL Server, and it was incredibly easy to do. Instead of writing Java code, just put the functionality into a SP. Has the added advantage ... | ||
21. Unstable data in Resultset coderanch.comHi! Using Websphere Application Server 5.1 and OS400 vs5.2 Have a javaprogram that calls a Stored procedure that delivers a resultset to the java-program. Have had a strange error that comes and goes. Usually the resultset return correct, but sometimes it deliveres some posts with a 'null' value for int fields and '0' for Strings. So same data input to stored ... | ||
22. Resultset in Collections coderanch.comHello All, I have a resultset which I want to hold in a java collection rather than resultset object after query. Whats the best way of holding the Resultset data, It can be assumed that there are going to be good number of rows and columns of varying types. regards, Abhinav Mathur | ||
23. merging 2 resultset and printing coderanch.com | ||
24. showing resultset coderanch.comYou can also wrap the while loop in an HTML table like so:
| ||
25. resultset question... coderanch.comhi folks,i have the following problem,wonder if anyone could help me out.. 1.)in my servlet i execute a SQL query on one of the tables of my database,the query returns a couple of tables and stores the result in the resultset.then i display the result in my servlet.everything is fine till now..but when my query is run so that it returns ... | ||
26. Exhausted Resultset coderanch.com | ||
27. resultset question..urgent.. coderanch.comSandeep | ||
28. ResultSet rs = prestatement.executeQuery() coderanch.com | ||
29. No resultset ?????? coderanch.com | ||
30. Exhausted Resultset coderanch.com | ||
31. checking resultsets coderanch.comHi, I want to check if the resultset from my jdbc/oracle query contains anything so I say: if(resultSet.next() == false) { tell the user there were no results using jsp1 } else { while(resultSet.next()) { print the results using jsp2 } The problem occurs when the resultSet is not empty and else is executed. Since resultSet.next() has been called in the ... | ||
32. ResultSet and count urgent please help coderanch.comHi All, I am using a ResultSet to retriev data from database. After the action i want to know whether any record is present or not. What i have done is I have used if(Rs.next()) { out.println("present") } The problem is My result set returns only one record and if i say rs.next() to check the presence of any record the ... | ||
33. ResultSet please help coderanch.com | ||
34. returning a resultset coderanch.comAt some stage in an MVC based site you need the model, the representation of the business logic for the site. There are several ways of accoplishing this, using EJBs etc and any site on MVC will discuss this for you, but basically you're looking for some way of passing data from your persistance level (database etc) via the business level ... | ||
35. ResultSet NullPointerException problem coderanch.comHI, I'm having difficulties with accessing a MySQL database resultset in a JSP. The error I'm getting is this: The following JDBC exception has occurred : java.lang.NullPointerException The reason I get it is because some columns in the database can be null and then the "ResultSet resultset.getString(4).trim();" code produces this error. I've been over the java.sql class docs to see if ... | ||
36. ResultSet object coderanch.com | ||
37. Problem with ResultSet coderanch.com | ||
38. Wrapping ResultSet coderanch.com | ||
39. ResultSet to MS-Excel. coderanch.comSure.... You may have two approaches to the problem. 1. This is a generic approach and which would work across all databases. This is explained below please refer the code snippet int totalRecordsFetched = 1 ; int batchSize = 30000 ; StringBuffer row ; while ( results.next() ) { row = new StringBuffer() ; row.append( results.getString( "col1") ); // add the ... | ||
40. ResultSet problem coderanch.comThe soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - ... | ||
41. getting time value from resultset coderanch.comHi, I have to get the time in minutes from a date column in database. I am using rs.getTime() which returns a java.sql.Time object .my problem is to convert it into minutes - is there any built in method for this job. Thanks [ October 13, 2004: Message edited by: Srikrishna DhumalRao ] | ||
42. Using Resultset object coderanch.com>Can i use resultset object after the connection and statement objects are closed? No. If you close a statement it closes all its child result sets. If you close a connection it closes all its child statements (and thus the result sets) However good code should not rely on this. You should explicitly close all of your result sets, statements and ... | ||
43. Combining Resultsets coderanch.comI'll toss out an ancient algorithm I learned when merging stacks of punch cards. This assumes data is sorted on some kind of key we can match between the two datasets: get first A record get first B record while A not end of set and B not end of set if A key == B key handle matching keys read ... | ||
44. Coversion of ResultSet coderanch.comHi, I have a project that need to connect to Access database, run a select and write the results to a text file. The coloumns needs to be Pipe seperated in the text file. I was able to work my program until getting the results in the ResultSet. I need to know how I need to convert each row attributes as ... | ||
45. ResultSet JavaBean coderanch.comHi I'm looking for ways to improve the speed of my SQL search and was thinking JavaBeans might do it. I have had a little look rounf tinternet to see how to do it, only thing is I'm not sure if I can put all of the results into one BEan or if I need to create a new Bean for ... | ||
46. Count in ResultSet coderanch.com | ||
47. Problem in running one resultset into another coderanch.comI was trying for the following code but it runs one time and gives error after tha: Statement st1 = conn.createStatement(); Statement st2 = conn.createStatement(); ResultSet rs1 = st1.executeQuery("select client from clienttable"); ResultSet st2=null; while(rs1.next()) { String cl = rs1.getString("client"); rs2 = st2.executeQuery("select subclient from subtable where client='"+cl+"'"); if(rs2.next()) { //do something } } it runs for one time and than ... | ||
48. Resultset coderanch.com | ||
49. Fetching Time from Resultset coderanch.com | ||
50. ResultSet coderanch.com | ||
51. Using ResultSet - which is a more effecient code? coderanch.comHi, I am new to Java Ranch and this is my first post. I am using the following code snippet to retrieve data from a ResultSet, store them in objects and finally store the objects in an arraylist. There are two ways in which I can do it (Type1 and Type2). Could you tell me which one is more effecient? In ... | ||
52. ResultSet returns list coderanch.comMay i know how to make this resultset return list a table of 20 columns and many rows then i want to print through the table through list. public static final List toList(ResultSet rs, List wantedColumnNames) throws SQLException { List rows = new ArrayList(); int numWantedColumns = wantedColumnNames.size(); while (rs.next()) { Map row = new LinkedHashMap(); for (int i = 0; ... | ||
53. ResultSet Traverse Problem...please help coderanch.comHi Ranchers, I have built a small GUI application using Swing that has one text field and three buttons named first,next,and last respictevely. Using these buttons i want to traverse through the ResultSet object. when i click on the 'first button' it works fine and retrives the first record from the database. This is the logic i applied for the 'first' ... | ||
54. SPs returning multiple resultsets coderanch.com | ||
55. Exhausted Resultset coderanch.com | ||
56. Returning ResultSet coderanch.comYou should never pass connection, statement or resultset outside the block where they are been obtained. You should always acquire AND close them all in the shortest possible scope. If you want to return the results from the query, then you need to map the resultset to a collection of model objects (javabeans, DTO's, VO's, POJO's, or whatever you want to ... | ||
57. Using nested Resultsets in Routines coderanch.compackage routines; import java.io.*; import java.sql.*; public class GetCategoryName { public static void getCategoryName() { try { Connection con=null; Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection( "jdbc:oracle:thin:@10.210.236.32:1521:xe", "proj_staging", "proj"); Statement s=con.createStatement(); String category = ""; String [] list = {}; String list_cat = ""; int id_av=0; int count=0; ResultSet rs_category=null; ResultSet rs_breadcrumb = s.executeQuery("select ID_AUDIOVIDEO, SOURCE_SYSTEM_BREADCRUMB from AUDIOVIDEO"); while(rs_breadcrumb.next()) { id_av = rs_breadcrumb.getInt(1); category = rs_breadcrumb.getString(2); ... | ||
58. Printing out ResultSet data coderanch.comHey guys . I have created a multi client-server application. The client has a Search button which when pressed, it must tell the server to search for whatever the user has typed in a text field. The server searches from an SQL 2000 Database. Now there is a section that I am stuck at. When the server has the data... In ... | ||
59. resultset value in vector coderanch.com | ||
60. Implementing ResultSet coderanch.com | ||
61. nested ResultSets coderanch.comprivate ArrayList searchObjectOnPriv(String priv) throws SQLException,IOException { ArrayList arrlistofobj=new ArrayList(); Statement st=null; Connection connection=null; ResultSet rs=null; String query=null; try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("Found Hardware"); connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/presize","root","root"); System.out.println("Connection created"); st=connection.createStatement(); query="select EMP_ID,START_DATE,END_DATE from PRIVILEGE where PRIVILEGES='"+priv+"' "; rs=st.executeQuery(query); while(rs.next()) { //EmpJavaBean emp=new EmpJavaBean(); //emp.setEmpNumber(rs.getInt("EMP_ID")); System.out.println("Inside ist while"); int empno=rs.getInt("EMP_ID"); //emp.setEmpFirstName(rs.getString("FIRST_NAME")); //emp.setEmpLastName(rs.getString("LAST_NAME")); System.out.println("before querry"); query="select EMP_ID,FIRST_NAME,LAST_NAME,USER_STATUS from USER where EMP_ID= '"+empno+"'"; System.out.println("after query"); rs=st.executeQuery(query); System.out.println("before ... | ||
62. setFetchSize on preparestatement vs setFetchSize on resultset coderanch.com | ||
63. Limiting ResultSet coderanch.comHi All, I have more than 10 lakh records in database. i need to fire a query to the database and generate the xml by putting those data got form query. Now what i wrote the program, throws heap memory error. Now what i want to limit the size of result set. like take only 50 lakh result in resultset, generate ... | ||
64. Funny issue with ResultSet coderanch.comsome things to check: - are you sure that you connect to the right database, - with the right user - to the expected database schema. The symptoms might tell that you are not seeing the tables that you are expecting. Check if you get the same results if you query *the same* database withanother query tool, using *the same* user, ... | ||
65. Is there any way to send the contents of a resultset to a mail using javamail coderanch.comA ResultSet doesn't have any "contents". However it is possible to read all of the records which it manifests, and I am sure you have seen code which does that. So read all of the records and format them into text in a way which is suitable for e-mailing. Then send that text. | ||
66. transform ResultSet data into a DTO coderanch.comHi, Am trying to retrieve the following data from the database. The table has "SupplierID, SupplierName, SiteId, SiteName" information. For a given supplierID, there can be more than one siteID's. The Query is "SELECT DISTINCT supplier_id, supplier_name, site_division_id, site_division_name FROM spend ORDER BY supplier_id" And there are some 5000 records. Can any one suggest me the best way to populate these ... | ||
67. problem with resultset in web service method coderanch.com | ||
68. Need logic of Removing dulicates from Resultsets coderanch.comPlease don't use abbreviations such as bcz in your posts. For many users english is a second language and it will make things harder for them. As for your question. Simply create a JavaBean Object that you store the result from your database in, one object per row. Override hashCode and equals to provide a mechanism to check for equality. Then ... | ||
69. problem in returning data using resultset coderanch.comDear, Im trying to retrive some information using select query and then pass the result set to another program. While running i got the error saying that the resultset is closed and can not have access. so I cleaned any pstmt.close or con.close . But still it throws me the same error. Do you know where is the problem? Here i ... | ||
70. What object is used in a JDBC ResultSet and how does one get it? coderanch.comI'm contemplating a producer-consumer application to move data from one DBMS to another. I want to run a query on the producer DB and use the results to build and execute an insert on the consumer DB. I would like the producer thread to enqueue each 'row' of the result set. The consumer thread will remove 'rows' and use them to ... | ||
71. Problems Processing Large ResultSet coderanch.comMy problem: I have a table with approx 5 million rows. I need to grab the data in a text column in this table, tokenize it, write it back out to the table, and write the first word of that data out to another column in the same table. My Solution: This only has to be run once so I'm not ... | ||
72. Randomising ResultSet coderanch.comhere is the scenario : my application will access BOOKS written by AUTHORS. The result set will look as follows AUTHOR | BOOK ---------------------- kathy | scjp kathy | scwcd kathy | HF ejb kathy | HF java horton | Beginning java horton | Advanced Data Structures horton | Regular Expressions in Java . . . Now my purpose is to ... | ||
73. Accessing data in ResultSet object coderanch.comAs a side note, I really dislike reading code that uses integers for result sets, such as rs.getString(1). Name your projection variables, even if they are aggregate functions! Using rs.getInt("COUNT") is so much more illustrative. There are so many reasons integer indexes can be bad, I'll let you guys fill in the blanks... | ||
74. Using bean after resultset coderanch.comCan anybody tell me, how to set the values retrived from select query from a resultset into a bean? As I know in the bean setter method we do set. but when we do while(resultset.next()), for 1st loop the values will be set then what? for the next iteration & so on? the last iteration values will be set only when ... | ||
75. accessing resultSet coderanch.com | ||
76. With out using resultset..? coderanch.comSanthosh, you might want to get someone to help you to phrase that question a little more understandably. I think what you're trying to do is the common case where you want to see if a user is defined in a database, but you do not actually want to retrieve any of the user data. The SQL version of that would ... | ||
77. Problem in getSQLXML() method of ResultSet API coderanch.comDear Friends, I developed the following code to test the getSQLXML() method of the ResultSet API which is available from Java 6. I'm usinfg Postgresql database. import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.io.StringWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.SQLXML; import java.util.Properties; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.transform.Transformer; import javax.xml.transform.TransformerFactory; import javax.xml.transform.dom.DOMSource; import javax.xml.transform.stream.StreamResult; import ... | ||
78. Resultset and Database crash coderanch.com | ||
79. resultset coderanch.com | ||
80. Resultset coderanch.comjava.util.List items = null; String query; String query2; try { query = "select * from oqrep_except_resp_summary"; Statement state = conn.createStatement(); ResultSet rs = state.executeQuery(query); while(rs.next()){ // whatever you want to fetch } rs.close(); query2 = "select * from oqrep_except_resp_detail"; Statement state2 = conn.createStatement(); ResultSet rs2 = state2.executeQuery(query2); while(rs.next()){ // whatever you want to fetch } rs2.close(); | ||
81. Which one to use ResultSet or CashedRowSet? coderanch.comHi All, I need to display 2031 pages in my jsp (with pagination) and at the top inside grid i will be diaplying 16 rows i.e 16 record per page. If i ma fetching all the 2031 * 16 record and displaying first 16 records and puting the remainig record in a pagination class , so that nest time onward if ... | ||
82. JDBC - resultset coderanch.com | ||
83. exhausted ResultSet coderanch.comhi the problem i was mainly facing was that i was using a resultset and passing the values of my database in it. i was also using the .next() method but the mistake i was making was that i was terminating the while loop before it even starts iterating. ie: i was writing while(rs.next()); instead of while(rs.next()) the power of the ... | ||
84. Create a tree from a resultset coderanch.comHi, I need to create a tree structure from a resultset and show them into my JSP. Here is my table sql (grup). CREATE TABLE GRUP ( ID_GRUP int(11) NOT NULL default '0', ID_GRUP_PARENT int(11) NOT NULL default '0', ORDER_BY int(11) NOT NULL default '1', DESCRP varchar(100) default NULL, PRIMARY KEY ('ID_GRUP'), ) What I really need is a recursive method ... | ||
85. ResultSet constants coderanch.com | ||
86. Help with how to present the resultset... coderanch.comHi, all! I'm trying to display my result from my SQL-query below. I know that I'm connected to the DB (Oracle). I have found my query in EM. I will, in the end, have 9 fields, not only one. I would like to present this output in one (nine later one) labels/something. I don't get any errors, but the label is ... | ||
87. How to present my resultset in an easy way? coderanch.comHi all! I have a table with only two fields, name and age. How do I present the result in my GUI? Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * from test.myteam"); while (rs.next()){ name = rs.getString("name"); age = rs.getInt("age"); label1 = new JLabel(name); panel.add(label1); label2 = new JLabel(age); panel.add(label2); stmt.close(); } I dont like that way and label2 dont ... | ||
88. Searching a ResultSet coderanch.com | ||
89. Need to divide ResultSet data into different groups coderanch.comHi , By querying database i had got large data on to my Resultset (assume nearly 10000) Now i want to display 100 by 100 per page (similar to google search) Please let me know what is the approach to go on this . (I am not using Hibernate Framework ) Is this requirement is same as Pagination ?? Please Share ... | ||
90. BaseResultSet being returned instead of a resultSet coderanch.comHello all, Quick question, I'm connecting to an SQL Server database and when I execute my query it is returning my resultSet which is defined as a ResultSet as a BaseResultSet. This seems to have limited functionality and I cannot access the data using getNString(ColumnName)? I have since noted that when I use connection.createStatement it at this point creates a BaseStatement? ... | ||
91. How to get an XMLElement in resultset coderanch.com | ||
92. ResultSet Exhausted coderanch.comAre you serious? Are you getting an error? What is it you want us to look for? Also, please be sure to use code tags when posting code to the forums. Unformatted or unindented code is extremely hard to read and many people that might be able to help you will just move along to posts that are easier to read. ... | ||
93. Why ResultSet's index Starts with '1' instead of zero? coderanch.com | ||
94. Behaviour of ResultSet coderanch.comOn reaching statement 2 in: Statement 1; resultset = prepstmt.executeQuery(); Statement 2; ,can we assume that all the required data has been fetched ? I mean to ask that when we reach the statement: while(resultset.next()) ,is it the case that all the data has been fetched and filled in the resultset or the resultset keeps on getting updated when the while ... | ||
95. getting the resultset of a stored procedure? coderanch.comyes , this is just an example I know that it has security issues. I have always used just preparedStatements instead of callableStatements and just used strings with ? ? and set the values of the fields... Then executeQuery or Update. But now using stored procedures I am curious will the executeQuery , executeUpdate return a vaild ResultSet I was getting ... | ||
96. Resultset order issue coderanch.comYes it has Order By. I am callling SP from Java and SP all the required stuff. When the SP is called within the Oracle its returning ordered result whereas resultset in java is showing them unordered or in a different order. The contents contain some special chars. Before including this special chars it was good. | ||
97. Is it possible to get rowCount from ResultSet Object? coderanch.com | ||
98. Could resultset be returned from another method? coderanch.com | ||
99. On small stress getting Exhausted Resultset coderanch.comHe,everybody! My program works just fine for one user. But when I stress my application with 300 transactions per minute (avg 5/sec) i am getting an error (1 transaction of 300 failed). When i stress with 1000 about 100 transactions are failed. And I can't understand what's wrong. The error: java.sql.SQLException: Exhausted Resultset at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1091) at MyApp.selectSQL(MyApp.java:90) Piece of code: public ... | ||
100. Database Reconnection mechansim at resultset level coderanch.comHi, We're working on providing auto-reconnection mechanism for our application that uses remote database for the backend. Currently we've incorporated reconnection mechanism at Connection level and Statement level by introducing wrappers for these two classes. While testing we found that the connection got lost while processing the Resultset. We're looking at possible ways for providing reconnection and re-execution of the Query ... |