The getSearchStringEscape() method of the DatabaseMetaData interface is used to get the that is used to escape the wildcard characters ('_' or, '%') by the underlying database.
This method returns a string parameter representing the value that is used to escape wildcard characters
To get the DatabaseMetaData object −
Finally, get the search String to escape wild characters, by invoking the getSearchStringEscape() method of the DatabaseMetaData class.
Following JDBC program establishes connection with MySQL database, retrieves the search escape string.
import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.SQLException; public class DatabaseMetadata_getSearchStringEscape { public static void main(String args[]) throws SQLException { //Registering the Driver DriverManager.registerDriver(new com.mysql.jdbc.Driver()); //Getting the connection String url = "jdbc:mysql://localhost/mydatabase"; Connection con = DriverManager.getConnection(url, "root", "password"); System.out.println("Connection established......"); //Retrieving the meta data object DatabaseMetaData metaData = con.getMetaData(); //Retrieving the columns in the database String escapeString = metaData.getSearchStringEscape(); //Printing the column name and size System.out.println("Search string that that is used to escape the wildcard characters: "+escapeString); } }
Connection established...... Search string that that is used to escape the wildcard characters: \