Connecting JdbcRowSet with a Predefined Connection Object

This section describes how to connect a JdbcRowSet object to a database server with a predefined connection object.

Another way to connect a JdbcRowSet object to a database server is to pass a predefined connection object to the JdbcRowSetImpl constructor. Here is a sample sequence of method calls:

/* OracleRowSetConnectionObject.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class OracleRowSetConnectionObject {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Create a Connection object
      Class.forName("oracle.jdbc.OracleDriver") ;
      con = DriverManager.getConnection(
        "jdbc:oracle:thin:Herong/TopSecret@//localhost:1521/XE");

// Pass the Connection object to the new JdbcRowSet object
      javax.sql.rowset.JdbcRowSet jrs
        = new com.sun.rowset.JdbcRowSetImpl(con);

// Set a SQL statement
      jrs.setCommand("SELECT 'Hello world!' FROM DUAL");

// Connect and run the statement
      jrs.execute();

// Get the result
      jrs.next();
      System.out.println("Result: "+jrs.getString(1));

// Close resources
      jrs.close();
      con.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

If you try to compile the sample program with JDK 17, you will get an error:

herong> javac OracleRowSetConnectionObject.java

temp/OracleRowSetConnectionObject.java:17: 
  error: package com.sun.rowset is not visible
        = new com.sun.rowset.JdbcRowSetImpl(con);
                     ^
  (package com.sun.rowset is declared in module java.sql.rowset, 
    which does not export it)
1 error
error: compilation failed

If you are still using JDK 1.8, you can continue to use the sample program:

herong> \Progra~1\java\jdk1.8.0_45\bin\javac
   -cp .;ojdbc6.jar OraclePreparedSelect.java

OracleRowSetConnectionObject.java:17:
warning: com.sun.rowset.JdbcRowSetImpl is Sun proprietary API
and may be removed in a future release
        = new com.sun.rowset.JdbcRowSetImpl(con);
                            ^
1 warning

herong> \Progra~1\java\jdk1.8.0_45\bin\java \
   -cp .;ojdbc6.jar OraclePreparedSelect

Result: Hello world!

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

Oracle - Reference Implementation of JdbcRowSet

 Overview of RowSet Objects

 Installation of JdbcRowSet Reference Implementation

 Connecting JdbcRowSet to Database Servers

 Connecting JdbcRowSet with a Connection URL

Connecting JdbcRowSet with a Predefined Connection Object

 Connecting JdbcRowSet with a Predefined ResultSet Object

 Connecting JdbcRowSet with JNDI Directory Service

 JdbcRowSet Query Statement with Parameters

 Inserting Rows with JdbcRowSet Objects

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 Using Connection Pool with JDBC

 Archived Tutorials

 References

 Full Version in PDF/EPUB