[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