kashipai / h2database

H2 Database for reference.
0 stars 0 forks source link

a csvread failure keeps the file open on windows #589

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
I previously reported this bug as issue 588, but it was closed as invalid; 
admin thought it was a bug in my code, but as my comment in that issue shows; 
the command to csvread was executed in the supplied h2 web console, not my 
code. I'm re-adding this as a new issue in case 588 is no longer being watched 
for comments.

-----------------------------------------------
The Bug:

If I attempt to create a table using csvread, but it fails to import for one 
reason or another (in my case it's because I had mistakenly entered a string 
value in an integer column), then h2 keeps the original csv file open; I am not 
able to manipulate the file in windows by deleting it or renaming it etc., I 
have to first shutdown h2, then delete the file.

This is on windows 2008 r2, java 1.7, h2 ver 1.4.181.

Original issue reported on code.google.com by localde...@gmail.com on 20 Oct 2014 at 6:02

GoogleCodeExporter commented 9 years ago

Original comment by thomas.t...@gmail.com on 20 Oct 2014 at 6:26