Re: javax.sql.DataSource implementation

Diego,
I think you're missing an important understanding regarding JDBC and a
DataSource. A DataSource is obtained from the container (for example,
Tomcat) that your application is running in. There are a few reasons to
do this. The most important is to separate the configuration of your
database connection from your source code. In pure JDBC you do all of
the connection configuration yourself - setting the user name, password,
driver, and so on. A DataSource, which is acquired through JNDI puts
all of the configuration of the database connection outside of your code
and makes it available to your application (or other applications or web
apps).

The downside of this is that each application server configures this
differently. WebLogic does it differently than Tomcat and they are both
different than WebSphere. Engines like JBoss and Glassfish muddy the
waters more. They embed Tomcat but have different ways of setting up
the JDNI DataSource.

I don't know what application server you're using but Tomcat has a great
page at
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
that includes a PostgreSQL specific section. If you're using a
different app server then you'll want to read the docs on how to get it
setup.

diego(dot)vera(at)capgemini-sdm(dot)com wrote:
>
> Hi all,
>
> I am using Jsecurity with postgresql and I require an implementation
> of the javax.sql.DataSource, I reviewed the source code of the jdbc
> driver and It seems that it is not implemented. Do you know where
> could I get it? Or should I implement my DataSource? I thouhg it
> should be part of the jdbc driver.
>
> Best regards,
>
> -Diego Vera
>