ReadNext method loops when using SqLite database

[zhanga]

The code below works fine using Oracle Database but it loops using SQLite database. .... MgReader sqlReader = _featureService.ExecuteSqlQuery(_resourceIdentifier, strSQL);

int cpt = 0; while (sqlReader.ReadNext()) { cpt++; } ....

[zhanga]

When call ReadNext() in from web-tier side, it actually doesn’t send a ReadNext() operation request to Map Server. Instead, it sends a GetRows operation request to get a lot of records, then cache the records. If the GetRows operation returns an empty collection, then we think we have reached the end of the reader. But there is no specification in the FDO API about what we should do in case an application calls again ReadNext after reader is depleted. In SQLite the sqlite engine resets the statement automatically and start it over again. Therefore, the GetRows method will never return an empty collection for Sqlite database. Then the ReadNext() method in the web app would be an endless loop. This submission fixes ServerDataReader and ServerSqlDataReader to make IM Server runs correctly when using SQLite database.

MG Open Source: Server/src/Services/Feature/ServerDataReader.cpp Server/src/Services/Feature/ServerDataReader.h Server/src/Services/Feature/ServerSqlDataReader.cpp Server/src/Services/Feature/ServerSqlDataReader.h