1. Add external jar for jfxjdbc.jar to Java Build Path.
2. Coding:
package db;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.*;
public class jdbc_informix
{
public static void main(String[] args) throws IOException
{
Connection conn = null;
String userName = "xx";
String password = "xx";
String url = "jdbc:informix-sqli://db.test.ps:1111/table_name:INFORMIXSERVER=table_n";
try
{
Class.forName("com.informix.jdbc.IfxDriver");
System.out.println("Driver OK");
}
catch (Exception e)
{
System.out.println("FAILED: failed to load Informix JDBC driver.");
}
try
{
conn = DriverManager.getConnection(url, userName, password);
System.out.println ("Database connection established");
Statement s = conn.createStatement ();
s.executeQuery ("select * from table_name");
ResultSet rs = s.getResultSet ();
if (rs.next ())
{
String nameVal = rs.getString 1);
System.out.println(nameVal);
}
else
System.out.println("error");
}
catch (SQLException e)
{
System.out.println("FAILED: failed to connect!"+e);
}
}
private static void dispValue(InputStream value) {
// TODO Auto-generated method stub
}
}
