How can I set the jdbc block size used for retrieving rows from the
database?  I thought I would be able to just modify the url for the db
connection as follows:

jboss2.4.1

<attribute
name="URL">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=localhost)(PROTOCOL
=tcp)(PORT=1521))(CONNECT_DATA=(SID=dev)));block size=512</attribute>

We have some queries that return a large number of rows and don't want to
use the jdbc default block size of 32.

Thanks

Eric Kaplan
Armanta, Inc.
55 Madison Ave.
Morristown, NJ  07960
Phone: (973) 326-9600

Attachment: winmail.dat
Description: application/ms-tnef

Reply via email to