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

Resultset update not wokring even after using update statement

I saw many answers related to this , and I used one given on stackoverflow of using update prepared statement, but issue still persists. Getting below error com.mysql.cj.jdbc.exceptions.NotUpdatable: Result Set not updatable (references computed…
Muddassir Rahman
  • 976
  • 1
  • 9
  • 20
0
votes
1 answer

How to convert database result sets into xml file using spring batch

I have spring batch config xml as below .If I use row mapper method ,it processing one result set at a time. but I need to process 10 result set to make into one xml file. The first half of the result set going to contain same results for all the…
juniper
  • 11
  • 2
  • 4
0
votes
2 answers

How can I convert a huge Resultset of 10 million records to a list in java?

I am trying to fetch the resultset into a Set so that I can remove the duplicates and put it in a separate table to ease out the sanitizing process . But when I try using this : while (rs.next()) { set.add(new ABC(rs.getString(1),…
Meht4409
  • 11
  • 2
0
votes
1 answer

How can I return a ResultSet?

I would like to ask for help. I need the method to return results. But I get an exception: java.sql.SQLException: Operation not allowed after ResultSet closed public class A implements AutoCloseable { protected Connection getConnection() { …
Kuba
  • 413
  • 3
  • 6
  • 18
0
votes
0 answers

Can't use multiple user in one login

Ive got 2 database in my mysql db, when im entering the first row which is the "username" and the password is "password" it is going accordingly. But when im entering the second row, it says incorrect password Here is my code: public void tlogin()…
user12466727
0
votes
2 answers

Getting the size (in bytes) of the ResultSet using java code

How to get the size(in bytes) of the given ResultSet within the java code. Is there any direct way to find out?
Bhaskara Krishna Mohan Potam
  • 45
  • 1
  • 3
  • 9
0
votes
2 answers

Why does MySQL database return empty ResultSet although data should be correct

Context: I have 2 different tables in my database. First is actionblock (ActionBlock in Java) and the second one is location (PermanentLocation in Java). The ActionBlock class needs a location to work, so in order for the code to work it first…
Nuubles
  • 165
  • 1
  • 13
0
votes
0 answers

How to apply MapReduce for ResultSet?

I'm using Hive to select million records using JDBC now I want to work with the ResultSet to write my OWL file how can I apply this scenario using MapReduce? Note: in case of no , I also have the database in mysql, can I work with resultset with…
Sarah S. Abulwafa
  • 21
  • 3
0
votes
1 answer

Effective resultset structure in case of Inner Join on more than two tables

I was going through this link to see how the effective resultset looks like if we join (Inner/Outer) two tables. I was just curious to know how the resultset looks like, If we perform Inner/Outer join on more than two tables? Let's say I've three…
Vicky
  • 5,380
  • 18
  • 60
  • 83
0
votes
2 answers

TSQL -- display results of two queries on one row in SSMS

I am using TSQL, SSMS v.17.9.1 The underlying db is Microsoft SQL Server 2014 SP3 For display purposes, I want to concatenate the results of two queries: SELECT TOP 1 colA as 'myCol1' FROM tableA -- SELECT TOP 1 colB as 'myCol2' FROM tableB and…
JosephDoggie
  • 1,514
  • 4
  • 27
  • 57
0
votes
1 answer

In BeautifulSoup / Python, how do I extract a single element from a result set?

I'm using Python 3.7 and BeautifulSoup 4. I'm having a problem getting text from an element. I'm trying this req = urllib2.Request(fullurl, headers=settings.HDR) html = urllib2.urlopen(req, timeout=settings.SOCKET_TIMEOUT_IN_SECONDS).read() bs =…
Dave
  • 15,639
  • 133
  • 442
  • 830
0
votes
1 answer

Read Blob file without saving it a file

I have planned to encrypt a string using a public key which is stored in a database as Blob.I have created method called readBlob() to read the key and save it to the file. public static void readBlob(int userid, String filename) throws…
Rahul
  • 35
  • 8
0
votes
3 answers

Stored procedure in SQL Server does not return a result set when called by java

I have the following stored procedure and my goal is to return a result set from it, using the query "select * from #justTmp" create procedure spAddPerson @ID int, @Name nvarchar(50) as begin create table #justTmp ( num int…
Ori Lev
  • 31
  • 5
0
votes
1 answer

Compare ResultSet.getString value to an input from textfield

Whenever I press log-in it shows the catch message. tried setting it to ResultSet.getString(name of column in access).equal(value of textfield) b1.addActionListener(new ActionListener () { public void…
user12205426
0
votes
1 answer

Java resultset rowmapper

package dao; import java.sql.ResultSet; import java.sql.SQLException; import org.krams.tutorial.oxm.SubscriptionRequest; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport; public…
Jaanus
  • 16,161
  • 49
  • 147
  • 202
1 2 3
…
99 100