JDBC for MySQL - Herong's Tutorial Examples - v3.13, by Herong Yang
Connecting JdbcRowSet with JNDI Directory Service
This section describes how to connect a JdbcRowSet object to a database server using JNDI directory service to lookup DataSource name.
If a JdbcRowSet object is created without a Connection object, you can provide a DataSource name to the JdbcRowSet object so that it can use a JNDI directory service to lookup a DataSource object by name. The DataSource object will be then used to create a connection object. See the sample statements below:
// Create a JdbcRowSet object without any connection JdbcRowSet jrs = new JdbcRowSetImpl(); // Set the DataSource name for JNDI lookup jrs.setDataSourceName("jdbc/mysqlDS"); // Set a SQL statement jrs.setCommand("SELECT 'Hello world!'"); // Lookup, connect and run the statement jrs.execute();
I wrote the following sample to connect a JdbcRowSet object using a JNDI directory service:
/* MySqlRowSetDataSource.java * Copyright (c) HerongYang.com. All Rights Reserved. */ import java.sql.*; import javax.sql.rowset.RowSetProvider; import javax.sql.rowset.JdbcRowSet; public class MySqlRowSetDataSource { public static void main(String [] args) { Connection con = null; try { // RowSetFactory should be used now // JdbcRowSet jrs // = new com.sun.rowset.JdbcRowSetImpl(); JdbcRowSet jrs = RowSetProvider.newFactory().createJdbcRowSet(); // Set the DataSource name for JNDI lookup jrs.setDataSourceName("jdbc/mysqlDS"); // Set a SQL statement jrs.setCommand("SELECT 'Hello world!'"); // Connect and run the statement jrs.execute(); // Get the result jrs.next(); System.out.println("Result: "+jrs.getString(1)); // Close resources jrs.close(); } catch (Exception e) { System.err.println("Exception: "+e.getMessage()); e.printStackTrace(); } } }
But I failed to set up the JNDI directory service. So I got an exception when running this program:
Exception: JdbcRowSet (connect) JNDI unable to connect java.sql.SQLException: JdbcRowSet (connect) JNDI unable to connect at com.sun.rowset.JdbcRowSetImpl.connect(JdbcRowSetImpl.java:634) at com.sun.rowset.JdbcRowSetImpl.prepare(JdbcRowSetImpl.java:654) at com.sun.rowset.JdbcRowSetImpl.execute(JdbcRowSetImpl.java:556) at MySqlRowSetDataSource.main(MySqlRowSetDataSource.java:25)
Table of Contents
JDBC (Java Database Connectivity) Introduction
MySQL JDBC Driver (MySQL Connector/J)
►MySQL - Reference Implementation of JdbcRowSet
Connecting JdbcRowSet to Database Servers
Sun Implementation of JdbcRowSet API
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
MySQL - JBDC CallableStatement
MySQL CLOB (Character Large Object) - TEXT
MySQL BLOB (Binary Large Object) - BLOB