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>