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?

book

Article ID: 36861

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server

Issue/Introduction

Question: 

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?

 

Answer: 

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:

ps.setMaxRows(0)

where ps is your PreparedStatement object.

 

Environment

Release: DATABB00200-15-Datacom/AD
Component: