#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@PERMANENT raster=rainfall_idw@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>

_______________________________________________
grass-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-dev

Reply via email to