[gdal-dev] ogr2ogr fails on second call with sql select

[Paul Higgins]

 I was mistaken the call fails the second time when the dialect is sqlite whether its issued in one thread or multiple.  
The call work OK when the dialect is the default OGRSQL even when both calls are made in one thread.
So there must be something extra that should be done for dialect sqlite.
    On Sunday, September 27, 2020, 03:00:07 a.m. GMT+8, gdal-dev-request at lists.osgeo.org <gdal-dev-request at lists.osgeo.org> wrote:  
 
 Send gdal-dev mailing list submissions to
    gdal-dev at lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.osgeo.org/mailman/listinfo/gdal-dev
or, via email, send a message with subject or body 'help' to
    gdal-dev-request at lists.osgeo.org

You can reach the person managing the list at
    gdal-dev-owner at lists.osgeo.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gdal-dev digest..."


Today's Topics:

  1. Re: ogr2ogr fails on second call with sql select (Paul
      Higgins) (Paul Higgins)


----------------------------------------------------------------------

Message: 1
Date: Sat, 26 Sep 2020 03:55:59 +0000 (UTC)
From: Paul Higgins <phigginsca at yahoo.com>
To: "gdal-dev at lists.osgeo.org" <gdal-dev at lists.osgeo.org>
Subject: Re: [gdal-dev] ogr2ogr fails on second call with sql select
    (Paul    Higgins)
Message-ID: <317679387.989976.1601092559719 at mail.yahoo.com>
Content-Type: text/plain; charset="utf-8"

 I found that the only way around this is to make each call,  that has a SELECT in it,  to my ogr2ogr function in a separate thread.  If there are no SELECTs in the calls then I can make them all in one thread.
  
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200926/fa549af6/attachment-0001.html>

------------------------------

Subject: Digest Footer

_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

------------------------------

End of gdal-dev Digest, Vol 196, Issue 39
*****************************************
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200927/9d1afec3/attachment.html>