cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "SANSONE, AARON M [Non-Pharmacia/1000]" <aaron.m.sans...@monsanto.com>
Subject Setting the SQL Prefetch...
Date Thu, 07 Mar 2002 19:45:31 GMT
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message