fr.cnes.sitools.datasource.jdbc.business
Class SitoolsSQLDataSourceFactory

java.lang.Object
  fr.cnes.sitools.datasource.jdbc.business.SitoolsSQLDataSourceFactory

public final class SitoolsSQLDataSourceFactory
extends java.lang.Object

DataSources configuration / lookup via JNDI Use of connection pools ApacheDbcp

Author:

jp.boignard (AKKA Technologies)

See Also:

TODO rendre plus parametrable pour que les DataSources puissent être précisément créés au demarrage du serveur Restlet à partir de la lecture du fichier de configuration

Method Summary

static java.util.ArrayList<SitoolsSQLDataSource>	getAll() Get an array of all DataSources
static SitoolsSQLDataSource	getDataSource(java.lang.String dsName) Get the DataSource by name
static SitoolsSQLDataSourceFactory	getInstance() Get an instance of SitoolsDatasource
static javax.sql.DataSource	getJNDIDataSource(java.lang.String dsName) Retrieval of a DataSource as a JNDI resource Lookup the DataSource, which will be backed by a pool that the application server provides.
static void	removeDataSource(java.lang.String dsName) removeDataSource
SitoolsSQLDataSource	setupDataSource(java.lang.String driver, java.lang.String connectURI, java.lang.String userName, java.lang.String password, java.lang.String schemaOnConnection) Local creation of a DataSource
SitoolsSQLDataSource	setupDataSourceForUsers(JDBCDataSource dataSource) Setup a dataSource for "users".

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getInstance

public static SitoolsSQLDataSourceFactory getInstance()

Get an instance of SitoolsDatasource

Returns:

an instance of SitoolsDatasource

setupDataSource

public SitoolsSQLDataSource setupDataSource(java.lang.String driver,
                                            java.lang.String connectURI,
                                            java.lang.String userName,
                                            java.lang.String password,
                                            java.lang.String schemaOnConnection)

Local creation of a DataSource

Parameters:

driver - the database driver

connectURI - the URI to connect

userName - the database user name

password - the password

schemaOnConnection - the schema on connection

Returns:

SitoolsDataSource a standard data source for SITools

setupDataSourceForUsers

public SitoolsSQLDataSource setupDataSourceForUsers(JDBCDataSource dataSource)

Setup a dataSource for "users". Usage is for all users for consultation functions.

Parameters:

dataSource - the DataSource to update

Returns:

SitoolsDataSource the new DataSource

removeDataSource

public static void removeDataSource(java.lang.String dsName)

removeDataSource

Parameters:

dsName - the name of the DataSource to remove

getDataSource

public static SitoolsSQLDataSource getDataSource(java.lang.String dsName)

Get the DataSource by name

Parameters:

dsName - the identifier of the DataSource

Returns:

SitoolsDataSource

getJNDIDataSource

public static javax.sql.DataSource getJNDIDataSource(java.lang.String dsName)

Retrieval of a DataSource as a JNDI resource Lookup the DataSource, which will be backed by a pool that the application server provides. DataSource instances are also a good candidate for caching as an instance variable, as JNDI lookups can be expensive as well.

Parameters:

dsName - JNDI resource name

Returns:

DataSource

getAll

public static java.util.ArrayList<SitoolsSQLDataSource> getAll()

Get an array of all DataSources

Returns:

an Array of DataSource