This section describes how to connect a JdbcRowSet object to a database server with a connection URL.
If a JdbcRowSet object is created without a connection to the database server,
you can provide a connection URL string by calling the setUrl() method.
A connection object will be created later by the JdbcRowSet object with DriverManager when you call the execute() method.
Here is a sample sequence of method calls:
// Creating a JdbcRowSet object wihout connection
JdbcRowSet jrs = new JdbcRowSetImpl();
// Provide a connection URL for future use
jrs.setUrl("connection_url");
// Provide a SQL statement for future use
jrs.setCommand("SQL_statement");
// Create a connnection using DriverManager
// Execute the SQL statement
jrs.execute();
Note that the name of method setUrl() is very confusing with another method setURL(), which sets a URL value to a parameter.
Note also that the connection URL and user information can also be provided through another constructor:
JdbcRowSet jrs = new JdbcRowSetImpl("connection_url",
"user", "password");
To test connection method, I wrote the following tutorial program:
/**
* OracleRowSetConnectionUrl.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class OracleRowSetConnectionUrl {
public static void main(String [] args) {
try {
// Load the JDBC driver class. Needed for JDBC 3.0 drivers
Class.forName("oracle.jdbc.OracleDriver") ;
// Get a new JdbcRowSet object with Run's implementation
javax.sql.rowset.JdbcRowSet jrs
= new com.sun.rowset.JdbcRowSetImpl();
// Set the connection URL for the DriverManager
jrs.setUrl(
"jdbc:oracle:thin:Herong/TopSecret@//localhost:1521/XE");
// 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 resource
jrs.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}
Make sure the Oracle server is running on the local machine, then run this program.
The result confirms that the connection is working.
C:\>javac OracleRowSetConnectionUrl.java
OracleRowSetConnectionUrl.java:15:
warning: com.sun.rowset.JdbcRowSetImpl is Sun proprietary API
and may be removed in a future release
= new com.sun.rowset.JdbcRowSetImpl();
^
1 warning
C:\>java -cp .;\local\lib\ojdbc14.jar OracleRowSetConnectionUrl
Result: Hello world!
Notice that a warning message was given at the compilation time.
Also notice that class com.sun.rowset.JdbcRowSetImpl seems to be included in JDK 1.6 package,
because I executed the program successfully without including rowset.jar file in the classpath.
