Project

General

Profile

Revision 94

Added by Matt Jones over 20 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