You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
My electron application runs a simple query every 10 seconds to get the latest invoice of a POS' ADODB database. This works for a while but after 2-3 days the query stops working and it shows the following error:
The only way to resolve this issue is closing the app completely and opening it again, then it starts working again for 2-3 days until the same issue happens again. I tried "resetting" the connection with the following code:
asyncGetDBList(size: number){try{this.COUNT_TRY++;letdata: any=awaitthis.db.query("query to get the invoices");this.COUNT_TRY=0;returndata;}catch(ex){if(this.COUNT_TRY<=this.MAX_COUNT_TRY){this.db=ADODB.open(this.connectionString,this.x64);awaitsleep(400);returnawaitthis.GetDBList(size)}else{log.error("GamaSoft:GetDBList:catch:",ex);log.error(JSON.stringify(ex));returnundefined;}}}
I thought by doing this i would be resetting the connection every time it fails, but the error keeps happening and the only way I have right now of really resetting the connection and making everything work correctly again is closing the app completely and opening it again.
The text was updated successfully, but these errors were encountered:
My electron application runs a simple query every 10 seconds to get the latest invoice of a POS' ADODB database. This works for a while but after 2-3 days the query stops working and it shows the following error:
The only way to resolve this issue is closing the app completely and opening it again, then it starts working again for 2-3 days until the same issue happens again. I tried "resetting" the connection with the following code:
I thought by doing this i would be resetting the connection every time it fails, but the error keeps happening and the only way I have right now of really resetting the connection and making everything work correctly again is closing the app completely and opening it again.
The text was updated successfully, but these errors were encountered: