SAS中文论坛

标题: 怎么用JDBC连接SAS数据库？？ [打印本页]

作者: shiyiming 时间: 2011-1-7 10:03
标题: 怎么用JDBC连接SAS数据库？？
怎么用JDBC连接SAS数据库？？能否给我介绍一下？我的邮箱：itibm@126.com

作者: shiyiming 时间: 2011-1-10 12:21
标题: Re: 怎么用JDBC连接SAS数据库？？
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)
   .
   .
   .

The following example shows you how to release the connection:
   sqlConnection.close();

以上参考一下，个人认为可能还是需要SAS/SHARE的支持。

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)