Stack Overflow
Stack Overflow

Questions tagged [resultset]

A result set is a set of rows from a database, which is usually generated by executing a statement that queries the database. A resultSet object maintains a cursor pointing to its current row of data.

A result set is a set of rows from a database, which is usually generated by executing a statement that queries the database. A resultSet object maintains a cursor pointing to its current row of data.

2543 questions
0
votes
0 answers

Float data type value ending with zero are pulled out in exponential notation in ResultSet

I have table in Microsoft Sql server database and it is having columns of float datatype. I am trying to retrieve the values of these column type in Java ResultSet and then using those values. Below is code for the same. while…
Gaurav Parek
  • 317
  • 6
  • 20
0
votes
1 answer

Extract resultset from stored procedure, in Java

I am executing a stored procedure in Java using the old school way: CallableStatement cs = con.prepareCall("schema.procedure("?,?,?,?"); cs.setString(1, "f"); cs.setString(2, "f"); cs.registerOutParameter(3, Types.CHAR); cs.registerOutParameter(4,…
Parameswar
  • 1,951
  • 9
  • 34
  • 57
0
votes
1 answer

How to use resultset.next method after executing result.beforeFirst in java using mysql

I need help on how to scroll back to the next record on the resultset returned by java. I'm using mysql database. Here is the code inside the formshow event. Where I load the first resultset that is being returned: if (rs.next()) { …
user225269
  • 10,743
  • 69
  • 174
  • 251
0
votes
1 answer

How to get Gemfire data into Resultset and iterate in java?

String queryString = "SELECT * FROM /items"; ClientCache cache = new ClientCacheFactory().create(); QueryService queryService = cache.getQueryService(); Query query = queryService.newQuery(queryString); SelectResults results =…
sarv m
  • 7
  • 4
0
votes
0 answers

Create CSV chunks from result set

I am trying to loop across a result set and create csv chunks by row numbers. WriteAll causing loop stopped, so only first file is filled with data. Any ideas? Thanks. PreparedStatement stmt = con.prepareStatement(query); ResultSet rs =…
DJK27
  • 1
0
votes
0 answers

Java Fetching Huge Result Set

I am having a table with huge number of records say nearly 25gb with more than 1000 million records. I want to fetch them using java and write to a csv. I thought of using java8 stream to stop bring whole result set to memory but still i am getting…
Siddharth Chaurasia
  • 293
  • 4
  • 25
0
votes
2 answers

How to extract a single value from a json encoded database table column value in Joomla?

I'm trying to get an image url from Joomla via PHP/Sql Query. It's a multidimensional array or object, but I can't get the second dimensions. What data type is that? Do I have to convert it somehow? I already tried "loadAssocList()" and…
Tdotcom
  • 145
  • 12
0
votes
1 answer

SQLite doing too many small size disk reads

Background I am using SQLite to store around 10M entries, where the size of each entry is around 1Kb. I am reading this data back in chunks of around 100K entries at a time, using multiple parallel threads. Read and writes are not going in parallel…
maneet
  • 295
  • 2
  • 10
0
votes
2 answers

How to display table name in database to JTable?

I want to get all table name which is in database and display it in JTable. It is printing: con = DriverManager.getConnection("jdbc:h2:C:/SimpleGST/GST/INVOICES","sa",""); String[] types = {"TABLE"}; DatabaseMetaData metadata =…
Karan Malhotra
  • 125
  • 3
  • 11
0
votes
1 answer

How to select from subquery if column contains a specific value in postgre

I would like to ask if it is possible to select again from a result set if a column contains a specific value? For example, from the below query I want to select it as subquery and check if that subquery's first column contains both 2 and 3 result.…
breshi
  • 25
  • 6
0
votes
3 answers

SQL Server if bit parameter = 0 return records where field has value of 0 or null

I have a large stored procedure (500+ lines) from which Carrier records are returned. One of the parameters that I pass a value to when calling this stored procedure is to be used in a where clause to filter the result set. This is a bit type…
shaneOverby
  • 60
  • 1
  • 7
0
votes
1 answer

T-SQL 2005: Suppress the output of the results set

I have some stored procedures which are used for generating Reports. I am trying to build a report dashboard that will show how many records are on each report. The SPs are detailed in a table which details in which order they should be run. I have…
Aaron Reese
0
votes
1 answer

make a nameless array out 2 diferent tables with children in php

I have 2 tables in my DB. 1 is full with numbers (foreign keys) and other one is full of the data I need. This is how the array should (exactly) look "array" : [ { "data" : "blabla" "data2" : "blabla" "children" : [ …
Sven Elmendorp
  • 39
  • 1
  • 8
0
votes
1 answer

SQL not working with ResultSet

SQL is working fine in SQL developer but when I try to use it in ResultSet its throwing Invalid Column Name error, Code: String assignList = "SELECT table1.name , table1.spads , table1.group , table1.id , max(table2.date_) ,max(table2.event) " …
chaatat
  • 65
  • 5
0
votes
0 answers

How to check if there's a ResultSet reading from a Statement in JDBC?

Sometimes I have to query database while reading from a ResultSet. Is there a way to check, for a given Statement instance, if it is occupied with a ResultSet or not? EDIT: After reading @MarkRotteveel comment, I change my question from Connection…
Minh Nghĩa
  • 854
  • 1
  • 11
  • 28
1 2 3
…
99
100