This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | The primary key cannot be omit with SQLite | ||
---|---|---|---|
Product: | db | Reporter: | Roman Mostyka <romanmostyka> |
Component: | Show Data | Assignee: | _ ahimanikya <ahimanikya> |
Status: | RESOLVED WONTFIX | ||
Severity: | blocker | ||
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
Roman Mostyka
2008-10-30 19:31:48 UTC
SQLite is not currently SQLite is not currently supported. The JDBC driver for SQLite does not report that a primary key is auto-increment, so our code doesn't detect it. We would need to add specialized support for SQLite. I don't know why the varchar doesn't work, that's a real problem. varchar issue will be fixed part of another issue. But the primary key cannot be omit with SQLite, can't be fixed since the driver does not report it properly and I don't want to write any custom code for non-supported database. Ahi, I agree that it can be hard to fix, but it is customer reported issue and it seems that SQLite becomes more and more popular. Lets see on this issue in the future, not for next release, probably this DB become popular in nearest future and then it will be much better to fix this issue. Now lets mark this issue as RESOLVED LATER. Will pay attention in the future. I agree with Roman. I am planning a number of places where I have special-case code for popular database vendors. JDBC drivers are notorious in terms of their inconsistent implementation of the spec. It's just the way it is. I would prefer you not resolve it with LATER but set the target milestone to next, given that it's a user-requested feature and I agree with Roman, sqlite is becoming more and more popular. I just wish its JDBC driver were more compliant. NetBeans.org Migration: changing resolution from LATER to WONTFIX |