I'm not certain how to get a DataSource
object. I was able to use the DriverManager
method to obtain a connection to a SQL database running on localhost, but every time I try to use the DataSource
method to do so I wind up getting exceptions (mostly for naming).
What I was wondering is:
DataSource
object for local hosted databases?DataSource
class need to be published, or is it like DriverManager
where you just get a connection with no new class creation?To create and deploy a DataSource object, you need to perform these tasks: Create an instance of the appropriate DataSource implementation. Set the properties of the DataSource object. Register the object with the Java Naming and Directory Interface (JNDI) naming service.
What is DataSource. A DataSource is a factory for connections to the physical databases. It is an alternative to the DriverManager facility. A datasource uses a URL along with username/password credentials to establish the database connection.
A DataSource
allows getting a JDBC connection mostly from a pool of connections. A DataSource
object represents a particular DBMS or some other data source, such as a file. If a company uses more than one data source, it will deploy a separate DataSource
object for each of them. The DataSource
interface is implemented by a driver vendor. You externalize DB connection properties file and fetch the object using JNDI. Using a Datasource
you need to know only the JNDI name. The Application server cares about the details.
It can be implemented in three different ways:
DataSource
implementation produces standard Connection objects that are not pooled or used in a distributed transaction.DataSource
implementation that supports connection pooling produces Connection objects that participate in connection pooling, that is, connections that can be recycled.DataSource
implementation that supports distributed transactions produces Connection objects that can be used in a distributed transaction, that is, a transaction that accesses two or more DBMS servers.Like, in Spring, you can configure the datasource in an XML file and then (1) either inject it into your bean, (2) get it from ApplicationContext
.
DataSource ds = (DataSource) ApplicationContextProvider.
getApplicationContext().getBean("myDataSource");
Connection c = ds.getConnection();
Suggested Reading:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With