[GRASS-user] v.rast.stats is error while executing: 'BEGIN TRANSACTION'

[Markus Neteler]

Dear Chingchai,

sorry for the delay. I have fixed the script (at least it no longer
fails in my tests here). Please try the updated script from here:
 https://svn.osgeo.org/grass/grass/branches/releasebranch_6_4/scripts/v.rast.stats/v.rast.stats

Comment: Instead of trying to add SQL TRANSACTIONS to the DBF driver,
I have now simply conditionalized it in r63789. This fixed script will
ship with the future GRASS GIS 6.4.5.

Markus

On Wed, Oct 22, 2014 at 12:08 PM, Markus Neteler <neteler at osgeo.org> wrote:
> On Sun, Oct 19, 2014 at 11:54 PM, Markus Neteler <neteler at osgeo.org> wrote:
>> On Wed, Oct 15, 2014 at 6:16 PM, chingchai humhong
>> <chingchai.h at gmail.com> wrote:
>>> Hi all,
>>> I'm new to GIS and also new to GRASS GIS.
>>
>> Welcome here!
>>
>>> I want to zonal statistics from
>>> raster map rainfall interpolation(idw) on basin vector polygon. I used
>>> v.rast.stats. But there are problems
>>>
>>> v.rast.stats -c vector=basin_250 at PERMANENT raster=rainfall_idw at PERMANENT
>>> colprefix=z
>>> Updating the database ...
>>> DBMI-DBF driver error:
>>> SQL parser error: syntax error, unexpected NAME processing
>>> 'BEGIN'
>>> in statement:
>>> BEGIN TRANSACTION
>>> Error in db_execute_immediate()
>>> ERROR: Error while executing: 'BEGIN TRANSACTION'
>>>
>>> Thank you.
>>
>> ok, the issue is that the DBF driver does not support SQL
>> transactions. I thought that this would be automatically handled.
>
> I was able to reproduce the issue.
>
> I'm trying to address that now in
> http://trac.osgeo.org/grass/ticket/2457
>
> Markus