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.

Bug 150280 - Unable to connect using any non-standard JDBC driver
Summary: Unable to connect using any non-standard JDBC driver
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P1 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-15 19:19 UTC by David Vancouvering
Modified: 2008-10-21 06:53 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Vancouvering 2008-10-15 19:19:21 UTC
- Get the SQLite JDBC driver and add it to the Drivers
- Choose Connect With... from the driver
- First of all, you are placed in the field entry mode, which doesn't make sense, because this driver has no template
- Secondly, even if you enter in a URL for both field entry and URL entry modes, you can't say "OK" - the dialog keeps
saying "Please specify a URL"
Comment 1 David Vancouvering 2008-10-15 19:21:45 UTC
I will take a look at this after lunch, unless you want to grab it Rob.  I need this fixed so I can test with SQLite,
and obviously it's a bit of a showstopper for non-standard drivers, so I'll definitely be working on this once I'm back
at the keyboard.
Comment 2 David Vancouvering 2008-10-15 22:07:38 UTC
I discussed this with Jayashri, and she has a good point that since this issue exists for non-supported drivers (e.g.
not in our standard driver list), then although it's a real problem it's not a P1.

Roman, if you disagree after discussing with Petr B., please reprioritize.
Comment 3 David Vancouvering 2008-10-15 23:33:42 UTC
871bda167c12

* For drivers whose URLs aren't parsed, don't offer a choice, have to do direct URL entry
* Validation code didn't handle the case where the URL is not parsed, so it is impossible

Since we only parse a very small subset of URLs (Oracle, MS SQL, Postgres, MySQL and Derby) this means *all other*
drivers don't work.  I actually do think this is a P1.
Comment 4 David Vancouvering 2008-10-15 23:39:19 UTC
I believe this needs to go into the RC branch as without it there are only a very small subset of database drivers that
will work with NetBeans 6.5 (Oracle, MS SQL, MySQL, PostgreSQL and Derby).  I think this is unacceptable and will cause
a lot of negative feedback from our users.
Comment 5 David Vancouvering 2008-10-15 23:47:00 UTC
Also need change set e70bde6ab7d1 -- a bug in my implementation was preventing direct URL entry.
Comment 6 Quality Engineering 2008-10-16 04:16:25 UTC
Integrated into 'main-golden', will be available in build *200810160201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/871bda167c12
User: David Van Couvering <davidvc@netbeans.org>
Log: #150280: Unable to connect using a SQLite driver
Comment 7 Petr Blaha 2008-10-16 09:46:19 UTC
Roman, can you verify the bug in the latest daily build? Thanks Then, we can push the fix in release65 clone.
Comment 8 Roman Mostyka 2008-10-16 13:30:57 UTC
Verified with build 081016.
I tried with Pointbase driver and everything is OK now, since there is no possibility to choose type of entry for not
supported drivers.
Comment 9 Roman Mostyka 2008-10-17 13:33:33 UTC
Please add this issue to release branch or add "65fixes1-candidate" status whiteboard to have the fix in Patch 1.
Comment 10 Roman Mostyka 2008-10-17 14:04:31 UTC
Or set target to RC2.
Comment 11 David Vancouvering 2008-10-17 16:58:26 UTC
I am confused, I thought *QE* was supposed to integrate into the RC branch?!
Comment 12 David Vancouvering 2008-10-21 06:36:58 UTC
Applied change sets 396c22af5955 and b3a5d6c87f18 to release65 brunch.  Running clean build and tests and then will push.
Comment 13 David Vancouvering 2008-10-21 06:53:15 UTC
Pushed to release65 branch