Resultset 3 « Resultset « Java Database Q&A





1. ResultSet and sum    coderanch.com

2. Problem in ResultSet    coderanch.com

Hi, I am getting error Invalid operation for read only resultset when I executed this program.Please tell me what wrong I did import com.uhc.basics.dao.*; //import com.uhc.basics.ods.dao.*; import java.sql.Connection; import java.sql.Statement; import java.sql.ResultSet; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.PreparedStatement; public class TestDAO extends GenericDAO{ public TestDAO() { } void initVariables() { m_driverClassname = "oracle.jdbc.driver.OracleDriver"; m_jdbcURL = "jdbc :-o racle:thin:bods04/bods04@basicsdvdbu02.uhc.com:1525:bodsddb"; } void testConnection() ...

3. Resultsets survives failure    coderanch.com

4. processing resultset    coderanch.com

Hi there. I am connecting to an Oracle database using Oracle JDBC drivers and all that kind of thing. I then send sql select statements to retrieve the necessary information. Everything is fine to this point. The results of my query are then loaded into an OraceResultSet which contains two columns (my select statement requests string and float values from the ...

5. ResultSet    coderanch.com

6. ResultSet problem    coderanch.com

i am encountering a problem with ResultSet when using it in my jsp JSP here is some code as to what i am doing: String sqlquery = "..."; ResultSet rs = mydb.genericQuery(sqlquery); while (rs.next()) { ..... } tomcat gives a null pointer exception on the "while(rs.next())" part. my sql query is correct because i tested it in the database and it ...

7. BookMark for disconnected resultset    coderanch.com

When keeping the cursor open, I can page through the resultset to get the the next 10 records or the previous 10 records, but keeping the cursor open is expensive operation. To avoid this, I would like to get a hold of the current record physical address and return a connection back to the pool. Later, using the physical address and ...

8. Accessing multiple resultsets    coderanch.com

Hi All; Here's some wierd problem I'm facing while handeling multiple resultsets from stored procedure. I've a stored procedure that returns multiple cursors. And I access them in my code. After accessing the first resultset when I want to access next one. As usual I code it like CallableStatement.getMoreResults(); ResultsetObj=CallableStatement.getResultset(); But I get ResultsetObj as null...and I know that stored produre ...

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





10. ResultSet    coderanch.com

11. moving in a ResultSet    coderanch.com

Kelvin, Method "next()" of interface "java.sql.ResultSet" returns a boolean. Perhaps you have reached the end of your "ResultSet". Also, your error handling code simply prints "Error" on the console. Since you are using a GUI, perhaps you forgot to look at the console to see if "Error" is getting displayed? Perhaps your code should be something like: public ResultatVO nesteRad() throws ...

12. ResultSet check if there are any values    coderanch.com

Thats what I was doing but the weirdest thing, the recordSet would not return all the records that met the criteria, I mean I execute the query then check it with rs.next() and oracle would just return some of the records not all, not to mention the fact that if there is data it skips the first record, which I don't ...

13. Serialization and Resultset    coderanch.com

Hi Kriti, a Connections and Resultsets are very valuable and limited resources that help to connect to another system (RDBMS). you could probably write some logic to serialize the Objects, but the underlying resuources that these Objects depend on for connecting and reading data from a database will not be serialized..and will be reused when another process calls for their services. ...

14. Resultset.getFetchSize()    coderanch.com

15. problem with the resultset    coderanch.com

Hi, see the bellow code . i am not able to execute updateString() method. Connection cn; Statement stmt; ResultSet rs; cn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521","scott","tiger"); stmt = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery("select * from emp"); rs.absolute(5); rs.updateString(2,"ramesh"); In the above statement iam getting some error like readable resultset can not be updatable i am using oracle 9i please reply to the above problem [edited ...

16. JDBC mock runner - resultset updation.    coderanch.com





17. using a ResultSet with setxxx    coderanch.com

18. vector and resultset    coderanch.com

I am writing a Type 3 JDBC Driver where network protocol is RMI. I am invoking this remote method. queryInf query = (queryInf)Naming.lookup("rmi://localhost:1099/queryService"); Vector queryResult = query.execute(schema,datasource,select,from); The result is returned as a vector. Now in my driver I need to implement the ResultSet interface(specifically next() and getString()) to find whether there is any more element and to get the element. ...

19. No ResultSet was produced    coderanch.com

Hi I'm trying to insert values into an access database but whenever I execute my query I get the Error message No ResultSet was produced. I can't work out why this is can someone please point me in the right direction. ere is my code: import java.sql.*; class InsertData { static String url = "jdbc :-o dbc:Bank"; static Connection connection; private ...

20. ResultSet    coderanch.com

boolean resultExists=false; ResultSet resultSet = statement.executeQuery(query); while(resultSet.next()) { resultExists=true; //if it enters here, there must be "atleast" one row that has satisfied your query. //else if it does not enter here, there are ro rows retrieved. } you can use the boolean variable in your code to write further logic if required... this is the only way as I know that ...

21. resultset problems    coderanch.com

Ok, I'm having trouble with what I hope to be a simple issue. In my cd store web app, I have a servlet mapped as my index to load the music categories and then forward over to my actual index page. This servlet references a model, and right now I have the model returning a resultset. However when I try to ...

22. ResultSet    coderanch.com

23. problem with resultset    coderanch.com

Hi, I have a JTextField c_name. I have a focus listener added to this.I enter a value in this box and store this value in a variable cust_name. I pass this variable to the select statement to retrieve values from the database. The problem is I do not get all the rows. The resultset returns just one row( whichever it finds ...

24. Help needed with ResultSet    coderanch.com

Praveen, You start by looping through just like in a standard result set. The first time through, just add the name/value pairs to the map. Also store the user id (key) in a variable. On subsequent iterations of the loop, see if the user id is the same as in the previous row. If it is the same, just read the ...

25. Combine Resultset    coderanch.com

Hello, I am writing a Java application which returns XML having data for n attributes. Data for all the attributes can not be retrieved by firing a single SELECT query. so I have to fire multiple queries and then combine all resultsets to get data for attributes. I am not sure how can I combine the results? Any suggestions?

26. ResultSet problem    coderanch.com

hi guys, i am new to this forum....i have got some problem with conditional SELECT statement while working with JDBC.Following is my code fragment. String query1="SELECT * FROM teacherdata WHERE code=' " + input + " ' "; System.out.println(query1); stmt1=con.createStatement(); ResultSet rst1=stmt1.executeQuery(query1); while(rst1.next()) { gs1=rst1.getString("code"); gs2=rst1.getString("name"); gs3=rst1.getString("age"); gs4=rst1.getString("sex"); gs5=rst1.getString("padd"); gs6=rst1.getString("tadd"); gs7=rst1.getString("email"); System.out.println(gs8); gs9=rst1.getString("doj"); gs10=rst1.getString("dob"); } the loop (while(rst1.next()) is not working ...

27. problem with resultset    coderanch.com

A resultSet can hold the data of only one table*. Better say it like, a resultSet can hold the result of only one query, a query may include more than on table. *Table may be created and filled on the fly. I think you want to ask, how many rows it can hold? right?

28. multiple resultset    coderanch.com

Hi I am using sql server version 2000 Orion 1.5.2 jdk 1.4 I am facing one problem is In my session bean query to get records ,i am using compute function which returns multiple records ,It works fine Code : --Got connection as conn --Created Statement as stmt --initialised resultset and resultmetadata as rs and rsmd boolean nextResultSet=true; while(nextResultSet) { rs ...

29. can you pass ResultSet as argument    coderanch.com

30. Significance of ResultSet.setFetchSize()    coderanch.com

We are using Oracle 8i as DB Server, WebLogic 6.1 as App Server and IIS 5.0 as Web Server on the different physical m/c. We are using OCI8 Driver. We have a utility that will act as a cache manager. We have to provide a query, it will hold the result in ArrayList. We are measuring time taken by the DB ...

31. resultset processing gives java.lang.OutOfMemoryError    coderanch.com

Originally posted by Steven Bell: Just process one line at a time. Thanks Steven, but how do you want me to do that. my resultset will have more than 25000 rows with many columns. I'm procesing a single row and put that in arraylist. once one row is completed, I will add that arraylist to another list. this way, my outer ...

32. ResultSet absolute(), relative()    coderanch.com

Hi Shailesh Thanks for giving reply. I went through link & understood point. But Second point is also important. If i have 10000 rows in that case if i used this solution that is fetching rows & moving cursor will take more time. So i want practical solution. If anybody has practical solution for this please let me know Thanks in ...

33. resultset    coderanch.com

My problem is I want to query the database which contain around 20000 records. and get all the records and write it to a flat file. Since there is a large amount of data i need someway to get the first 200 records in one resultset. i think i can do this by setting the fetch size of the result set. ...

34. Resultset Exhausted    coderanch.com

Hi guys, Was just wondering if anybody could suggest anything as I am getting a resultset Exhausted exception and my query returned 1 record when directly executed thru oracle client. ResultSet rs = pstmt.executeQuery(); try { rs.next(); retValue = createNew(rs); } finally { rs.close(); } } finally { pstmt.close(); } return retValue; } catch (SQLException e) { logger.error("" + ErrorCode.DB_LOAD_V_CLOSE_INFO, e); ...

35. About ResultSet    coderanch.com

36. Can't I have two simultaneosly active Resultsets?    coderanch.com

Hi all, I have an application that calls a method from a DAO class based on parameters provided by the user. The method returns an iterator based on a resultset. The main application works on that iterator and, for each item from it writes a line to a file on disk. Usually I have the resultset with thousands of lines which ...

37. About ResultSet    coderanch.com

38. ResultSet methods, absolute    coderanch.com

39. Resultset Parsing.    coderanch.com

Rajesh, Your choices are: 1) Use a different driver - probably not practical for you 2) Return the column twice in the select clause - this is inefficient 3) Try using getString("name") - probably has same issue 4) Store as local variable as Sunil suggested I recommend going with choice #4. It protects you against any other driver oddities that may ...

40. Navigate through ResultSet    coderanch.com

41. Resultset functionality    coderanch.com

42. ResultSet Manipulation    coderanch.com

Hi Everyone, I need to know, is there any possibility for us to get a limited count of records from resultset ? Basically, the problem is , if the query result - resultset returns more than 10000 records, i couldn't able to get all the records in the Swing client..returning Out of Memory error.So, we decided to show some 5000 records ...

43. Combining 2 disparate ResultSets    coderanch.com

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

45. ResultSet interface - regarding    coderanch.com

When we have a statement such as ResultSet rs = stmt.executeQuery( :wink: ; Assume a scenario where SQL_QUERY returns 100 rows. 1) Would objects corresponding to these 100 records be created immediately after this statement in the appserver side? 2) Or is it that no objects get created in the app server side until we start accessing the records by saying ...

46. Resultset to Xml File?    coderanch.com

I have an open source project called the FormattedDataSet that creates text (including html, csv, xml,...) from any tabular data (including ResultSets, arrays, Collections). In general it is flexible and easy to work with. You have total control of what text is generated. Look at www.fdsapi.com. From here you can see sample code and look at the live demo. Here is ...

47. how to handle when procedure returns more than one resultset    coderanch.com

I think your asking about multiple result sets, not multiple columns in a single result set. In that case, you have to make sure the database/driver support this fluidly. If so, you can use getMoreResults() and getResultSet() to iterate through additional results sets. I refer you to the following IBM article: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.java/bjnkmstr31.htm Which states: 1. Invoke the Statement.execute method or PreparedStatement.execute ...

49. ResultSet    coderanch.com

Here's another possible (and reusable) approach. Call the getRowCount() function below & see if the return value is greater than zero. //---------------------------------------------------------------------------------------------- /** * Determines the number of rows in a ResultSet. Upon exit, if the cursor was not * currently on a row, it is just before the first row in the result set (a call to * {@link ResultSet#next()} ...

50. Creating an MDB from the resultset    coderanch.com

I have a requirement to connect to Access Database and execute query and with the Resultset create a table in another database(MDB). Each query resultset should be populated to appropriate tables in the .MDB. I do not know how I can create and populate a table from the resultset.Can somebody help me?

51. Disconnected resultsets...    coderanch.com

Hello Everyone, I come from a .net world. One of the nice objects within its data access architecture is a "DataTable". This is similar to a resultset but with one significant difference - it is completely disconnected from its datasource. Which, unless I'm missing the point, is different to resultsets in that they hold connections until they are destroyed. I like ...

52. Process results from resultset vs from data structure    coderanch.com

Hi Guys, I'm working with a DB2 backend that returns, not an incredible amount of data, but somewhat sizable(100+ rows x 28 columns). The issue is the data needs to be processed in a pretty complex fashion. The initial design is to run through the resultset once and handle the processing that way. This lends towards an awkward design, as it's ...

54. Resultset display    coderanch.com

hi i m begineer i need an idea from u for displaying resultset in terms of 10 records so that there must be prev and next buttons so that i can access previous or next records relative to the present records and number of records /total no.of records.pls respond to me regards [ February 27, 2006: Message edited by: rai talari ...

58. Easy way to returning ResultSets    coderanch.com

59. building from ResultSet    coderanch.com

It is indeed a very good idea to capture the data in the result set into another structure for passing to a JSP. You want to be able to close the result set as soon as possible, and not exposing such back-end details to the UI layer is a good architectural decision. Rather than dealing with each field one at a ...

60. Resultset question    coderanch.com

Hi, Can someone help me to find the answer the following questions: 1. Statement st = connec.createStatement(); Resultset rs1 = st.executeQuery("sql"); Resultset rs2 = st.executeQuery("sql"); Is this fine to use the same statement object to get one more resultset or will there be any problem ? 2. Can we pass the resultset obj from server to the client side ?

61. Manually Alter ResultSet + ResultSetTableModel    coderanch.com

Hi all, Is it possible to manually change the data in a resultset? With the code i'm working with, a table eventually gets populated with a ResultSetTableModel: model = new ResultSetTableModel(resultSet); This works fine, displaying the columns and data from the resultset. However, one of the values of the resultset is an int value of 1 or 0. Instead of displaying ...

62. resultset question    coderanch.com

hi all is there a way to set the current position of the cursor in a resultset to the row number that i choose. for example if i have a resultset containing 1000 records and i want only the last 500, is there a way i can set the cursor to start from record 500? of course i can call next() ...

63. What's the fastest way to free a ResultSet?    coderanch.com

try{ con = MSSQLServerDAOFactory.createConnection(AppHelper.SC_DS_MAIN); ps = con.prepareStatement("UPDATE Customer set " + "Gender = ?," + "BirthDate = ? " + "WHERE PersonID = ?"); ps.setString(1, data.getGender()); ps.setString(2, data.getDob()); ps.setInt(3, data.getPersonId()); try { ps.executeUpdate(); } catch (SQLException e) { logger.error(e.getMessage()); throw e; } ps = con.prepareStatement("SELECT CustomerID from Customer WHERE PersonID = ?"); ps.setInt(1,data.getPersonId()); rs = ps.executeQuery(); if(!rs.next()){ logger.error("throw a finder ex:"+data.getPersonId()); ...

65. storing Resultset in a collection    coderanch.com

66. Big ResultSet    coderanch.com

Hi all, I have a sql that retrieves more than 50k rows. I need to display these values in the selectbox(dropdown) on my JSP screen. When I do so, I get outOFmemeory Exception and operation timed out. One solution I found was to use Statement.setMaxRows(int max). But, does this restrict the rows to be displayed or fetches only the number of ...

67. How to save value from ResultSet as a single value in database    coderanch.com

I'm using dynamic checkbox to retrive some values. It works fine but when i save to database it saves each record individually. I want to join all the records into one and save it as a single entry in the database. This is my code rst2 = stm1.executeQuery("select * from students"); String Childic = ""; for(int i = 0; rst2.next(); i++){ ...

68. Implementation of ResultSet Interface    coderanch.com

70. Select Random result from Resultset    coderanch.com

Hi, I have a requirement to randomly select a string from a resultset. How do I do it ? I have a resultset which selects 2 strings from Oracle database. Like this: Select a,b from table a where xxx Lets say my query gives me 5 record sets. For each transaction I want to retrieve results randomly, like if first transaction ...

72. Resultset concept    coderanch.com

Dude.. Your curiosity surprises me.. However the thing is.. If the result set uses some kind of buffer I don't see the point of it I mean it's most unlikely that it does so. although you can't get the length of it you can recall an object at a specific index.. I'm really not sure about how the api works but ...

73. working with multiple resultsets    coderanch.com

Is there any reason that you could not create a virtual table (using VIEW) that incorporates the data from both sets? Any time either data set is updated, the updates will be reflected in the virtual table. I don't know how you are comparing the data, but comparisons can be built into the table also. Then you would only need a ...

74. How ResultSet works    coderanch.com

75. Exhausted Resultset    coderanch.com

Idieally it doesn insert into dabase but doesn't commit.In other words If we run query on database we can see records but if we try to execute query from program we won't see them. (Dirty read) Please recheck this scenario And use executeBatch rather than execute method as execute method some hoe opens the resultset and we get some weied erros ...

76. The ResultSet    coderanch.com

77. random resultsets    coderanch.com

I have never come across a way to return a random order result set. One way to do this might be to do a SELECT returning only the primary key value for each row: SELECT mytable_id FROM mytable ... Then, put the results into a java.util.List. Then randomize the list (not too hard to do). Then, run a new query, iterating ...

78. ResultSet doubt    coderanch.com

hi Lalit, If you set them to null, they won't be closed. About performance: a few years ago I worked on a project with a DB2 database, and after 250 unclosed Resultsets the webapplication just could not get anymore data from the database (the application seemed to "hang"). In short: close the connections, statements and resultsets. (do it in a finally ...

79. ResultSet not working    coderanch.com

Thanks you for your reply. I forgot inform that this problem is not consistent one. it executes for someother input. any way i posted my code below. For your information, I checked with my DBA, he said that the cursor is not closed at all. its in 'executing mode'. try { connection = getConnection(super.getGatewayRouterSPQDCDS()); connection.setReadOnly(true); preparedStatement = connection.prepareStatement(sqlQuery_SUMCOLOT,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); preparedStatement.setString(1,sumcoLotID); preparedStatement.setString(2,sumcoLotID); resultSet ...

80. Can i get a clone of Resultset    coderanch.com

I am having resultsets obtained from execution of query on two different database connections. i want to work on the two result sets simultaneously. My current condition is the first connection is closed before the execution of the second query. Is there any way where i can store the first resultset without having attachment to any connection?? or can i create ...

81. How do I get a Subset of a ResultSet    coderanch.com

I am getting a result set from a remote data source. After the resultset is returned how can I do a select on the result to return a subset of records? My code: package com.drawingpdmw1; import java.sql.*; import com.ibm.as400.access.*; /** * @author sde * * TODO To change the template for this generated type comment go to * Window - Preferences ...

82. How to sort a ResultSet    coderanch.com

You *have* to modify the query to sort because JDBC may not have access to all of the data from the database within the result set at any one time. Consider query for 20 million records. JDBC will accept such a large query just fine although its not likely to give you all the records at once. The size of the ...

83. can i use the resultset simultaneously?    coderanch.com

iam using the same resultset simultaneously but iam closing it before using it next time..will it create any problem Iam getting ResultSet is closed exception... please tell me where exactly iam doing wrong...here is the code.. public String update(String studentID,String email,String address,String contactNumber) { try { rs=st.executeQuery("select count(*) from memdetails where memid='"+studentID+"'"); while(rs.next()) { counter=rs.getInt(1); } if(counter>0) { st.executeUpdate("update memdetails set ...

84. JDBC ResultSet    coderanch.com

85. Exhausted Resultset    coderanch.com

public static void main(String[] args) throws ClassNotFoundException, SQLException { // TODO Auto-generated method stub Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "123"); Statement stat = con.createStatement(); ResultSet rs; rs = stat.executeQuery("select * from Student"); while(rs.next()) { System.out.println("Student ID:: " + rs.getString("stdId")); System.out.println("Student::--:: "+"First Name:: "+ rs.getString("firstName")+" Last Name :: "+ rs.getString("lastName") ); } rs.close(); rs2= stat.executeQuery("select * from Student where firstname='Amit'"); while(rs2.next()) ...

86. resultset data stored in database or java    coderanch.com

I think all JDBC result sets are lazy loading, meaning they may not fetch all rows across the wire from the database into your memory until you scroll to a point where they're needed. That may force the database to hold some of your results in memory until you load to the end or close the resultset. I've never heard any ...

87. ResultSet    coderanch.com

I think JDBC deliberately did not give us an API for that because it would force the resultset to retrieve all the rows for counting. The number could be high enough to be a serious performance drag. Under normal use the resulset retrieves some number of rows at a time as you move the cursor into them, but not all of ...

88. which class implements Resultset    coderanch.com

89. ResultSet usage    coderanch.com

ResultSet results = null; Statement statement = null; ...... statement = connection.createStatement(); results = statement.executeQuery("select name from tableone"); if(results.next()) { int myvar = .... } results = statement.executeQuery("select food, sugar from tabletwo"); if(results.next()) { int myvar2 = .... } results = statement.executeQuery("select rock from tablethree"); if(results.next()) { int myvar3 = .... } ... //close results, statement and connection object references

90. How to use ResultSet Object    coderanch.com

I am currently working on bringing out some nice plots.To be pricise, i am using jfreechart .The user can input from and to dates and that could be even as long as one year or sometimes even 2. In such cases i will have to work with data of the order of (40,000 * 12) rows from the database say for ...

91. ResultSet.getXXX() arg - Favour column-name or column-index?    coderanch.com

So is there any other reason to prefer one over the other? Something that's not quite obvious like efficiency or overhead? Go for readability and maintainability first. Use column names where possible. Your colleagues will be thankful when they have to understand your code later. It will prevent that they have to count all fields in your query until field 48, ...

92. How to handle huge data using Resultset    coderanch.com

Hi, welcome to the ranch! A ResultSet is allowed to be lazy. (I once read that they are all lazy when they can be, but can't confirm that myself.) That is, it can pull some subset of rows from the database into its own memory. When you use next() enough times to get to the end of that chunk, it gets ...

94. Issue in getting a proper result in the ResultSet obj    coderanch.com

If someone just follows your webpages then it should be safe. However, nothing prevents him from using some command line tool or anything and making a request with his own, harmful, request parameters. If you're using GET, he doesn't even need a command line tool - he can just modify the address in the address bar!

95. Checking the results of a ResultSet    coderanch.com

I am making a connection to a remote data table. 9 times out of ten I expect to return more than one record. To get my result I use the while(rs.next()) function. But how do I check to see if there are no records returned. In situations where only one record is expected I use if(rs.next()) which works great. How do ...

96. Transform ResultSet to a Map    coderanch.com

Hello All: I have the following ResultSet reflecting a Product table: Comp_id Prod_id Prod_Desc Qty ----------- ----------- ---------------- ----- 1 1 prod_1 50 1 2 prod_2 30 1 3 prod_3 60 2 1 prod_a 30 2 2 prod_b 20 3 1 dummy1 70 3 2 dummy2 30 3 3 dummy3 50 As you can see, this table tells you ...

97. Exporting ResultSet data to MS Excel    coderanch.com

98. .getRow is slow for large ResultSet    coderanch.com

Of course it does. When you say "Find the last row", the driver must read in all the rows and store them in memory. Naturally it takes ten times as long to load 1000 rows as it does to load 100 rows. But you should really stop wanting to know how many rows there are going to be. Just read them ...

100. Passed ResultSet is not working    coderanch.com

Hello Dear Experts, In my application I have a method that takes a resultSet -which is already retrieved from a perfect-working query and statement- object through its parameters, and then take the required fields from this resultSet,but that's not working... check out my code please.. This is where I create the ResultSet in the first place and returns the indexes I ...