Getting a JDBC Connection Object

Java Database Connectivity (JDBC) defines the standard way for Java programmers to access and manipulate data in a database. The IOM server supports IOM objects that provide all the functionality of a JDBC driver, but, instead of having to learn to program for those IOM objects, SAS Integration Technologies provides you with a JDBC implementation that uses IOM objects internally.

After you have established a connection to an IOM server and obtained a reference to a stub for the workspace component, you can get a java.sql.Connection object for the SAS JDBC Driver, as shown in the following example:

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import com.sas.iom.SAS.IDataService;
import com.sas.rio.MVAConnection;

//use Connection factory to get reference to workspace stub
//IWorkspace sasWorkspace = ...

IDataService rio = sasWorkspace.DataService();
Connection sqlConnection = new MVAConnection(rio,new Properties());
   .
   .
   .
(standard JDBC method calls)   .
   .
   .

The following example shows you how to release the connection:

sqlConnection.close();