fr.ifremer.adagio.synchro.dao

Class DaoUtils

Object

DaoUtils

public class DaoUtils
extends Object

Usefull method around DAO and entities.

Since:

3.5.4

Author:

Benoit Lavenier

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	DaoUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static void	closeSilently(Connection connection)
static void	closeSilently(ResultSet statement)
static void	closeSilently(Session session)
static void	closeSilently(Statement statement)
static Connection	createConnection(Properties connectionProperties)
static Connection	createConnection(String jdbcUrl, String user, String password)
static void	fillConnectionProperties(Properties p, String url, String username, String password)
static Configuration	getConfiguration(Properties connectionProperties)
static Properties	getConnectionProperties(String jdbcUrl, String username, String password, String schema, String dialect, String driver) Create a new hibernate configuration, with all hbm.xml files for the schema need for app
static Dialect	getDialect(Properties connectionProperties)
static String	getJdbcUrl(File directory, String dbName)
static String	getUrl(Properties connectionProperties)
static boolean	isFileDatabase(String jdbcUrl)
static boolean	isValidConnectionProperties(Properties connectionProperties) Check if connection properties are valid.
static boolean	isValidConnectionProperties(String jdbcDriver, String jdbcUrl, String user, String password) Check if connection properties are valid.
static SQLExceptionConverter	newSQLExceptionConverter(Dialect dialect) Override default Hibernate 'org.hibernate.tool.hbm2ddl.DatabaseMetadata', because of th use of deprecated method buildSqlExceptionConverter() (see https://hibernate.atlassian.net/browse/HHH-9131)
static void	shutdownDatabase(Connection connection)
static void	shutdownDatabase(Properties connectionProperties)
static int	sqlUpdate(Connection connection, String sql)

Methods inherited from class Object

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

Constructor Detail

DaoUtils

protected DaoUtils()

Method Detail

getConnectionProperties

public static Properties getConnectionProperties(String jdbcUrl,
                                 String username,
                                 String password,
                                 String schema,
                                 String dialect,
                                 String driver)

Create a new hibernate configuration, with all hbm.xml files for the schema need for app

Returns:

the hibernate Configuration

newSQLExceptionConverter

public static SQLExceptionConverter newSQLExceptionConverter(Dialect dialect)

Override default Hibernate 'org.hibernate.tool.hbm2ddl.DatabaseMetadata', because of th use of deprecated method buildSqlExceptionConverter() (see https://hibernate.atlassian.net/browse/HHH-9131)

Returns:

shutdownDatabase

public static void shutdownDatabase(Properties connectionProperties)
                             throws SQLException

Throws:

SQLException

closeSilently

public static void closeSilently(Statement statement)

closeSilently

public static void closeSilently(Connection connection)

closeSilently

public static void closeSilently(ResultSet statement)

closeSilently

public static void closeSilently(Session session)

createConnection

public static Connection createConnection(Properties connectionProperties)
                                   throws SQLException

Throws:

SQLException

createConnection

public static Connection createConnection(String jdbcUrl,
                          String user,
                          String password)
                                   throws SQLException

Throws:

SQLException

fillConnectionProperties

public static void fillConnectionProperties(Properties p,
                            String url,
                            String username,
                            String password)

getJdbcUrl

public static String getJdbcUrl(File directory,
                String dbName)

isFileDatabase

public static boolean isFileDatabase(String jdbcUrl)

isValidConnectionProperties

public static boolean isValidConnectionProperties(Properties connectionProperties)

Check if connection properties are valid. Try to open a SQL connection, then close it. If no error occur, the connection is valid.

Parameters:

jdbcDriver -

jdbcUrl -

user -

password -

Returns:

isValidConnectionProperties

public static boolean isValidConnectionProperties(String jdbcDriver,
                                  String jdbcUrl,
                                  String user,
                                  String password)

Check if connection properties are valid. Try to open a SQL connection, then close it. If no error occur, the connection is valid.

Parameters:

jdbcDriver -

jdbcUrl -

user -

password -

Returns:

getUrl

public static String getUrl(Properties connectionProperties)

getDialect

public static Dialect getDialect(Properties connectionProperties)

getConfiguration

public static Configuration getConfiguration(Properties connectionProperties)

shutdownDatabase

public static void shutdownDatabase(Connection connection)

sqlUpdate

public static int sqlUpdate(Connection connection,
            String sql)