Project

General

Profile

« Previous | Next » 

Revision 764

Added by bojilova over 23 years ago

seems that there are problem in JDBC-ODBC bridge used with SQL Server
when using sql statements like:
SELECT ...
WHERE LIKE ? ...
changed to:
SELECT ...
WHERE = ? ...
and now it works

View differences:

src/edu/ucsb/nceas/metacat/DBTransform.java
112 112
      pstmt =
113 113
        conn.prepareStatement("SELECT system_id " +
114 114
                "FROM xml_catalog " +
115
                "WHERE entry_type LIKE ? " +
116
                "AND source_doctype LIKE ? " +
117
                "AND target_doctype LIKE ? ");
115
                "WHERE entry_type = ? " +
116
                "AND source_doctype = ? " +
117
                "AND target_doctype = ? ");
118 118
      // Bind the values to the query
119 119
      pstmt.setString(1, objecttype);
120 120
      pstmt.setString(2, sourcetype);

Also available in: Unified diff