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

[Markus Neteler]

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