ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Is there a limit on the number of records that can be accessed by CA Datacom Server with JDBC? How can the limit be set?


Article ID: 36861


Updated On:


Datacom DATACOM - AD



When trying to read a table using the Datacom Server JDBC driver, it appears there is a limit on the number of records that can be accessed. This limit appears to be set at 10,000.  A JDBC trace shows this:

 getMaxRows max rows = (9999) 

Is it an internal limit or related to how the client software is accessing Datacom? 

Can it be reset?



There is no limit to how many records can be accessed by Datacom Server. The limit is probably being set by the client software being used.

You can set the limit in your program using the setMaxRows() method in the PreparedStatement object. 

A MaxRows value of 0 means there is no limit. Code the following in your program to set MaxRows:


where ps is your PreparedStatement object.



Release: DATABB00200-15-Datacom/AD