DataSource: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
No edit summary
 
(22 intermediate revisions by the same user not shown)
Line 5: Line 5:


=Internal=
=Internal=
* [[JDBC]]


=Overview=
=Overview=


This page refers to a JSE [https://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html javax.sql.DataSource]. The DataSource is part of [[JDBC]] and it is the main interface exposed by the<tt>javax.sql</tt> package. A DataSource is a JSE concept since Java 1.4.
This page refers to a JSE [https://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html javax.sql.DataSource]. The DataSource is part of [[JDBC]] and it is the main interface exposed by the <tt>javax.sql</tt> package. DataSource is part of JSE since 1.4. JDBC specifies that a database Connection can be obtained from a DriverManager or a DataSource. The DataSource is the preferred way of getting the Connection. JEE also mentions DataSource, defining it as a [[JCA_Concepts#Resource_Manager|resource manager]] connection factory for <tt>java.sql.Connection</tt> objects.
 
=DataSource Instance Initialization=
 
A DataSource instance can be injected by annotating a field or a method of a JEE component with the JEE [[@javax.annotation.Resource|@javax.annotation.Resource]] annotation:
 
<syntaxhighlight lang='java'>
import javax.sql.DataSource;
 
...
 
@Resource(name="java:/DefaultDS")
DataSource ds;
 
@Resource(name="java:/DefaultDS")
public void setDataSource(DataSource ds) {
  this.ds = ds;
}
</syntaxhighlight>
 
For more details on attributes supported by the @Resource annotation see: {{Internal|@javax.annotation.Resource|@javax.annotation.Resource}}
 
A DataSource can also be looked up in JNDI:
 
<syntaxhighlight lang='java'>
import javax.sql.DataSource;
 
...
 
DataSource ds = (DataSource)ic.lookup("java:/DefaultDS");
</syntaxhighlight>
 
=Connection Life Cycle=
 
<syntaxhighlight lang='java'>
import java.sql.Connection;
 
...
 
DataSource ds;
 
Connection c;
 
try {
 
  c = ds.getConnection();
 
  ...
 
}
finally {
 
  if (c != null) {
 
      c.close();
  }
}
</syntaxhighlight>


=JDBC API Usage=


DataSources can be injected with the JEE [[@javax.annotation.Resource|@javax.annotation.Resource]] annotation.
{{Internal|JDBC API Usage|JDBC API Usage}}

Latest revision as of 14:47, 26 September 2017

External

Internal

Overview

This page refers to a JSE javax.sql.DataSource. The DataSource is part of JDBC and it is the main interface exposed by the javax.sql package. DataSource is part of JSE since 1.4. JDBC specifies that a database Connection can be obtained from a DriverManager or a DataSource. The DataSource is the preferred way of getting the Connection. JEE also mentions DataSource, defining it as a resource manager connection factory for java.sql.Connection objects.

DataSource Instance Initialization

A DataSource instance can be injected by annotating a field or a method of a JEE component with the JEE @javax.annotation.Resource annotation:

import javax.sql.DataSource;

...

@Resource(name="java:/DefaultDS")
DataSource ds;

@Resource(name="java:/DefaultDS")
public void setDataSource(DataSource ds) {
   this.ds = ds;
}

For more details on attributes supported by the @Resource annotation see:

@javax.annotation.Resource

A DataSource can also be looked up in JNDI:

import javax.sql.DataSource;

...

DataSource ds = (DataSource)ic.lookup("java:/DefaultDS");

Connection Life Cycle

import java.sql.Connection;

...

DataSource ds;

Connection c;

try {

  c = ds.getConnection();
  
  ...

}
finally {

  if (c != null) {

      c.close();
  }
}

JDBC API Usage

JDBC API Usage