Getting a JDBC Connection Object

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.

Once 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 our 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 workspace 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();