Record limits accessing Datacom Server with JDBC

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB
• Datacom/Server

Issue/Introduction

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?

Environment

Release: All supported releases.
Component: Datacom server.

Resolution

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. The limit can be set in the program using the setMaxRows() method in the PreparedStatement object. 

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

ps.setMaxRows(0)

where ps is the PreparedStatement object.