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 93159 - Prevent conflicts between data sources in project and data sources in server
Summary: Prevent conflicts between data sources in project and data sources in server
Status: RESOLVED FIXED
Alias: None
Product: serverplugins
Classification: Unclassified
Component: Infrastructure (show other bugs)
Version: 5.x
Hardware: All All
: P3 blocker (vote)
Assignee: Libor Kotouc
URL:
Keywords:
Depends on:
Blocks: 89438 99069 104341 104444
  Show dependency tree
 
Reported: 2007-01-25 05:21 UTC by David Vancouvering
Modified: 2007-05-21 21:07 UTC (History)
5 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 2007-01-25 05:21:23 UTC
We will be storing data source information in the project as well as the server.
 This causes potential for conflict when the project changes servers or the
project is used on a different machine.  We need to make sure these conflicts
are well handled.
Comment 1 David Vancouvering 2007-01-25 05:24:01 UTC
There are three types of conflicts:

    * A data source exists in the server with the same JNDI name, JDBC URL and
connection parameter as the data source defined in the proejct. In this case we
just use the data source in the server 

    * A data source exists in the server with the same JNDI name and the
database vendor is the same, but the connection parameters or other parts of the
URL differ. We use the data source and generate a warning. The warning contains
detailed information about the conflict and instructions as to how the user can
change data sources if they so desire. - Question: How does the user create a
new data source on the server and map it to the data source defined in the
project, if that's what they want to do? 

    * A data source exists in the server with the same JNDI name but different
JDBC URL. What we had discussed in this case is that the project is marked as
"broken" and a "broken" indicator is displayed by the data source showing that
it could not be mapped to a data source in the server, and the user has to
manually fix this before the project will work. However, it seems to me an
alternative would be to create a new data source in the server with a different
JNDI name that has the correct URL and connection parameters for VWP to work. Is
this possible/reasonable? 
Comment 2 John Baker 2007-02-15 01:32:12 UTC
Reassigning to sherold, marcow no longer works on NB server plugin apis
Comment 3 Petr Jiricka 2007-02-16 13:48:25 UTC
Assigning to Libor.
Comment 4 Libor Kotouc 2007-04-12 15:12:01 UTC
Storing of DS information in the project is a matter of implementation of 'Add
Data Source Reference' dialog.

For more info see http://wiki.netbeans.org/wiki/view/ResourceReferenceBinding
and the related UI spec.
Comment 5 John Baker 2007-04-26 01:14:43 UTC
Has this preventing-conflicts task been resolved by 93815 ?

I don't see conflict prevention mentioned in this spec :
 http://wiki.netbeans.org/wiki/view/ResourceReferenceBinding
Comment 6 John Baker 2007-04-26 01:15:40 UTC
Has this preventing-conflicts task been resolved by 93815 ?

I don't see conflict prevention mentioned in this spec :
 http://wiki.netbeans.org/wiki/view/ResourceReferenceBinding
Comment 7 John Baker 2007-04-26 01:16:15 UTC
Has this preventing-conflicts task been resolved by 93815 ?

I don't see conflict prevention mentioned in this spec :
 http://wiki.netbeans.org/wiki/view/ResourceReferenceBinding
Comment 8 Petr Jiricka 2007-04-26 17:28:07 UTC
Well, the "conflict prevention" is a general concept that does not really
translate into concrete user features. When this issue was filed some time, a
certain UI and particular APIs were assumed, however these have changed since
then. The UI spec was circulated a while ago and no major comments were raised
during the review. So I would consider this issue resolved, and if we see any
particular problems with the new design, let's file new bug/enhancement reports
with exact steps to reproduce and exact description of user impact. So for now I
would close this issue as FIXED, and separately discuss any potential
outstanding issues that need to be addressed in addition to what has already
been implemented. Agreed?
Comment 9 Petr Jiricka 2007-04-30 17:01:16 UTC
Marking as fixed.