Modify list of JDBC drivers presented to users in DB module?

[frankgrimes97]

Hi All,

I have a NetBeans platform application which makes use of the DB module.
I am bundling JDBC drivers for our supported databases and I would like the list only include those.

It looks as though the list is driven by org.netbeans.modules.db.util.DriverListUtil.
However, I see no way to edit (e.g. through a layer.xml) the drivers presented to the user.

Is there any way to achieve this without modifying the DB module's code?

Regards,

Frank Grimes

[akochnev]

Wrap the JDBC driver as a library module. Create a new module that depends on the driver library module, and add an xml file with the following content somewhere in the new module (the example below is for the sql server driver - if you're using something different, you'll need to have a different value in the class and the name of the jar file with the driver). :

[frankgrimes97]

Sorry, it looks like your XML sample got eaten by the forum gremlins... could you please re-post your sample?

Thanks!

[akochnev]

Wrap the JDBC driver as a library module. Create a new module that depends on the driver library module, and add an xml file with the following content somewhere in the new module (the example below is for the sql server driver - if you're using something different, you'll need to have a different value in the class and the name of the jar file with the driver). :

<?xml version='1.0'?>
<!DOCTYPE driver PUBLIC '-//NetBeans//DTD JDBC Driver 1.1//EN' 'http://www.netbeans.org/dtds/jdbc-driver-1_1.dtd'>
<driver>
<name value='SQLServer2008'/>
<display-name value='Microsoft SQL Server 2008'/>
<class value='com.microsoft.sqlserver.jdbc.SQLServerDriver'/>
<urls>
<url value="nbinst:/modules/ext/sqljdbc4.jar"/>
</urls>
</driver>

Finally, register the xml file that you just created in your layer.xml:

<filesystem>
<folder name="Databases">
<folder name="JDBCDrivers">
<file name="SQLServer2008Driver.xml" url="SQLServer2008Driver.xml"/>
</folder>
</folder>
</filesystem>

I hope this helps.

[frankgrimes97]

The above-mentioned configuration only worked by adding the drivers in the Services tab.
The new connection driver drop-down list still includes all possible drivers (those not in the classpath are red)

Attached are the screen shots of what I mean...

[frankgrimes97]

Is my only option really to fork/clone the DB module and trim the list down in code?

[Aleksandar Kochnev]

My fault, I didn't read the original question carefully enough. You might need to crack open the sources of the module you're talking about and see how that list is being generated.

Alex Kochnev
Architect, Quality Assurance
CommerceHub
255 Fuller Road Suite 327
Albany, NY 12203
518.810.0700 x3876
http://www.commercehub.com

-----Original Message-----
From: frankgrimes97 [mailto:address-removed]
Sent: Wednesday, December 22, 2010 2:54 PM
To: address-removed
Subject: [platform-dev] Modify list of JDBC drivers presented to users in DB module?

The above-mentioned configuration only worked by adding the drivers in the Services tab.
The new connection driver drop-down list still includes all possible drivers (those not in the classpath are red)

Attached are the screen shots of what I mean...




Attachments:
http://forums.netbeans.org//files/services_drivers_186.png
http://forums.netbeans.org//files/jdbc_driver_list_207.png

[frankgrimes97]

Well, it definitely looks like it's hard-coded in org.netbeans.modules.db.util.DriverListUtil.

Assuming no mechanism currently exists, how would one go about contributing a patch to the DB module to allow this to be configurable?

[Aleksandar Kochnev]

Frank,
Create a defect, fix the issue in your local repo, export a patch and attach the patch to the defect. The module owner will review and apply to the main source tree.

Alex Kochnev
Architect, Quality Assurance
CommerceHub
255 Fuller Road Suite 327
Albany, NY 12203
518.810.0700 x3876
http://www.commercehub.com

-----Original Message-----
From: frankgrimes97 [mailto:address-removed]
Sent: Thursday, December 23, 2010 4:39 PM
To: address-removed
Subject: [platform-dev] Modify list of JDBC drivers presented to users in DB module?

Well, it definitely looks like it's hard-coded in org.netbeans.modules.db.util.DriverListUtil.

Assuming no mechanism currently exists, how would one go about contributing a patch to the DB module to allow this to be configurable?

[Kris Scorup]

http://netbeans.org/community/contribute/patches.html

On Thu, Dec 23, 2010 at 1:39 PM, frankgrimes97 <address-removed ([email]address-removed[/email])> wrote: