nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to keep SDE connection "alive" with arcpy?

EdgarRunnman

I am using arcpy for som automated database editing and i am in need to connect or stay connected to SDE with db onwer account after i close SDE to new connections with db admin account.

It seems that python opens new SDE connection evry time arcpy method involving that dependency accours and "kills" it after method executions is finished.
Is there a way to keep connection "alive" so that i can use it after i disconnect all other conections and close sde to new connections?

Encontre mais publicações marcadas com

Database Access

Python

Accepted answers

mody_buchbinder

I did not tried it but if you do a MakeFeatureLayer on one of the feature classes in SDE and do not delete this layer I think it will keep the connection open.

All comments

mody_buchbinder

I did not tried it but if you do a MakeFeatureLayer on one of the feature classes in SDE and do not delete this layer I think it will keep the connection open.

EdgarRunnman

I had some doubts because of using reference to table and not layer limitation in "management.DisableEditorTracking", but your solutions did the job!!!
It seems that python keeps track of active sde connections instanses and uses them in firs hand.
Thanks for the tips!

VinceAngelo

Maintaining an open arcpy.ArcSDESQLExecute cursor would probably accomplish the same thing.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.