2 |
26 Feb 07 |
jari |
1 |
package org.tigr.microarray.mev.cgh.DBObj; |
2 |
26 Feb 07 |
jari |
2 |
|
2 |
26 Feb 07 |
jari |
3 |
/* |
2 |
26 Feb 07 |
jari |
* ConnectionFactory.java |
2 |
26 Feb 07 |
jari |
5 |
* |
2 |
26 Feb 07 |
jari |
* Created on February 25, 2002, 1:31 AM |
2 |
26 Feb 07 |
jari |
7 |
*/ |
2 |
26 Feb 07 |
jari |
8 |
import java.sql.Connection; |
2 |
26 Feb 07 |
jari |
9 |
import java.sql.DriverManager; |
2 |
26 Feb 07 |
jari |
10 |
import java.sql.ResultSet; |
2 |
26 Feb 07 |
jari |
11 |
import java.sql.SQLException; |
2 |
26 Feb 07 |
jari |
12 |
import java.sql.Statement; |
2 |
26 Feb 07 |
jari |
13 |
import java.util.Properties; |
2 |
26 Feb 07 |
jari |
14 |
|
2 |
26 Feb 07 |
jari |
15 |
/** |
2 |
26 Feb 07 |
jari |
16 |
* |
2 |
26 Feb 07 |
jari |
* @author Adam Margolin |
2 |
26 Feb 07 |
jari |
* @author Raktim Sinha |
2 |
26 Feb 07 |
jari |
19 |
*/ |
2 |
26 Feb 07 |
jari |
20 |
|
2 |
26 Feb 07 |
jari |
21 |
public class ConnectionFactory { |
2 |
26 Feb 07 |
jari |
22 |
private static ConnectionFactory ref = new ConnectionFactory(); |
2 |
26 Feb 07 |
jari |
/** Creates new ConnectionFactory */ |
2 |
26 Feb 07 |
jari |
24 |
public ConnectionFactory() { |
2 |
26 Feb 07 |
jari |
25 |
try{ |
2 |
26 Feb 07 |
jari |
//Class.forName("com.merant.datadirect.jdbc.sqlserver.SQLServerDriver"); |
2 |
26 Feb 07 |
jari |
//Class.forName("com.inet.tds.TdsDriver"); |
2 |
26 Feb 07 |
jari |
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); |
2 |
26 Feb 07 |
jari |
//CSV Flat File JDBC Driver |
2 |
26 Feb 07 |
jari |
//Class.forName("jstels.jdbc.csv.CsvDriver"); |
2 |
26 Feb 07 |
jari |
31 |
Class.forName("com.hxtt.sql.text.TextDriver");//.newInstance(); |
2 |
26 Feb 07 |
jari |
32 |
}catch(ClassNotFoundException e){ |
2 |
26 Feb 07 |
jari |
33 |
System.out.println("ERROR: Exception loading driver class"); |
2 |
26 Feb 07 |
jari |
34 |
} |
2 |
26 Feb 07 |
jari |
35 |
} |
2 |
26 Feb 07 |
jari |
36 |
|
2 |
26 Feb 07 |
jari |
37 |
/** |
2 |
26 Feb 07 |
jari |
* Raktim |
2 |
26 Feb 07 |
jari |
* UNused |
2 |
26 Feb 07 |
jari |
* @param username |
2 |
26 Feb 07 |
jari |
* @param password |
2 |
26 Feb 07 |
jari |
* @return |
2 |
26 Feb 07 |
jari |
* @throws SQLException |
2 |
26 Feb 07 |
jari |
44 |
*/ |
2 |
26 Feb 07 |
jari |
45 |
public static Connection getConnection(String username, String password) throws SQLException{ |
2 |
26 Feb 07 |
jari |
46 |
String url = "jdbc:microsoft:sqlserver://128.91.210.174:6430"; |
2 |
26 Feb 07 |
jari |
47 |
return DriverManager.getConnection(url, username, password); |
2 |
26 Feb 07 |
jari |
48 |
} |
2 |
26 Feb 07 |
jari |
49 |
|
2 |
26 Feb 07 |
jari |
50 |
/** |
2 |
26 Feb 07 |
jari |
* Raktim |
2 |
26 Feb 07 |
jari |
* Unused |
2 |
26 Feb 07 |
jari |
* @return |
2 |
26 Feb 07 |
jari |
* @throws SQLException |
2 |
26 Feb 07 |
jari |
55 |
*/ |
2 |
26 Feb 07 |
jari |
56 |
public static Connection getConnectionTestServer() throws SQLException{ |
2 |
26 Feb 07 |
jari |
57 |
String url = "jdbc:microsoft:sqlserver://128.91.210.134:2433"; |
2 |
26 Feb 07 |
jari |
58 |
|
2 |
26 Feb 07 |
jari |
59 |
String username = "adam"; |
2 |
26 Feb 07 |
jari |
60 |
String password = "Ambystoma"; |
2 |
26 Feb 07 |
jari |
61 |
|
2 |
26 Feb 07 |
jari |
62 |
return DriverManager.getConnection(url, username, password); |
2 |
26 Feb 07 |
jari |
63 |
} |
2 |
26 Feb 07 |
jari |
64 |
|
2 |
26 Feb 07 |
jari |
65 |
/** |
2 |
26 Feb 07 |
jari |
* Raktim |
2 |
26 Feb 07 |
jari |
* Added to enable FLAT File based JDBC operations |
2 |
26 Feb 07 |
jari |
* Trial Version of Driver used. |
2 |
26 Feb 07 |
jari |
* Max queries = 25 |
2 |
26 Feb 07 |
jari |
* @return |
2 |
26 Feb 07 |
jari |
* @throws SQLException |
2 |
26 Feb 07 |
jari |
72 |
*/ |
2 |
26 Feb 07 |
jari |
73 |
public static Connection getConnectionCSV () throws SQLException { |
2 |
26 Feb 07 |
jari |
//String url = "jdbc:Text:///data"; |
2 |
26 Feb 07 |
jari |
75 |
String url = "jdbc:Text:///data/CGH"; |
2 |
26 Feb 07 |
jari |
76 |
Properties myProp = new Properties(); |
2 |
26 Feb 07 |
jari |
77 |
myProp.put("_CSV_Header","true"); |
2 |
26 Feb 07 |
jari |
78 |
return DriverManager.getConnection(url, myProp); |
2 |
26 Feb 07 |
jari |
79 |
} |
2 |
26 Feb 07 |
jari |
80 |
|
2 |
26 Feb 07 |
jari |
81 |
public static void close(ResultSet rs){ |
2 |
26 Feb 07 |
jari |
82 |
try{ |
2 |
26 Feb 07 |
jari |
83 |
rs.close(); |
2 |
26 Feb 07 |
jari |
84 |
}catch(Exception ignored){} |
2 |
26 Feb 07 |
jari |
85 |
} |
2 |
26 Feb 07 |
jari |
86 |
|
2 |
26 Feb 07 |
jari |
87 |
public static void close(Statement stmt){ |
2 |
26 Feb 07 |
jari |
88 |
try{ |
2 |
26 Feb 07 |
jari |
89 |
stmt.close(); |
2 |
26 Feb 07 |
jari |
90 |
}catch (Exception ignored){} |
2 |
26 Feb 07 |
jari |
91 |
} |
2 |
26 Feb 07 |
jari |
92 |
|
2 |
26 Feb 07 |
jari |
93 |
public static void close(Connection conn){ |
2 |
26 Feb 07 |
jari |
94 |
try{ |
2 |
26 Feb 07 |
jari |
95 |
conn.close(); |
2 |
26 Feb 07 |
jari |
96 |
}catch (Exception ignored){} |
2 |
26 Feb 07 |
jari |
97 |
} |
2 |
26 Feb 07 |
jari |
98 |
} |