How to connect Informix using JDBC?
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Java & JDBC Development
Hello everyone. I want to connect INFORMIX using JDBC. But I can't connect. My environment is following. - DBMS : INFORMIX UNIVERSAL SERVER 9.12 which works on WinNT4.0 - JDBC driver which is contained client SDK 2.0 and My connection code is following. ////////////////////////////////////////////////// import java.net.URL; import java.sql.*; import java.lang.*; public class test { public static void main(String argv[]) { System.out.println("Establishing Connection - Please Wait..."); try { Class.forName("informix.api.jdbc.JDBCDriver"); }catch (ClassNotFoundException e) { System.out.println("Error: Class Not Found " + e); System.exit(1); } System.out.println("Suc Class.forName "); // GET CONNECTION java.sql.Connection con; try{ java.util.Properties props=new java.util.Properties(); //props.put("charset","KSC5601"); //props.put("dbEncoding","KSC5601"); props.put("user","informix"); props.put("password","*****"); props.put("server","pinesoc"); props.put("database","stores7"); con=java.sql.DriverManager.getConnection("jdbc:informix://pine.chungnam.ac.kr:1400/stores7", props); }catch(Exception e){ System.out.println("Error:" + e); //This Exception Statement is executed } } } /////////////////////////////////////////////////////////////// When I execute it, D:\\java>javac test.java D:\\java>java test Establishing Connection - Please Wait... Suc Class.forName Error:java.sql.SQLException: No suitable driver But I don't know what is wrong. Is there anyone who knows it? Please give me a sample code. Please let me know it. Thank for your reading. H.S.Lee