XSQLConfig.xml 详解

<?xml version="1.0" ?>
<XSQLConfig>

  <!--
配置XSQL Servlet行为
  -->
  <servlet>

   <!--
    |
    | Sets the size (in bytes) of the buffered output stream.
    | If your servlet engine already buffers I/O to the
    | Servlet Output Stream, then you can set to 0
    | to avoid additional buffering.
   
    | servlet缓冲的输出流大小，以字节为单位。
    |    <output-buffer-size>10000</output-buffer-size>
    |
    +-->
    <output-buffer-size>0</output-buffer-size>

   <!--
    |
    | Add <media-type> elements as shown below to cause
    | the XSQL Servlet to *suppress* sending the "charset=XXX"
    | portion of the Media/Content-type.
    |
    | For example, sending a character set for "image/svg"
    | documents seems to confuse current SVG plugins.
    |
    | <suppress-mime-charset>
    |   <media-type>image/svg</media-type>
    | </suppress-mime-charset>
    |
    +-->

    <suppress-mime-charset>
       <media-type>image/svg+xml</media-type>
       <media-type>image/svg</media-type>
    </suppress-mime-charset>

  </servlet>

<!--
  |
  | This section defines XSQL Page Processor configuration settings.
  |
  +-->
  <processor>

   <!--
    |
    | Use this parameter to change the default character set used for
    | automatic character set conversion performed by the XSQL Page Processor.
    | The value of the <default-charset> element must be a legal
    | Java character encoding name.
    | The default value if <none/> is NOT present and if no <default-charset>
    | is specified is 8859_1, which works best for most servlet
    | engines.
    |
    +-->
    <character-set-conversion>
      <default-charset>8859_1</default-charset>
    </character-set-conversion>

   <!-- 
    | 当从内存中加载错误时是否从新加载XSQLConfig.xml文件|
    +-->
    <reload-connections-on-error>yes</reload-connections-on-error>
   <!--
    |默认一次从数据库提取数据的行数|
    +-->
    <default-fetch-size>50</default-fetch-size>
    <!--
    | Set the size of the XSQL LRU Cache for cached XSQL Page results.
    +-->
    <result-cache-size>50</result-cache-size>

    <!--
    | Set the size of the XSQL LRU Cache for XSQL Pages    |
    +-->

    <page-cache-size>25</page-cache-size>

    <!--
    | Set the value of the XSQL LRU Cache for XSL Stylesheets.
     XSL样式表实例池的缓存大小，通过stylesheet-pool元素定义
    +-->
    <stylesheet-cache-size>25</stylesheet-cache-size>

    <stylesheet-pool>
      <initial>1</initial> <!-- 初始化大小-->
      <increment>1</increment><!-- 增量大小-->
      <timeout-seconds>60</timeout-seconds> <!-- 超时时间-->
    </stylesheet-pool>

    <!-- 配置JDBC连接行为-->
    <connection-pool>
      <initial>2</initial>   <!-- 连接池初始化大小-->
      <increment>1</increment> <!-- 增量大小-->
      <timeout-seconds>60</timeout-seconds><!-- 超时时间-->
      <dump-allowed>no</dump-allowed>
    </connection-pool>

    <!--
     | Set the name of the XSQL Connection Manager Factory implementation.
     +-->
    <connection-manager>
      <factory>oracle.xml.xsql.XSQLConnectionManagerFactoryImpl</factory>
    </connection-manager>

    <timing-info>
      <page>no</page>
      <action>no</action>
    </timing-info>

    <!--
     | Security Settings
     +-->
    <security>
      <stylesheet>

        <!--
         |  是否允许HTTP客户端可以指定用于转换的样式表，开发过程中设为Yes有帮助
         +-->
        <defaults>
          <allow-client-style>yes</allow-client-style>
        </defaults>

        <!--
         | 当页面显示用到的XSL文件不在本机时，指定其IP为安全。
         +-->
        <trusted-hosts>
          <host>127.0.0.1</host>
        </trusted-hosts>
      </stylesheet>
    </security>

    <!--
     | Sets the default OWA Page Buffer fetch style
     | used by the <xsql:include-owa> action
     | Valid values are CLOB or TABLE.
     |
     | If set to CLOB, the processor uses temporary
     | CLOB to retrieve the OWA page buffer.
     |
     | If set to TABLE the processor uses a more
     | efficient approach that requires the existence
     | of the Oracle user-defined type named
     | XSQL_OWA_ARRAY defined using the DDL statement:
     |
     |  CREATE TYPE xsql_owa_array AS TABLE OF VARCHAR2(32767)
     |
     +-->
     <owa>
        <fetch-style>CLOB</fetch-style>
     </owa>
  </processor>

  <!--
  | 设置HTTP代理服务器地址，当获取防火墙以为的文档时需要设置 |
  +-->

<!--
  <http>
    <proxyhost>your-proxy-server.yourcompany.com</proxyhost>
    <proxyport>80</proxyport>
  </http>
-->

  <!--
  | 描述数据库连接，每个XSQL文件中指定的连接数据库配置|
  +-->
  <connectiondefs>  

<connection name="MOMNPUP">
          <username>MOMNPUP</username>
          <password>MOMNPUP</password>
          <dburl>jdbc:oracle:thin:@localhost:1521:ora9</dburl>
          <driver>oracle.jdbc.driver.OracleDriver</driver>
          <autocommit>false</autocommit>
</connection>
   
  </connectiondefs>

  <!--
  |配置XSQL页面调用的行为处理程序|
  | Action Handler classes must implement the interface
  | oracle.xml.xsql.XSQLActionHandler.
  |
  | Once registered here, user-defined actions can be
  | used in the same way as built-in XSQL actions, for example
  | including the <xsql:myAction> element in your page.
  |
  +-->
  <actiondefs>
    <action>
      <elementname>param</elementname>
      <handlerclass>oracle.xml.xsql.actions.ExampleGetParameterHandler</handlerclass>
    </action>
    <action>
      <elementname>current-date</elementname>
      <handlerclass>oracle.xml.xsql.actions.ExampleCurrentDBDateHandler</handlerclass>
    </action>
  </actiondefs>

  <!--
   |  配置XSQL页面调用的序列化程序
   | Serializer classes must implement the interface
   | oracle.xml.xsql.XSQLDocumentSerializer.
   |
   | Once registered here, serializers can be used
   | in the serializer="XXX" attribute of an <?xml-stylesheet?>
   | processing instruction at the top of your XSQL pages.
   |
   +-->
  <serializerdefs>
    <serializer>
      <name>Sample</name>
      <class>oracle.xml.xsql.serializers.XSQLSampleSerializer</class>
    </serializer>
    <serializer>
      <name>FOP</name>
      <class>oracle.xml.xsql.serializers.XSQLFOPSerializer</class>
    </serializer>
  </serializerdefs>

</XSQLConfig>