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
winmail.dat
Description: application/ms-tnef