I'm using the Excel driver in a Java program and when the JDBC connection is open I can't save any modification from Excel program. The msg is relative to "sharing violation". It seems like it'd be locked by Excel driver.
The problem isn't due to file or folder permissions, I checked them. If I close the JDBC connection then I can save the file.
|
Because it's opened by HXT Excel. You can use delayedClose=0 connection property to release it ASAP.
|