Java 连接到InterSystems IRIS数据库 - 使用 JDBC
连接前准备:
- Java 开发环境
- InterSystems JDBC 驱动
- Connection String
步骤:
- 配置 Classpath :指向InterSystems JDBC 驱动 - intersystems-jdbc-3.0.0.0.jar
- Connection String,其中import com.intersystems.jdbc*;用来导入驱动,User是命名空间名称。
import com.intersystems.jdbc*; import java.sql.Connection; public class JDBCConnection{ public static void main (String[] args) throws Exception { String dbUrl = "jdbc:IRIS://127.0.0.1:1972/User"; //replace String user = "SQLAdmin"; String pass = "deployment-password"; IRISDataSource ds = new IRISDataSource(); ds.setURL(dbUrl); ds.setUser(user); ds.setPassword(pass); Connection dbconnection = ds.getConnection(); System.out.println("Connected to InterSystems IRIS via JDBC."); } }