* JBoss DNA (http://www.jboss.org/dna)

* See the COPYRIGHT.txt file distributed with this work for information

* regarding copyright ownership.  Some portions may be licensed

* to Red Hat, Inc. under one or more contributor license agreements.

* See the AUTHORS.txt file in the distribution for a full listing of

* individual contributors.

*

* JBoss DNA is free software. Unless otherwise indicated, all code in JBoss DNA

* is licensed to you under the terms of the GNU Lesser General Public License as

* published by the Free Software Foundation; either version 2.1 of

* the License, or (at your option) any later version.

*

* JBoss DNA is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU

* Lesser General Public License for more details.

*

* You should have received a copy of the GNU Lesser General Public

* License along with this software; if not, write to the Free

* Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA

* 02110-1301 USA, or see the FSF site: http://www.fsf.org.

*/

* Database related utilities

*

* @author <a href="mailto:litsenko_sergey@yahoo.com">Sergiy Litsenko</a>

*/

    /**

     * Logging for this instance

     */

    private static Logger log = Logger.getLogger(DatabaseUtil.class);

    /**

     * Standard UDT types as string

     */

    private static String standardUserDefinedTypes = "JAVA_OBJECT,STRUCT,DISTINCT";

    private static Map<String, Integer> standardUserDefinedTypesMapping = new HashMap<String, Integer>();

    static {

        standardUserDefinedTypesMapping.put("JAVA_OBJECT", new Integer(SqlType.JAVA_OBJECT.getType()));

        standardUserDefinedTypesMapping.put("STRUCT", new Integer(SqlType.STRUCT.getType()));

        standardUserDefinedTypesMapping.put("DISTINCT", new Integer(SqlType.DISTINCT.getType()));

    }

    // ~ Constructors ---------------------------------------------------------------------

    /**

     * Constructor

     */

    private DatabaseUtil() {

    }

    // ~ Methods --------------------------------------------------------------------------

    /**

     * Returns Standard UDT types as string

     *

     * @return Standard UDT types as string

     */

    public static String getStandardUserDefinedTypes() {

        return standardUserDefinedTypes;

    }

    /**

     * Converts string array of UDT names to appropriate int array of UDT types specified in java.sql.Types

     *

     * @param userDefinedTypes the string array of UDT names

     * @return int array of user defined types specified in java.sql.Types

     */

    public static int[] getUserDefinedTypes( String userDefinedTypes ) {

        // convert comma separated list of user defined types to array

        String[] userDefinedTypesStringArray = (userDefinedTypes == null) ? null : userDefinedTypes.split(",");

        // create UDT int array

        int[] userDefinedTypesArray = new int[userDefinedTypesStringArray.length];

        // fill array

        for (int i = 0; i < userDefinedTypesStringArray.length; i++) {

            // get value from map

            Integer udtType = standardUserDefinedTypesMapping.get(userDefinedTypesStringArray[i]);

            // set int value

            userDefinedTypesArray[i] = (udtType == null) ? Types.NULL : udtType.intValue();

        }

        return userDefinedTypesArray;

    }

    /**

     * Returns boolean with respect to NULL values (ResultSet.wasNull())

     *

     * @param resultSet the result set to fetch from

     * @param columnName the name of column

     * @return boolean with respect to NULL values (could be null)

     * @throws SQLException

     */

    public static Boolean getBoolean( ResultSet resultSet,

                                      String columnName ) throws SQLException {

        // check result set

        if (resultSet == null) {

            return null;

        }

        // get boolean

        boolean value = resultSet.getBoolean(columnName);

        // return

        return (resultSet.wasNull()) ? null : (value == true) ? Boolean.TRUE : Boolean.FALSE;

    }

    /**

     * Returns boolean with respect to NULL values (ResultSet.wasNull())

     *

     * @param resultSet the result set to fetch from

     * @param columnName the name of column

     * @param failOnError if true raises exception

     * @return boolean with respect to NULL values (could be null)

     * @throws SQLException

     */

    public static Boolean getBoolean( ResultSet resultSet,

                                      String columnName,

                                      boolean failOnError ) throws SQLException {

        // check result set

        if (resultSet == null) {

            return null;

        }

        // get boolean

        boolean value = false;

        try {

            value = resultSet.getBoolean(columnName);

            // return

            return (resultSet.wasNull()) ? null : (value == true) ? Boolean.TRUE : Boolean.FALSE;

        } catch (SQLException e) {

            if (failOnError) {

                throw e;

            }

            log.error(JdbcMetadataI18n.unableToGetValueFromColumn, columnName, e.getMessage());

            return null;

        }

    }

    /**

     * Returns boolean with respect to NULL values (ResultSet.wasNull())

     *

     * @param resultSet the result set to fetch from

     * @param columnIndex the index of column

     * @return boolean with respect to NULL values (could be null)

     * @throws SQLException

     */

    public static Boolean getBoolean( ResultSet resultSet,

                                      int columnIndex ) throws SQLException {

        // check result set

        if (resultSet == null) {

            return null;

        }

        // get boolean

        boolean value = resultSet.getBoolean(columnIndex);

        // return

        return (resultSet.wasNull()) ? null : (value == true) ? Boolean.TRUE : Boolean.FALSE;

    }

    /**

     * Returns boolean with respect to NULL values (ResultSet.wasNull())

     *

     * @param resultSet the result set to fetch from

     * @param columnIndex the index of column

     * @param failOnError if true raises exception

     * @return boolean with respect to NULL values (could be null)

     * @throws SQLException

     */

    public static Boolean getBoolean( ResultSet resultSet,

                                      int columnIndex,

                                      boolean failOnError ) throws SQLException {

        // check result set

        if (resultSet == null) {

            return null;

        }

        // get boolean

        boolean value = false;

        try {

            value = resultSet.getBoolean(columnIndex);

            // return

            return (resultSet.wasNull()) ? null : (value == true) ? Boolean.TRUE : Boolean.FALSE;

        } catch (SQLException e) {

            if (failOnError) {

                throw e;

            }

            log.error(JdbcMetadataI18n.unableToGetValueFromColumn, columnIndex, e.getMessage());

            return null;

        }

    }

    /**

     * Returns integer with respect to NULL values (ResultSet.wasNull())

     *

     * @param resultSet the result set to fetch from

     * @param columnName the name of column

     * @return integer with respect to NULL values (could be null)

     * @throws SQLException

     */

    public static Integer getInteger( ResultSet resultSet,

                                      String columnName ) throws SQLException {

        // check result set

        if (resultSet == null) {

            return null;

        }

        // get integer

        int value = resultSet.getInt(columnName);

        // return

        return (resultSet.wasNull()) ? null : new Integer(value);

    }

    /**

     * Returns integer with respect to NULL values (ResultSet.wasNull())

     *

     * @param resultSet the result set to fetch from

     * @param columnName the name of column

     * @param failOnError if true raises exception

     * @return integer with respect to NULL values (could be null)

     * @throws SQLException

     */

    public static Integer getInteger( ResultSet resultSet,

                                      String columnName,

                                      boolean failOnError ) throws SQLException {

        // check result set

        if (resultSet == null) {

            return null;

        }

        // get

        int value = 0;

        try {

            value = resultSet.getInt(columnName);

            // return

            return (resultSet.wasNull()) ? null : new Integer(value);

        } catch (SQLException e) {

            if (failOnError) {

                throw e;

            }

            log.error(JdbcMetadataI18n.unableToGetValueFromColumn, columnName, e.getMessage());

            return null;

        }

    }

    /**

     * Returns integer with respect to NULL values (ResultSet.wasNull())

     *

     * @param resultSet the result set to fetch from

     * @param columnIndex the index of column

     * @return integer with respect to NULL values (could be null)

     * @throws SQLException

     */

    public static Integer getInteger( ResultSet resultSet,

                                      int columnIndex ) throws SQLException {

        // check result set

        if (resultSet == null) {

            return null;

        }

        // get integer

        int value = resultSet.getInt(columnIndex);