Connexion à informix
Résolu/Fermé
A voir également:
- Connexion à informix
- Gmail connexion - Guide
- Hotmail connexion - Guide
- Facebook connexion - Guide
- Coco.fr connexion - Forum Réseaux sociaux
- Cette option de connexion est désactivée en raison des échecs des tentatives de connexion - Forum PC portable
2 réponses
Ici un code qui fait une connexion a informix. Pardon à mon francais. J'ai emprunté le code de "demo" trouvé a C:\Program Files\IBM\Informix_JDBC_Driver\demo\basic\DBConnection.java.
Le code exige que CLASSPATH qui contient le "jar" ifxjdbc.jar. Ou, on peut ajoute un parameter "-cp" ou "-classpath" et le nom de ifxjdbc.jar, comme l'example suivante.
Le code exige en tout cas un parameter, le URL de connexion. Par example:
J'espere que cela vous aide,
- Donald
/************************************************************************** * * Licensed Materials - Property of IBM Corporation * * Restricted Materials of IBM Corporation * * IBM Informix JDBC Driver * (c) Copyright IBM Corporation 1998, 2004 All rights reserved. * ****************************************************************************/ /*************************************************************************** * * Title: DBConnectSample.java * * Description: Demo a connection to a database of a particular server * * An example of running the program: * * java DBConnectSample * 'jdbc:informix-sqli://myhost:1533/myDBname:informixserver=myserver;user=<username>;password=<password>' * * Expected result: * * >>>Database Connection Direct test. * URL = "jdbc:informix-sqli://myhost:1533/myDBname:informixserver=myserver;user=<username>;password=<password>" * >>>End of Database Connection Direct test. * >>>Database Connection Indirect test. * URL = "jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=<username>;password=<password>" * >>>End of Database Connection Indirect test. * *************************************************************************** */ import java.sql.*; import java.util.*; public class DBConnectSample { public static void main(String[] args) { String usage = "Example: 'jdbc:informix-sqli://myhost:1533/myDBname:informixserver=myserver;user=<username>;password=<password>'"; if (args.length == 0) { System.out.println("FAILED: connection URL must be provided in order to run the demo!"); System.out.println(usage); return; } String url = args[0]; StringTokenizer st = new StringTokenizer(url, ":"); String token; String tokens[] = new String[5]; StringTokenizer portDbSt; String portDbTokens[] = new String [2]; String newUrl = ""; for (int i = 0; i < 5; ++i) { if (!st.hasMoreTokens()) { System.out.println("FAILED: incorrect URL format!"); System.out.println("URL ,'" + url + "', should have 5 parts separated by colons ':', but has only " + i + " parts"); System.out.println(usage); return; } tokens[i] = st.nextToken(); // Handle database name in port-DB part of URL, e.g. "1533/myDBname" if (i == 3) { portDbSt = new StringTokenizer(tokens[i], "/"); for (int j = 0; j < 2; ++j) { if (!portDbSt.hasMoreTokens()) { System.out.println("FAILED: incorrect URL format!"); System.out.println("port-DB part of URL, '" + tokens[i] + "', should have 2 parts, port and database name, separated by forward slash '/', but has only " + j + " parts"); System.out.println(usage); return; } portDbTokens[j] = portDbSt.nextToken(); } } if (newUrl != "") newUrl += ":"; newUrl += tokens[i]; } if (st.hasMoreTokens()) { System.out.println("URL ,'" + url + "', should have only 5 parts separated by colons ':', but has a 6th part, '" + st.nextToken() + "'"); return; } //INFORMIX_EXTEXT_BEGIN DBConn1.jav String cmd = null; int rc; //INFORMIX_EXTEXT_END DBConn1.jav String testName = "Database Connection Direct"; //INFORMIX_EXTEXT_BEGIN DBConn2.jav Connection conn = null; //INFORMIX_EXTEXT_END DBConn2.jav System.out.println(">>>" + testName + " test."); System.out.println("URL = \"" + newUrl + "\""); //INFORMIX_EXTEXT_BEGIN DBConn3.jav try { Class.forName("com.informix.jdbc.IfxDriver"); } catch (Exception e) { System.out.println("FAILED: failed to load Informix JDBC driver."); System.out.println("FAILED: " + e.getMessage()); return; } try { conn = DriverManager.getConnection(newUrl); } catch (SQLException e) { System.out.println("FAILED: failed to connect!"); System.out.println("FAILED: " + e.getMessage()); return; } //INFORMIX_EXTEXT_END DBConn3.jav try { conn.close(); } catch (SQLException e) { System.out.println("FAILED: failed to close the connection!"); System.out.println("FAILED: " + e.getMessage()); return; } System.out.println(">>>End of " + testName + " test."); newUrl = tokens[0] + ":" + tokens[1] + ":" + tokens[2] + ":" + portDbTokens[0] + ":" + tokens[4]; testName = "Database Connection Indirect"; conn = null; System.out.println(">>>" + testName + " test."); System.out.println("URL = \"" + newUrl + "\""); try { Class.forName("com.informix.jdbc.IfxDriver"); } catch (Exception e) { System.out.println("FAILED: failed to load Informix JDBC driver."); System.out.println("FAILED: " + e.getMessage()); return; } try { conn = DriverManager.getConnection(newUrl); } catch (SQLException e) { System.out.println("FAILED: failed to connect!"); System.out.println("FAILED: " + e.getMessage()); return; } //INFORMIX_EXTEXT_BEGIN DBConn4.jav try { Statement stmt = conn.createStatement(); cmd = "database " + portDbTokens[1] + ";"; System.out.println("Execute statement \"" + cmd + "\"..."); rc = stmt.executeUpdate(cmd); stmt.close(); } catch (SQLException e) { System.out.println("FAILED: execution failed - statement: " + cmd); System.out.println("FAILED: " + e.getMessage()); return; } //INFORMIX_EXTEXT_END DBConn4.jav try { conn.close(); } catch (SQLException e) { System.out.println("FAILED: failed to close the connection!"); System.out.println("FAILED: " + e.getMessage()); return; } System.out.println(">>>End of " + testName + " test."); return; } }
Le code exige que CLASSPATH qui contient le "jar" ifxjdbc.jar. Ou, on peut ajoute un parameter "-cp" ou "-classpath" et le nom de ifxjdbc.jar, comme l'example suivante.
Le code exige en tout cas un parameter, le URL de connexion. Par example:
java -cp ..\..\lib\ifxjdbc.jar;..\..\..\Java50\jre\lib\core.jar DBConnectSample.class jdbc:informix-sqli://myhost:9088/mydb:informixserver=ol_svr_custom;user=informix;password=in4mix myhost == hostname 9088 == port auquel informix ecoute mydb == nom de base de donnés ol_svr_custom == INFORMIXSERVER (dans onconfig ou SetNet32) informix == nom do utilisateur de base de donnés in4mix == password ou clé
J'espere que cela vous aide,
- Donald