[GRASS-dev] [GRASS GIS] #2457: DBF driver: stub functions for SQL TRANSACTION
GRASS GIS
trac at osgeo.org
Tue Oct 21 09:57:14 PDT 2014
#2457: DBF driver: stub functions for SQL TRANSACTION
-------------------------+--------------------------------------------------
Reporter: neteler | Owner: grass-dev@…
Type: defect | Status: new
Priority: normal | Milestone: 6.4.5
Component: Database | Version: svn-releasebranch64
Keywords: dbf, sql | Platform: All
Cpu: Unspecified |
-------------------------+--------------------------------------------------
On some systems (here: Ubuntu, user report on grass-user), it is not
possible to run v.rast.stats properly when using the DBF driver as it is
internally executing a SQL transaction:
{{{
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'
}}}
I would suggest to add stub functions for
* db_begin_transaction()
* db_commit_transaction()
to db/drivers/dbf/execute.c to make the DBMI interface happy.
Is attached patch ok? If yes, also add to GRASS 7?
--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2457>
GRASS GIS <http://grass.osgeo.org>
More information about the grass-dev
mailing list