[jboss-as7-dev] (JDBC) Driver Registry

[Andrig Miller]

----- Original Message -----
> From: "Heiko Braun" <hbraun at redhat.com>
> To: "jboss-as7-dev at lists.jboss.org Development" <jboss-as7-dev at lists.jboss.org>
> Sent: Monday, May 9, 2011 3:35:59 AM
> Subject: [jboss-as7-dev] (JDBC) Driver Registry
> 
> 
> 
> Following up with some of the discussion we'd been having in the past
> few weeks,
> I would like to call for comments on the idea of a central, domain
> level driver registry
> that can be used to query specific deployments like JDBC drivers.
> 
> Creating datasource configuration is currently way to complex for the
> average user.
> Once you've deployed the JDBC driver you need provide the correct
> driver name, driver class and version
> besides the regular data source attributes. Since we are lacking a
> way to query for installed JDBC drivers
> this currently means providing the required attributes as string
> values.
> 
> A more simple and less error prone approach would be to provide a
> selection of drivers to chose from.
> But this would require something like a domain level driver registry.
> 
> The same mechanism might be used to query available resource adapters
> or other specific deployment types
> that are typically referenced by applications.
> 
> Any reasons why this cannot be done?
> Any objections why it shouldn't be?
> Other ideas how this situation can be improved?

One problem we have is distribution of the drivers.  For the open source drivers, its not a problem, but for close source drivers I don't believe their licenses allow us to distribute them, so that could be one impediment to doing this, as I assume that we would need to distribute the drivers within the registry.

I really like this idea in general, but it may be limited in usefulness if we cannot do it for close source data sources.

Do you think we could attempt to grab the strings right from the jar file MANIFEST.MF, and the META-INF/services?  In looking at the MySQL and PostgreSQL drivers I have installed, it would work for MySQL, but not for PostgreSQL.  Not sure about other drivers.  The PostgreSQL driver jar files MANIFEST.MF file doesn't contain the version information like MySQL does, but perhaps if the closed source drivers have such information, we could get the Postgres guys to add it.

Andy

> 
> 
> Ike
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> jboss-as7-dev mailing list
> jboss-as7-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>