JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

Programmatically Registering the DataSource Object
In the following example, the code shows how to register, programmatically, the
SQLMXDataSource object ds that was created using the preceding code with JDNI.
java.util.Hashtable env = new java.util.Hashtable();
env.put(Context.INITIAL_CONTEXT_FACTORY, "Factory class name here");
javax.naming.Context ctx = new javax.naming.InitialContext(env);
ctx.rebind("myDataSource", ds);
Retrieving a DataSource Instance by using JNDI and to the Data Source
Typically, the JDBC application looks up the data source JNDI name from a context object. After
the application has the DataSource object, the application makes a getConnection() call
on the data source and gets a connection.
To connect to and use the data source associated with the SQL/MX database, the JDBC application
performs the following steps are listed 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
– MXCS server.
DataSource ds = (DataSource)ctx.lookup("myDataSource");
4. Using the data source, create the connection.
con = ds.getConnection();
5. Do work with the connection. The following statements are an 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 37) 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 -Dt4sqlmx.properties=file_location ...
All the above said properties and configuration are applicable to the SQLMX XADataSource objects
participating in distributed transactions.
Connecting to SQL/MX 23