JDBC Adapter 602 build 443 limited to 1000 rows

, ,
1

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

2

Hi Arnaud,

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

Regards,
raghu

3

Arund,

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

4

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

5

Hi Arnaud,

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

regards,
raghu

6

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

regards
Arnaud