A patch is available with the following improvements to the SQL processor:
1. Support for reading from and writing to CLOBs. The code is JDBC compliant whenever possible. In addition, it also implements specific support for Oracle under Tomcat 4.1 and WebLogic 7.
Reading columns is done as usual. If the column is of CLOB type, it is automatically read as a CLOB:
<sql:get-column type="oxf:xmlFragment" column="clobcol"/>
When doing insertions of strings and XML fragments, it is possible to specify a SQL type, for example:
<sql:param type="oxf:xmlFragment" sql-type="clob" select="/document"/>
This causes the SQL Processor to use the CLOB APIs to set the value. The following statement causes the same value to be written as a SQL VARCHAR type instead:
<sql:param type="oxf:xmlFragment" sql-type="varchar" select="/document"/>
2. The shorter <sql:param> can be used instead of <sql:parameter>.
3. <sql:param> supports a new "separator" attribute. When that attribute is present, the result of the XPath expression in the "select" attribute is interpreted as a node-set. One query parameter is set for each element in the node set, separated by the characters in the separator. For example:
select * from ps_book
where book_id in
(<sql:param type="xs:int" select="/query/book-id" separator=","/>)Questions and comments are welcome. Please send requests for the patch to the mailing-list or directly to myself.
-Erik
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
