tSQLiteInput and terminated tSQLiteConnection

Four Stars

tSQLiteInput and terminated tSQLiteConnection

Hello.

 

My tSQLiteInput uses an existing tSQLiteConnection.

 

In certain circumstances the tSQLiteConnection is beeing terminated and my tSQLiteInput throws an exception because of missing connection and my job stops running.

 

Is there any way to reopen the connection when it has been terminated?

 

Thank you and best regards.

 

 

 

Eight Stars

Re: tSQLiteInput and terminated tSQLiteConnection

Instead of using existing connection, you can provide
connection details in input explicitly . it will cost you 0 to always open a new connection, in the case of sqlite db.
Four Stars

Re: tSQLiteInput and terminated tSQLiteConnection

Hello Chirgal. Why you mean that it costs me 0 if I access the file each iteration of around 200k iterations each hour?

Thank you.
Eight Stars

Re: tSQLiteInput and terminated tSQLiteConnection

Sqlite db are server less and based on local file only. R u really connecting to any external server while opening connection?
Four Stars

Re: tSQLiteInput and terminated tSQLiteConnection

Hello, I know that sqlite is file based. But file i/o also takes time. db file is stored on a netshare...

Eight Stars

Re: tSQLiteInput and terminated tSQLiteConnection

You can open/close connection per iteration . There won't be performance impact.

Yes I/O may impact, if you are running iterations in parallel. But sqlite won't complain ,since it always does write work for 1 connection/process/thread at a time, while read operations can be done in parallel.
Four Stars

Re: tSQLiteInput and terminated tSQLiteConnection

This doesn't work.

 

I run into "locked database" exeption quite fast.

 

Filehandler seems to keep it locked longer than an iteration takes...