topic Re: What technology is used behind arcpy cursors? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/what-technology-is-used-behind-arcpy-cursors/m-p/28793#M1037 <HTML><HEAD></HEAD><BODY><SPAN>You may want to ask this on the ArcObjects or Geodatabase forum, this is an implementation-specific detail for each workspace type. Arcpy simply builds on the </SPAN><A href="http://www.esri.com/news/arcuser/0706/files/cursors.pdf">geodatabase's cursor model for accessing data</A><SPAN>.</SPAN><BR /><BR /><SPAN>If you're using arcpy, the way to get transactions is using the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000005000000">arcpy.da.Editor</A><SPAN> object.</SPAN></BODY></HTML> Thu, 26 Sep 2013 15:51:10 GMT JasonScheirer 2013-09-26T15:51:10Z What technology is used behind arcpy cursors? https://community.esri.com/t5/geoprocessing-questions/what-technology-is-used-behind-arcpy-cursors/m-p/28792#M1036 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm using ArcGIS Server 10.0. I have a geoprocessing using arcpy search, update and insert cursors. I'd like to know more about the technology behind these cursors.</SPAN><BR /><BR /><SPAN>Does it use any driver or pool to connect to the database (I'm using Oracle 11g)?</SPAN><BR /><BR /><SPAN>Does it open a connexion to the DB once at the creation of the cursor and close it when the cursor is deleted? What about transactions?</SPAN><BR /><BR /><SPAN>Does the cursor open a new connexion and transaction to the DB each time a row is updated or inserted?</SPAN><BR /><BR /><BR /><SPAN>Regards.</SPAN></BODY></HTML> Thu, 26 Sep 2013 13:44:09 GMT https://community.esri.com/t5/geoprocessing-questions/what-technology-is-used-behind-arcpy-cursors/m-p/28792#M1036 ab1 2013-09-26T13:44:09Z Re: What technology is used behind arcpy cursors? https://community.esri.com/t5/geoprocessing-questions/what-technology-is-used-behind-arcpy-cursors/m-p/28793#M1037 <HTML><HEAD></HEAD><BODY><SPAN>You may want to ask this on the ArcObjects or Geodatabase forum, this is an implementation-specific detail for each workspace type. Arcpy simply builds on the </SPAN><A href="http://www.esri.com/news/arcuser/0706/files/cursors.pdf">geodatabase's cursor model for accessing data</A><SPAN>.</SPAN><BR /><BR /><SPAN>If you're using arcpy, the way to get transactions is using the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000005000000">arcpy.da.Editor</A><SPAN> object.</SPAN></BODY></HTML> Thu, 26 Sep 2013 15:51:10 GMT https://community.esri.com/t5/geoprocessing-questions/what-technology-is-used-behind-arcpy-cursors/m-p/28793#M1037 JasonScheirer 2013-09-26T15:51:10Z