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.
some databases don't have a concept of a schema (for example, SQLite). attempting to use most of the database functions in 6.7RC3 causes errors as the code is (i imagine) hard-wired to expect a schema present. AFAIK a schema is not required of the JDBC driver, and the SQLite driver doesn't supply one. for example, once i add the driver, i can connect to the SQLite database well enough (first attachment), but if i try to use the context menu to view the contents of a table i get an obscure error dialog (second attachment). using the 'Execute Command' context menu, i can use the SQL editor to manually enter queries, but interacting with the results is also impossible. for example, if i click the 'Insert Records' button, the generated code is incorrect (third attachment). most importantly, CC doesn't work at all, and attempting to invoke it causes the CPU to permanently jump to 100% (hence the P1). incidentally, the generated code also needs to quote column names, as they may also be a keyword.
Created attachment 83961 [details] Services window after connecting to the DB
Created attachment 83962 [details] error dialog when trying to invoke the 'View Data' context menu
Created attachment 83963 [details] the 'Insert Records' dialog creates incorrect code
you can download a stand-alone SQLite driver from here: http://files.zentus.com/sqlitejdbc/sqlitejdbc-v056.jar
this is not a stopper for NB 6.7 -> decreasing the priority
core-main/rev/8d4084347247
Integrated into 'main-golden', will be available in build *200907150249* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/5e22608e1e6b User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #167564: CC and most database options don't work for databases without a schema
yup
whoops. CC still isn't working...
perhaps it just hasn't migrated into the daily builds on the site. how long should that take?
It's true. The previous fixed the fatal problem while using DB w/ schema, but CC was still not working. The fix should fix CC too: core-main/rev/508c41bf7ef8
Integrated into 'main-golden', will be available in build *200907230201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/508c41bf7ef8 User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #167564: CC don't work for databases without a schema
yup!
Integrated into 'main-golden' Changeset: http://hg.netbeans.org/main-golden/rev/3a3f7510183c User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #200783 - Endless loop in command completion when quoteString = "" (Bugs: #179413, #167564); applied matthias42's patch, thanks