Resultset 4 « Resultset « Java Database Q&A





1. Using resultset to encapsulate data and pass by    coderanch.com

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

3. Getting the Keys in a Resultset    coderanch.com

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

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

6. ClassCastException when casting my resultset to OracleResultSet    coderanch.com

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

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

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

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

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

while (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.com

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

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

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

here 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 vecky = new Vector(); String sql = "select * from IVRFINTRAN where sequence= '" + seq + "'"; Connection con = dbstuff.createDbConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver", "dburl", "dbuser", "dbpass"); try { pS= con.prepareStatement(sql); ...

19. Resultset to flat file.    coderanch.com

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

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

Hi! 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.com

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

You can also wrap the while loop in an HTML table like so:

<% while(rs.next()) { %> <% } %>
<%= rs.getString("name"); %> <%= rs.getString("phone"); %>
note the use of the <%. This kinda breaks the rules of the MVC paradigm, but I have seen so many times now.

25. resultset question...    coderanch.com

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

Sandeep

Sun Certified Programmer for Java 2 Platform

Oracle Certified Solution Developer - JDeveloper
-- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java
-- Object-Oriented Analysis and Design with UML

Oracle Certified Enterprise Developer - Oracle Internet Platform
-- Enterprise Connectivity with J2EE
-- Enterprise Development on the Oracle Internet ...

29. No resultset ??????    coderanch.com

30. Exhausted Resultset    coderanch.com

31. checking resultsets    coderanch.com

Hi, 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.com

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

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

HI, 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.com

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

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

Hi, 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.com

I'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.com

Hi, 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.com

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

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

Hi, 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.com

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

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

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

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

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

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

63. Limiting ResultSet    coderanch.com

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

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

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

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

68. Need logic of Removing dulicates from Resultsets    coderanch.com

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

Dear, 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.com

I'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.com

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

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

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

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

Santhosh, 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.com

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

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

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

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

Hi, 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.com

Hi, 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.com

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

Hi , 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.com

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

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

94. Behaviour of ResultSet    coderanch.com

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

yes , 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.com

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

99. On small stress getting Exhausted Resultset    coderanch.com

He,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.com

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