Is this a JDBC Adapter limitation or relates to Oracle client ?
I connect to Oracle 9i (9.2.0.3).
When I perform a SELECT, it returns only the first 1000 rows.

I am using connection pools and My Settings reads as follow :
Connection Type = JDBC Adapter Connection
Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
Connection Properties
Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName MYHOST
user USER
password ******
databaseName ISPHD
portNumber 1529
networkProtocol tcp
Other Properties driverType=oci
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 10
Maximum Pool Size 150
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000

I searched evrywhere, no mention of a max-row or so…
thanks in advance
Arnaud

Hi Arnaud,

      This option of setting max rows is in adapter service, not in adapter connection. check out your select service. 

Regards,
raghu

Arund,

You have an option to set maximum number of rows in adapter service.

Thanks both for your fast answer, but I went there -my adapter service for the select- but where to set max-rows ?
I see a Settings tab, but no mention of max-rows.
Could you help ?
thx
Arnaud

Hi Arnaud,

In the select tab of the select adapter service, you will find the set maximum number of rows option.

regards,
raghu

Thank you very much Vennamareddy.
I was blind, you opened my eyes !
I which you a wonderfull day.

regards
Arnaud