AnsweredAssumed Answered

JDBC SQL issue with .next()

Question asked by CarlSchwarz on Jan 31, 2018
Latest reply on Feb 2, 2018 by fmpdude

I am returning a fairly large set of data with a select statement.  There is 900 records returned each time, but sometimes there is more data per record.

When there is a lot of data per record I am getting an exception called.

 

Here is the code

try {
 Statement stmt = con.createStatement();
 ResultSet kafkaJson = stmt.executeQuery("select JSONPlusHistory, AssetCode, currentTimestamp from AssetSerialsAPI WHERE UseState>0");
 while (kafkaJson.next())
 {
  System.out.println("NotReached");
 }   
} catch (Exception e) {
 System.out.println("fileMaker Find Issue");
 System.out.println(e);
}

 

If the data set is large I get this error:

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Index: 3, Size: 3

The Index and Size values can be different

 

If I remove the kafkaJson.next() line the code runs fine, if there is less data in the dataset returned the while loop also runs fine.

Any ideas what the problem is?

Outcomes