JDBC连接Informix IDS

Informix 的JDBC驱动是type 4的方式

1.环境说明

OS: Windows XP

Informix: IDS V10.00.TC1

JDBC: Informix JDBC Embedded SQLJ V2.20JC2

2.JDBC配置

安装完Informix JDBC后把ifxjdbc.jar路径加到CLASSPATH环境变量中，比如CLASSPATH=C:\ifxjava_home\lib\ifxjdbc.jar;....

在安装完后的目录中有doc目录，里面有详细的文档说明。还有demo目录，里面有可以参考的源代码

3.DEMO代码

下面的源代码，是参考了(\doc\release\oij_jdbc_migration.html)

通过Java使用JDBC连接IDS V10.0

import java.sql.*;

import java.util.*;

public class ifx_con

{

public static void main(String[] args)

{

Connection conn;

String url = "jdbc:informix-sqli://IBM-HENRY:1526/sample:informixserver=ol_henry;user=henry;password=happyday";

System.out.println("Informix JDBC connect test.");

try

{

// Load the Informix JDBC Driver

//DriverManager.registerDriver((Driver) Class.forName("com.informix.jdbc.IfxDriver").newInstance());

Class.forName("com.informix.jdbc.IfxDriver");

//Create and open a server/database connection

conn = DriverManager.getConnection(url);

System.out.println("JDBC driver name: " + conn.getMetaData().getDriverName());

//Queries that return more than one row

Statement query = null;

ResultSet rs = null;

String st = new String();

try

{

query = conn.createStatement();

rs = query.executeQuery("select * from customer");

while (rs.next())

{

System.out.println(rs.getString(2));

}

rs.close();

query.close();

}

catch (SQLException exce)

{

System.out.println("Caught: " + exce.getErrorCode());

}

conn.close();

}

catch (ClassNotFoundException drvEx)

{

System.err.println("Could not load JDBC driver");

System.out.println("Exception: " + drvEx);

drvEx.printStackTrace();

}

catch(SQLException sqlEx)

{

while(sqlEx != null)

{

System.err.println("SQLException information");

System.err.println("Error msg: " + sqlEx.getMessage());

System.err.println("SQLSTATE: " + sqlEx.getSQLState());

System.err.println("Error code: " + sqlEx.getErrorCode());

sqlEx.printStackTrace();

sqlEx=sqlEx.getNextException();

}

}

}

}