I am using trial version of the driver (based on these results my company will decide this product should be bought)
In my test program, I am facing one issue. Once the program reads all the dbf files from a given directory, it is not able to instantly delete it. Looks like driver is not releasing the lock on these files immidiately.
I am doing:
after the files are read.
If I add wait for about 2000ms (between file read and delete function), then the delete works.
Please let me know what the issue is. This is very crucial for me to know if this can be fixed or not.
It won't close that file handler at once, usually that file will be closed after 3 secondes. You can use delayedClose=-1 to release those file handler at once. But the preferable solution is using DROP TABLE sql.
There is a delayedClose connection property, which indicates the delayed seconds for close transaction.