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