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

Summary:	When specifying empty required values a test connection should not be established.
Product:	db	Reporter:	brettryan <brettryan>
Component:	Code	Assignee:	matthias42
Status:	NEW ---
Severity:	normal
Priority:	P4
Version:	8.2
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:

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.