1. cannot retrieve values from result set (jdbc) stackoverflow.comAfter |
2. Performance issue if I do not retrieve the rest of result set coderanch.comMy result set is a huge list. And I want to reduce the data transfered between the Oracle database and my application. If I only retrieve the first few rows from the result set, and then just close the result set. Does all the data rows from the result set already transfered from Oracle to my application regardless that I didn't ... |
3. Using a Bean for Retrieving Results Sets - Best Approach coderanch.comI want to use a Bean for my DB Connections and results set by just passing in the SQL and returing a Result Set. But I'm stunped here How can I close the connection? I want to used this or a similar approach so I don't have to repeat the same code multiple times. If some one could give me a ... |
4. Retrieve huge result set from DB in chunks coderanch.comFolks, We have few SQL queries that run/retrieve for 5-8 mins and retrive 1000000 rows+. We have tried to optimize on the DB side as much as possible. Finally I think that we need to get the data in chunks, with the same query get the first 2000 rows, then with a click of next button go to the DB and ... |
5. retrieve data from huge result set coderanch.comI have a result set with 207,000 rows. Each ticket may be associated with one or more rows. I need to count the number of rows for each ticket and find the row for each ticket which has the most recent timestamp. I'm thinking that I should let the database do the sorting (use "order by") because it seems like that ... |
6. Retrieving results through views coderanch.comi am working on legacy application having the two views as A and B. View A looks as below A =========== ID || DATE || AMT View B looks like below B =========== ID || DATE || AMT The query written in view C is some thing as below select A.ID, A.DATE, A.AMT, B.AMT from A, B where A.ID=B.ID(+) and A.DATE=B.DATE(+) ... |
7. Retrieving result from a result set coderanch.comamit my database gives me the correct result . My database table has columns as :- Sno,SessionId,Count_logins,usename Can we use alias in the query and use the same alias for a column when using the result set .I mean in my case the alias is log so can i use result set as:- rs.getInt("log"); and it shoukld return me the value ... |