Example usage for org.hibernate.dialect Dialect getQuerySequencesString

Introduction

In this page you can find the example usage for org.hibernate.dialect Dialect getQuerySequencesString.

Prototype

public String getQuerySequencesString() 

Source Link

Document

Get the select command used retrieve the names of all sequences.

Usage

From source file:com.clican.pluto.orm.tool.DatabaseMetadata.java

License:LGPL

private void initSequences(Connection connection, Dialect dialect) throws SQLException {
    if (dialect.supportsSequences()) {
        String sql = dialect.getQuerySequencesString();
        if (sql != null) {

            Statement statement = null;
            ResultSet rs = null;//  w  ww  .  j a v a2s. c  om
            try {
                statement = connection.createStatement();
                rs = statement.executeQuery(sql);

                while (rs.next()) {
                    sequences.add(rs.getString(1).toLowerCase().trim());
                }
            } finally {
                if (rs != null)
                    rs.close();
                if (statement != null)
                    statement.close();
            }

        }
    }
}

---

From source file:org.jboss.pnc.datastore.repositories.DefaultSequenceHandlerRepository.java

License:Open Source License

@Override
public boolean sequenceExists(final String sequenceName) {
    ReturningWork<Boolean> work = new ReturningWork<Boolean>() {
        @Override/*ww  w  . ja v a 2  s .  c  o  m*/
        public Boolean execute(Connection connection) throws SQLException {
            DialectResolver dialectResolver = new StandardDialectResolver();
            Dialect dialect = dialectResolver.resolveDialect(getResolutionInfo(connection));
            PreparedStatement preparedStatement = null;
            ResultSet resultSet = null;
            try {
                preparedStatement = connection.prepareStatement(dialect.getQuerySequencesString());
                resultSet = preparedStatement.executeQuery();
                while (resultSet.next()) {
                    if (sequenceName.equals(resultSet.getString(1))) {
                        return true;
                    }
                }
            } catch (SQLException e) {
                throw e;
            } finally {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
                if (resultSet != null) {
                    resultSet.close();
                }
            }
            return false;

        }
    };

    Session session = (Session) entityManager.getDelegate();
    SessionFactory sessionFactory = session.getSessionFactory();
    return sessionFactory.getCurrentSession().doReturningWork(work);
}

---

From source file:org.jboss.pnc.datastore.repositories.SequenceHandlerRepository.java

License:Open Source License

public boolean sequenceExists(final String sequenceName) {
    ReturningWork<Boolean> work = new ReturningWork<Boolean>() {
        @Override//from   ww w  .ja v  a  2s.co  m
        public Boolean execute(Connection connection) throws SQLException {
            DialectResolver dialectResolver = new StandardDialectResolver();
            Dialect dialect = dialectResolver.resolveDialect(connection.getMetaData());
            PreparedStatement preparedStatement = null;
            ResultSet resultSet = null;
            try {
                preparedStatement = connection.prepareStatement(dialect.getQuerySequencesString());
                resultSet = preparedStatement.executeQuery();
                while (resultSet.next()) {
                    if (sequenceName.equals(resultSet.getString(1))) {
                        return true;
                    }
                }
            } catch (SQLException e) {
                throw e;
            } finally {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
                if (resultSet != null) {
                    resultSet.close();
                }
            }
            return false;

        }
    };

    Session session = (Session) entityManager.getDelegate();
    SessionFactory sessionFactory = session.getSessionFactory();
    return sessionFactory.getCurrentSession().doReturningWork(work);
}

---