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 227148 - Need more smart hints in case if no connection was found in jpql editor
Summary: Need more smart hints in case if no connection was found in jpql editor
Status: RESOLVED FIXED
Alias: None
Product: javaee
Classification: Unclassified
Component: Persistence (show other bugs)
Version: 7.3
Hardware: All All
: P3 normal (vote)
Assignee: Sergey Petrov
URL:
Keywords:
: 227149 (view as bug list)
Depends on:
Blocks:
 
Reported: 2013-03-07 10:14 UTC by Sergey Petrov
Modified: 2013-03-23 01:59 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
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 Sergey Petrov 2013-03-07 10:14:07 UTC 
See https://blogs.oracle.com/geertjan/entry/test_jpql_with_netbeans_ide

my comments what can be done:
If it's the same issue with :"need to register".
I can change hints wording about exact match of connection to one used in persistence application.
I can try to output expected connection "url" also and
 as there are a lot of similar complains I can try to analyze presence of "similar" connection and output as example of "similar but not exactly the same" wit comments like "you need to adjust parameters or create new one with proper parameters".
It should make hints more smart I hope.
The main issue here I see no feedback on my comment if url is the main issue or there may be some other issues too, also nobody file any issues in issuezilla yet.
Comment 1 Sergey Petrov 2013-03-07 10:20:22 UTC 
*** Bug 227149 has been marked as a duplicate of this bug. ***
Comment 2 Sergey Petrov 2013-03-07 10:26:22 UTC 
forget to mention one more option, need to reevaluate if missed connection registration should be a blocker instead of hint in case of failed query only but there was some reasons to require registration, at least to open a connection, to add a driver to classpath if necessary, for substitution of datasource with a connection and may be more.

one more option, for usability hint button "register db connection" may be added in jpql editor.
Comment 3 Sergey Petrov 2013-03-14 19:31:37 UTC 
message is changed to
You need to register database connection on Services tab, expected url=\"{0}\", driver=\"{1}\", user=\"{2}\" should match exactly.

wording may change a bit, feel free to correct me also, but will it be helpful?
I suppose it can be considered as fixed before we get more feedback if this hint work or not.
it's not in usual daily builds yet but in 7.3.1
Comment 4 Quality Engineering 2013-03-23 01:59:17 UTC 
Integrated into 'main-golden', will be available in build *201303222300* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/22c98ef5e812
User: Sergey B. Petrov <sj-nb@netbeans.org>
Log: #227148 add hint regarding url/driver/user
cleaup