1) Create a database with SQLite
2) Connect to it in Netbeans
3) Disconnect the database (or even delete the connection)
4) Try to delete the databasefile from Explorer or via a script
This creates an "access denied" error.
SQLite is not currently a supported database, so I am sorry but this is not a P2. We will fix it as we can.
Btw.: Why isn't SQLite a supported db, as I'm reading all the time? It's very popular and very handy on the desktop.
Shouldn't it become supported? Who decides that? This is no accusation - I'm just curious.
Hi, Raskolnikov. SQLite is an excellent database, and is being used in more and more places. It would be nice to
support it. But to be honest when we work with users, it is not commonly requested right now. We have our hands full
with MySQL, Oracle, MS SQL Server, PostgreSQL, Java DB and DB2. There are a bunch of databases that people use but
which we don't test against or provide "official" support - but we make our best effort to get it to work.
It's particularly hard to support SQLite since it (a) has absolutely no metadata support in its JDBC driver, so it's
useless in the Database Explorer and (b) it's embedded, and thus behaves differently from standard client/server
databases. So it would take some concerted effort to get it working. I'd like to do this, but there are only so many
hours in the day.
You are helping *a lot* by reporting bugs. If you would like to help yourself and many others out, it would be GREAT if
you actually wanted to submit patches with suggested fixes. I would be more than happy to provide you support as you
get the source code and build environment set up, and to point you to the relevant areas of the code.
can we communicate on another "channel" than via this issue (thus putting a lot of noise in it)?
I'm new to this community and I suppose there's something like "private message" or so...
But in the first place I have to discourage you since I'm no Java programmer and have only written a few dozens lines of
java-code in my life... Nevertheless I could try to fix (very) minor issues like nr 150275.
I would like to contribute if it doesn't take me forever to get into the matter... one never knows: perhaps it's possible.
For the next 2 weeks I'll be away in holidays.
See you then,
Reassigned to new owner.
Should be fixed since NB6.8M1