Examples of org.hibernate.Query.executeUpdate()

org.hibernate.Query.executeUpdate()
Execute the update or delete statement.
The semantics are compliant with the ejb3 Query.executeUpdate() method. @return The number of entities updated or deleted. @throws HibernateException


                    // Delete aggregated tables
                    deleteHql = "delete from "+ DataSourceTableEntry.class.getName() + " where datasource = :datasource";
                    deleteQuery = session.createQuery(deleteHql);
                    deleteQuery.setString("datasource", dsName);
                    deleteQuery.executeUpdate();


                    // Delete the data source.
                    dSource.delete();
                }}.execute();
            }

View Full Code Here

        HibernateTxFragment txFragment = new HibernateTxFragment() {
            protected void txFragment(Session session) throws Exception {
                String[] arrTableName=getSelectedTables().split(",");
                String deleteHql = "delete from "+DataSourceTableEntry.class.getName() + " where datasource = '"+getName()+"'";
                Query deleteQuery = session.createQuery(deleteHql);
                deleteQuery.executeUpdate();
                for(int i=0;i<arrTableName.length;i++){
                    DataSourceTableEntry tableEntry = new DataSourceTableEntry();
                    tableEntry.setDatasource(getName());
                    tableEntry.setName(arrTableName[i]);
                    tableEntry.setSelected("true");

View Full Code Here

                    session.saveOrUpdate(tableEntry);
                }


                deleteHql = "delete from " + DataSourceColumnEntry.class.getName() + " where datasource = '"+getName()+"'";
                deleteQuery = session.createQuery(deleteHql);
                deleteQuery.executeUpdate();
                for(int i=0;i<arrTableName.length;i++){
                    List tableColumns = getTableColumns(arrTableName[i]);
                    Iterator it = tableColumns.iterator();
                    while(it.hasNext()){
                        DataSourceColumnEntry columnEntry = (DataSourceColumnEntry) it.next();

View Full Code Here

    queryText.append(" WHERE  tarea.id = ?");
    
    Query query = getSession().createQuery(queryText.toString());
    query.setInteger(0, id);
    
    query.executeUpdate();
  }


}

View Full Code Here

    queryText.append(" WHERE  objetivo.id = ?");
    
    Query query = getSession().createQuery(queryText.toString());
    query.setInteger(0, id);
    
    query.executeUpdate();
  }
  
}

View Full Code Here

                protected void txFragment(Session session) throws Exception {
                    // Delete aggregated table columns
                    String deleteHql = "delete from " + DataSourceColumnEntry.class.getName() + " where datasource = :datasource";
                    Query deleteQuery = session.createQuery(deleteHql);
                    deleteQuery.setString("datasource", dsName);
                    deleteQuery.executeUpdate();


                    // Delete aggregated tables
                    deleteHql = "delete from "+ DataSourceTableEntry.class.getName() + " where datasource = :datasource";
                    deleteQuery = session.createQuery(deleteHql);
                    deleteQuery.setString("datasource", dsName);

View Full Code Here


                    // Delete aggregated tables
                    deleteHql = "delete from "+ DataSourceTableEntry.class.getName() + " where datasource = :datasource";
                    deleteQuery = session.createQuery(deleteHql);
                    deleteQuery.setString("datasource", dsName);
                    deleteQuery.executeUpdate();


                    // Delete the data source.
                    dSource.delete();
                }}.execute();
            }

View Full Code Here

        HibernateTxFragment txFragment = new HibernateTxFragment() {
            protected void txFragment(Session session) throws Exception {
                String[] selectedTableNames = getSelectedTables().split(",");
                String deleteHql = "delete from "+DataSourceTableEntry.class.getName() + " where datasource = '"+getName()+"'";
                Query deleteQuery = session.createQuery(deleteHql);
                deleteQuery.executeUpdate();
                for (String tableName : selectedTableNames) {
                    DataSourceTableEntry tableEntry = new DataSourceTableEntry();
                    tableEntry.setDatasource(getName());
                    tableEntry.setName(tableName);
                    tableEntry.setSelected("true");

View Full Code Here

                    session.saveOrUpdate(tableEntry);
                }


                deleteHql = "delete from " + DataSourceColumnEntry.class.getName() + " where datasource = '"+getName()+"'";
                deleteQuery = session.createQuery(deleteHql);
                deleteQuery.executeUpdate();
                for (String tableName : selectedTableNames) {
                    List<DataSourceColumnEntry> tableColumns = getTableColumns(tableName);
                    for (DataSourceColumnEntry columnEntry : tableColumns) {
                        session.saveOrUpdate(columnEntry);
                    }

View Full Code Here

    final Transaction transaction = session.getTransaction();
    try {
      transaction.begin();
      final Query query = session.createQuery(UPDATE_BATCH_FOR_BASKETS)
          .setLong(0, t.getId());
      query.executeUpdate();
      session.delete(t);
      transaction.commit();
    } catch (final HibernateException e) {
      LOGGER.error(e);
      throw new DataNotRemovedException(

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.