Development Tools Forum

Re: RE: JDBC uses wrong INFORMIXSERVER

Posted By: HEMANT EGROUPS
Date: Thursday, 27 October 2005, at 11:50 a.m.

In Response To: RE: JDBC uses wrong INFORMIXSERVER (Jean Georges Perrin)

Please find my code snippet below:
the INFORMIXSERVER value does not affect, I put any value for it and still the connection works


package Singletons;

import java.sql.*;
import java.util.*;

public class DB {
public final static DB DBInstance = new DB();
private static String dbURL = null;
private static Connection conn ;

private DB() {
}

public Connection getConn(String connectionURL) {
dbURL = connectionURL;
conn = getConn();
return conn;
}

public Connection getConn() {
try {
Class.forName("com.informix.jdbc.IfxDriver");
}
catch (Exception e) {
StackTraceElement[] stackElements = e.getStackTrace();
for(int i=0;i<stackElements.length;i++)
System.out.println(stackElements[i].toString()+"\n");
System.out.println("ERROR: failed to load Informix JDBC driver.");
System.out.println("Message : "+e.getMessage());
}

try {
if ( dbURL == null) {
dbURL="jdbc:informix-sqli://neosrv:1531/dev:INFORMIXSERVER=pq;USEV5SERVER=1;user=user1;password=xxx123";
System.out.println("Database url, not specified, using default"+dbURL);
}
Properties p = new Properties();
p.put("TBCONFIG","tbconfig.dev");

conn = DriverManager.getConnection(dbURL,p);
}
catch(Exception ex) {
System.out.println("Message : "+ex.getMessage());
StackTraceElement[] se = ex.getStackTrace();
for(int i=0;i<se.length;i++) {
System.out.println(se[i].toString()+"\n");
}
}
return conn;
}
}

Messages In This Thread

• JDBC uses wrong INFORMIXSERVER
  HEMANT EGROUPS -- Wednesday, 26 October 2005, at 3:06 p.m.
  • RE: JDBC uses wrong INFORMIXSERVER
    Jean Georges Perrin -- Wednesday, 26 October 2005, at 4:57 p.m.
    • Re: RE: JDBC uses wrong INFORMIXSERVER
      HEMANT EGROUPS -- Thursday, 27 October 2005, at 11:50 a.m.
  • RE: Loading a ResultSet
    Jean Georges Perrin -- Friday, 2 December 2005, at 12:01 p.m.

Development Tools Forum is maintained by Administrator with WebBBS 5.12.