Project

General

Profile

« Previous | Next » 

Revision 3780

Added by daigle over 16 years ago

Changes to remove ANT tokens for the turnkey install project

View differences:

upgrade_db_to_1_5.java
33 33 
import java.sql.SQLException;
34 34 
import java.sql.DriverManager;
35 35 

  		




  
  36
  
    
import edu.ucsb.nceas.metacat.MetaCatUtil;


  		




  
  37
  
    

  		




  36
  38
  
    
public class upgrade_db_to_1_5{


  		




  37
  39
  
    

  		




  38
  
  
    
    static String database = "@database@";


  		




  39
  
  
    
    static String url = "@jdbc-connect@";


  		




  40
  
  
    
    static String user = "@user@";


  		




  41
  
  
    
    static String password = "@password@";


  		




  
  40
  
    
    static String database = MetaCatUtil.getOption("databaseType");


  		




  
  41
  
    
    static String url = MetaCatUtil.getOption("defaultDB");


  		




  
  42
  
    
    static String user = MetaCatUtil.getOption("user");


  		




  
  43
  
    
    static String password = MetaCatUtil.getOption("password");


  		




  42
  44
  
    

  		




  43
  45
  
    
    public static void upgrade_xml_nodes(Connection sqlca) throws SQLException{


  		




  44
  46
  
    
        Statement sqlStatement = null;


  		




  ......




  132
  134
  
    
            Connection sqlca = null;


  		




  133
  135
  
    

  		




  134
  136
  
    
            // Create a JDBC connection to the database


  		




  135
  
  
    
            DriverManager.registerDriver(new @dbDriver@());


  		




  
  137
  
    
            if (database.equals("oracle") {


  		




  
  138
  
    
            	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());


  		




  
  139
  
    
            } 


  		




  
  140
  
    
            else if (database.equals("postgresql")) {


  		




  
  141
  
    
            	DriverManager.registerDriver(new org.postgresql.Driver());


  		




  
  142
  
    
            } 


  		




  
  143
  
    
            else if (database.equals("sqlserver")) {


  		




  
  144
  
    
            	DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());


  		




  
  145
  
    
            }


  		




  
  146
  
    
            


  		




  136
  147
  
    
            sqlca = DriverManager.getConnection(url, user, password);


  		




  137
  148
  
    

  		




  138
  149
  
    
            // Upgrade the xml_nodes table only if it oracle


  		












Also available in:  Unified diff