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 267741 - When specifying empty required values a test connection should not be established.
Summary: When specifying empty required values a test connection should not be establi...
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 8.2
Hardware: All All
: P4 normal (vote)
Assignee: matthias42
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-08-29 04:15 UTC by brettryan
Modified: 2016-11-04 21:19 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description brettryan 2016-08-29 04:15:47 UTC 
A relatively minor issue, but if I were to select a new Derby connection and not specify a database name, clicking "Test Connection" or "Next >" would be better positioned to validate required parameters first before attempting to establish a connection.

Other drivers such as jTDS with no host name also attempt to establish a connection.
Comment 1 matthias42 2016-08-29 08:04:00 UTC 
What would you verify? And how would you handle db driver defaults? From my perspective nearly every jdbc driver has its own scheme and defaults.

For example host in connector/j (mysql) defaults to 127.0.0.1, db is not needed for mysql.

So validation has to be driver specific and most probably also version specific. I don't mind leaving this open, but the test connection option is exactly to make the driver test the connection. The driver is the right place to do validation, as this is implementation depended.

I'll have a look into #254124 which is IMHO the real problem in this case, as the reply from the driver is not shown completely.
Comment 2 matthias42 2016-11-04 21:19:51 UTC 
Marking as an enhencement.