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 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)
     .
     .
     .

     sqlConnection.close();