The jdbc.quote.idInWhere option

A jdbc.quote.idInWhere option specifies a default value of a quotation symbol for ids in a where clause.

Parameters

The jdbc.quote.idInWhere option takes a quotation symbol to quote ids in a where cluase in a SQL command. In the case of SQL-92 comformance dababases, " (double quote) is used as a quotation symbol for ids. Therefore, a default value of the option is " (double quote).

When the value of the jdbc.quote.where option is either null or a null string, the value of this option is not used.

Artifact

The jdbc.quote.idInWhere option generates no additional classes. The jdbc.quote.idInWhere option just modified the behavior of Relaxer table objects.

The jdbc.quote.idInWhere option adds no additional methods to Relaxer objects.

Example

List 12.11.3.1[jdbcQuoteIdInWhere.rng] is a sample schema for the jdbc.quote.idInWhere option.

<grammar xmlns="http://relaxng.org/ns/structure/1.0"
         datatypeLibrary="http://www.w3.org/2001/XMLSchema-datatypes">
  <start>
    <ref name="account"/>
  </start>
  <define name="account">
    <element name="account">
      <attribute name="accountNo">
        <data type="token"/>
      </attribute>
      <element name="balance">
        <data type="int"/>
      </element>
      <element name="owner">
        <data type="token"/>
      </element>
      <ref name="address"/>
      <zeroOrMore>
        <ref name="phone"/>
      </zeroOrMore>
    </element>
  </define>
  <define name="address">
    <element name="address">
      <attribute name="zip">
        <data type="token"/>
      </attribute>
      <text/>
    </element>
  </define>
  <define name="phone">
    <element name="phone">
      <attribute name="area">
        <data type="token"/>
      </attribute>
      <data type="token"/>
    </element>
  </define>
</grammar>

Execution of Relaxer with the jdbc.quote.idInWhere option is as follows. Note that, because backquote (`) has a special meaning in UNIX shell, the backquote (`) is escaped using back-slash (\).

$ relaxer -jdbc -jdbc.quote.id:\' -jdbc.quote.where:\" \
    -jdbc.data.quote.idInWhere:\` jdbcQuoteIdInWhere.rng