Is there a way to set the SQL Prefetch value when using the Cocoon
datasources? Example Java code would be:
Statement sql = connection.createStatement();
sql.setFetchSize(100);
ResultSet rs = sql.executeQuery("Select * from table");
I would imagine a parameter passed to the SQLTransformer. For example:
<map:transform type="sql">
<map:parameter name="use-connection" value="ds"/>
<map:parameter name="set-fetch-size" value="100"/>
</map:transform>
Thanks,
Aaron
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
