Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

javax.naming.Context ctx = new javax.naming.InitialContext(env);
ctx.rebind("myDataSource", ds);
Retrieving a DataSource Instance by Using JNDI and Connecting to the Data Source
Typically, the JDBC application looks up the data source JNDI name from a context object. Once
the application has the DataSource object, the application does a getConnection() call on
the data source and gets a connection.
The steps that JDBC application does to connect to and use the data source associated with the
Neoview SQL database are listed below together with the application code to perform the
operation.
1. Import the packages.
import javax.naming.*;
import java.sql.*;
import javax.sql.DataSource;
2. Create the initial context.
Hashtable env = new Hashtable();
env.put(Context.INITIAL_CONTEXT_FACTORY,
"com.sun.jndi.fscontext.RefFSContextFactory");
try
{
Context ctx = new InitialContext(env);
} catch( ... ) { ... }
3. Look up the JNDI name associated with the data source myDataSource, where
myDataSource is the logical name that will be associated with the real world data source
– server.
DataSource ds = (DataSource)ctx.lookup("myDataSource");
4. Create the connection using the data source.
con = ds.getConnection();
5. Do work with the connection. The following statements are just a simple example.
stmt = con.createStatement();
try
{
stmt.executeUpdate("drop table tdata");
}
catch (SQLException e) {}
Specifying the Properties File that Configures the Data Source
To use the properties file method to configure a DataSource object, the properties file must
exist on disk and contain the property_name=property_value pairs that configure the data
source. See “Creating and Using a Properties File” (page 38) for more information about creating
this file.
When the JDBC application makes the connection, the application should pass the properties
file as a command-line parameter:
java -Dhpt4jdbc.properties=path_of_properties_file_on_disk
Connection by Using the DriverManager Class
The java.sql.DriverManager class is widely used to get a connection, but is less portable
than the DataSource class. The DriverManager class works with the Driver interface to
manage the set of drivers loaded. When an application issues a request for a connection using
the DriverManager.getConnection method and provides a URL, the DriverManager
24 Accessing Neoview SQL Databases