As a convenience feature, the SQL repository can simulate full text searches with the SQL LIKE operator. If full text searching is not available for your database, you can substitute pattern matching queries for text search queries by setting the following property in the GSARepository component:


The SQL repository converts text search queries into CONTAINS pattern match queries, which are implemented with the SQL LIKE operator.

Simulated text search queries are useful for demos and standalone development when one wants to put in place the createTextSearchQuery() API calls without having to set up a text search engine. However, simulated text queries are extremely inefficient and are not supported for production systems. A simulated text search query with LIKE typically causes a table scan, so avoid simulated queries in production.

Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices