Re: [jboss-as7-dev] (JDBC) Driver Registry
----- Original Message -----
From: "Heiko Braun" <hbraun(a)redhat.com>
To: "jboss-as7-dev(a)lists.jboss.org Development"
<jboss-as7-dev(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev