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.

learn more…| top users | synonyms

0
votes
1answer
26 views

Why rsmd.getColumnClassName(index) showing strange results

I am trying to pull data from Oracle EMP Table through Java( Added one extra column to original table with Data type as TIMESTAMPTZ) .While I try to find the Data types through java using below ...
-2
votes
1answer
24 views

ResultSet not adding data to List in Java [closed]

I am currently creating a senior project that uses a list to display information from a database using SQL Statements. This code is supposed to take data from the database and use the "rs" variable, ...
1
vote
3answers
47 views

Working with Java String and ResultSet Object Dynamically

I would like to fetch data from Database Table A and create an insert statement to load Table B.To preserving the data type, I am creating a one Time statament using the ResultSet methods to read ...
-2
votes
0answers
29 views

Convert Java Resultset to XML file and put that XML in StringBuffer object [closed]

I have a JDBC query which when executed gives me a result set. I need to create an XML file out of that result set based on various business rules and then put contents of that XML in a StringBuffer ...
0
votes
1answer
20 views

Spring JDBCTemplate Stored Procedure with ResultSet and OutPut Parameter

I created a stored procedure which returns result rows and two output parameters.I am unable to find any thing in spring from which i can get ResultSet and outPutParameters.I want to achieve ...
-5
votes
1answer
24 views

insert data through resultSet and executeupdate() is not possible

I am developing application as shown in image. When I use ResutSet with executeupdate() it shows error and I need to bring another form after successful entry.What is I am do wrong? And how to solve ...
0
votes
1answer
25 views

Query / Code not returning required result

Following is my code, I am passing stateid and on basis of stateid I am retrieving data from table base_path.The code works fine for the first iteration i.e. for stateid=1 it returns one result ...
0
votes
0answers
23 views

Populating JComboBox with single column ResultSet from MySQL

I've seen some examples of this question and followed them but at this point I can't figure what I am doing wrong. I am using this to try to populate a JComboBox with results from a stored procedure ...
0
votes
1answer
54 views

ResultSet is not null yet resultset.next() returns false

I'm trying to search tables based on a certain criteria. The SQL query returns the correct result(1 row) when executed in SQL Developer. In JDBC, resultset is not null yet resultset.next() returns ...
0
votes
1answer
36 views

ResultSet.next() does not retrieve rows

My code is about to access my database "toursdb" and get some result. I am using the command line and javadb. When I use con.getMetaData I do have results. Same when I use rs.getMetaData. I don't have ...
-1
votes
1answer
59 views

Select multirows from ORACLE table function in JAVA code

In ORACLE(11g), in some package I have a function that returning table:SELECT * FROM TABLE( my_PKG.fnc_myList());So it works perfectly in Oracle SQL Developer tool, for example. I got rows from ...
2
votes
1answer
31 views

sql server stored proc, can't get result set back in java

I have created a stored proc in a sql server db that appears to be executing properly for one record. The code is shown below:try {String className="com.microsoft.sqlserver.jdbc....
0
votes
1answer
18 views

MySQL - Sort certain conditions last in the result set (Unions maybe?)

I have a certain query, I need to get basically two rows with certain ids. At first I used where id=x or id=y. However I need to get the second parameter last in the result set. I came across with ...
3
votes
3answers
64 views

Getting all results from ResultSet

I am getting a ResultSet of type ArrayList<MyClass> and all is working well, except it's not getting the first item from the list.It seems this part is actually taking the first option and ...
0
votes
2answers
29 views

pl/pgsql does not return all the results using record

I am trying to create a complicated pl/pgsql function that gathers some results from a query and then checks each one and returns it or not.This is my code so far. The record and loop part confuse ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,