Project

General

Profile

« Previous | Next » 

Revision 94

Added by Matt Jones over 24 years ago

fixed transformation problems

View differences:

src/edu/ucsb/nceas/metacat/DBTransform.java
94 94 
    try {
95 95 
      pstmt =
96 96 
        conn.prepareStatement("SELECT system_id " +
97 
                "FROM xml_catalog_entities " +
98 
                "WHERE source_doctype LIKE ? " +
99 
                "AND target_doctype LIKE ? " +
100 
                "AND entity_type LIKE ?");
97 
                "FROM xml_catalog " +
98 
                "WHERE entity_type LIKE ? " +
99 
                "AND source_doctype LIKE ? " +
100 
                "AND target_doctype LIKE ? ");
101 101 
      // Bind the values to the query
102 
      pstmt.setString(1, sourcetype);
103 
      pstmt.setString(2, targettype);
104 
      pstmt.setString(3, objecttype);
102 
      pstmt.setString(1, objecttype);
103 
      pstmt.setString(2, sourcetype);
104 
      pstmt.setString(3, targettype);
105 105 

  		




  106
  106
  
    
      pstmt.execute();


  		




  107
  107
  
    
      try {


  		












  

    
      DBTransform.java
    
  





  94
  94
  
    
    try {


  		




  95
  95
  
    
      pstmt =


  		




  96
  96
  
    
        conn.prepareStatement("SELECT system_id " +


  		




  97
  
  
    
                "FROM xml_catalog_entities " +


  		




  98
  
  
    
                "WHERE source_doctype LIKE ? " +


  		




  99
  
  
    
                "AND target_doctype LIKE ? " +


  		




  100
  
  
    
                "AND entity_type LIKE ?");


  		




  
  97
  
    
                "FROM xml_catalog " +


  		




  
  98
  
    
                "WHERE entity_type LIKE ? " +


  		




  
  99
  
    
                "AND source_doctype LIKE ? " +


  		




  
  100
  
    
                "AND target_doctype LIKE ? ");


  		




  101
  101
  
    
      // Bind the values to the query


  		




  102
  
  
    
      pstmt.setString(1, sourcetype);


  		




  103
  
  
    
      pstmt.setString(2, targettype);


  		




  104
  
  
    
      pstmt.setString(3, objecttype);


  		




  
  102
  
    
      pstmt.setString(1, objecttype);


  		




  
  103
  
    
      pstmt.setString(2, sourcetype);


  		




  
  104
  
    
      pstmt.setString(3, targettype);


  		




  105
  105
  
    

  		




  106
  106
  
    
      pstmt.execute();


  		




  107
  107
  
    
      try {


  		












Also available in:  Unified diff