Top "Resultset" questions

How can I identify columns when SELECTing from multiple tables with JDBC?

I have two tables that I join on the id-column, they look like: +-------+ | users | +----+--+---+ | id | name | +…

sql jdbc join resultset javadb

can not use resultSet.setFetchDirection(ResultSet.TYPE_SCROLL_SENSITIVE) with spring jdbc DaoSupport with Oracle

I want to use scrollable resultset, so when I use two lines of code: rs.setFetchDirection(ResultSet.TYPE_SCROLL_SENSITIVE); …

java oracle resultset spring-jdbc scrollableresults

Get MySQL Query Results as Their Native Data Type?

I have tried fetching MySQL query results using mysql_fetch_row() and mysql_result() and numeric values are being returned …

php mysql resultset types

Connection behavior - DriverManager.getConnection() and DataSource.getConnection()

If I get a connection object using DriverManager.getConnection() and DataSource.getConnection(), how they differ in behavior when .close() is …

java jdbc connection resultset

How can I see the content of a ResultSet object inspecting it using the Eclipse debugger?

I have the following problem using the Eclipse debugger. I have to inspect a ResultSet rs object containing some rows …

java eclipse debugging ide resultset

JDBC: How to clear the contents of a result set before using it again?

I want to clear the contents of a result set (but nothing should happen to the underlying database) before using …

java mysql jdbc resultset multiple-resultsets

Get a BigInteger attribute from Cassandra ResultSet

I'm trying to get the number of key value pairs in a Cassandra column family. Following is the code I …

java cassandra resultset biginteger datastax

How to iterate over ResultSet by using MySql Stored Procedure with "select" keyword?

here is my Java method: public static List<Company> selectCompanies() { List<Company> companies=new ArrayList<…

java mysql stored-procedures resultset callable-statement

How to execute procedure returning resultset in Firebird

I have the following table create table LIST_PIPE_TABLE ( ID INT, ITEM VARCHAR(4000), IS_FOLDER VARCHAR(10) ) with 3 rows of …

firebird resultset procedure execute suspend

String Index out of range Exception in jdbc programming

I have a database table consisting of 6 columns and 6 rows. I want to access all 6 column values of the 2nd …

java ms-access resultset jdbc-odbc