Project

General

Profile

« Previous | Next » 

Revision 7aeac989

Added by Anahit Babadshanjan over 15 years ago

Update to SQL Server 2005.

View differences:

cdmlib-io/src/main/java/eu/etaxonomy/cdm/io/common/Source.java
29 29 
    private final static boolean DEBUG_LOG_WRITER = false;
30 30
31 31 
    //DB info
32 
	public final static String SQL_SERVER_2000 = "SQLServer2000";
32 
//	public final static String SQL_SERVER_2000 = "SQLServer2000";
33 33 
	public final static String SQL_SERVER_2005 = "SQLServer2005";
34 34 
	public final static String ACCESS = "Access";
35 35 
	public final static String EXCEL = "Excel";
......
42 42 
	public final static String SELECT_CURSOR = "cursor";
43 43
44 44 
    //driver class
45 
    private static String clsSQLServer2000 = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
45 
//    private static String clsSQLServer2000 = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
46 46 
    private static String clsSQLServer2005 = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
47 47 
    private static String clsODBC = "sun.jdbc.odbc.JdbcOdbcDriver";
48 48 
    private static String clsOracle = "oracle.jdbc.driver.OracleDriver";
......
51 51 
    private static String clsDefault = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
52 52
53 53 
    //url
54 
    private static String urlSQLServer = "jdbc:microsoft:sqlserver://";
54 
//    private static String urlSQLServer = "jdbc:microsoft:sqlserver://";
55 55 
    private static String urlSQLServer2005 = "jdbc:sqlserver://";
56 56 
    private static String urlDB2 = "jdbc:db2://";
57 57 
    private static String urlOracle = "jdbc:oracle:thin:@:1243:";
......
228 228 
	    	selectMethod = SELECT_DIRECT;
229 229 
	    try{
230 230 
	        if (DEBUG_LOG_WRITER) DriverManager.setLogWriter((new PrintWriter(System.out)));
231 
	        if (mDbms.equalsIgnoreCase(SQL_SERVER_2000)) {
232 
	            Class.forName(clsSQLServer2000);
233 
	            server = mServer + ":" + mPort;
234 
	            mUrl = urlSQLServer + server + ";DataBase=" + mDb + ";SelectMethod="+ selectMethod;
235 
	        }
231 
//	        if (mDbms.equalsIgnoreCase(SQL_SERVER_2000)) {
232 
//	            Class.forName(clsSQLServer2000);
233 
//	            server = mServer + ":" + mPort;
234 
//	            mUrl = urlSQLServer + server + ";DataBase=" + mDb + ";SelectMethod="+ selectMethod;
235 
//	        }
236 236 
	        else if (mDbms.equalsIgnoreCase(SQL_SERVER_2005)) {
237 237 
	            Class.forName(clsSQLServer2005);
238 238 
	            server = mServer + ":" + mPort;

Also available in: Unified diff