Package org.hibernate

Examples of org.hibernate.Session.createSQLQuery()

381
382
383
384
385
386
387
388
389
390
391
        }
      }

    }

    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("stepCount", StandardBasicTypes.DOUBLE);
    query.addScalar("stepName", StandardBasicTypes.STRING);
    query.addScalar("stepOrder", StandardBasicTypes.DOUBLE);
View Full Code Here
466
467
468
469
470
471
472
473
474
475
476
    // adding time restrictions
    String natSQL = new SQLStepRequestsImprovedDiscrimination(this.timeFilterFrom, this.timeFilterTo, this.timeGrouping, this.myIDlist)
        .SQLMaxStepOrder(requestedType);

    Session session = Helper.getHibernateSession();
    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("maxStep", StandardBasicTypes.DOUBLE);

    @SuppressWarnings("rawtypes")
View Full Code Here
493
494
495
496
497
498
499
500
501
502
503
    // adding time restrictions
    String natSQL = new SQLStepRequestsImprovedDiscrimination(this.timeFilterFrom, this.timeFilterTo, this.timeGrouping, this.myIDlist)
        .SQLMinStepOrder(requestedType);

    Session session = Helper.getHibernateSession();
    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("minStep", StandardBasicTypes.DOUBLE);

    @SuppressWarnings("rawtypes")
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
    } else {
      natSQL = new ImprovedSQLProduction(this.timeFilterFrom, this.timeFilterTo, this.timeGrouping, IDlist).getSQL(stepname);
    }
    Session session = Helper.getHibernateSession();

    SQLQuery query = session.createSQLQuery(natSQL);

    // needs to be there otherwise an exception is thrown
    query.addScalar("volumes", StandardBasicTypes.INTEGER);
    query.addScalar("pages", StandardBasicTypes.INTEGER);
    query.addScalar("intervall", StandardBasicTypes.STRING);
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
    Session session = sessionFactory.openSession();
    try {
      for (String query : cleanSql) {
        // log.trace(query);
        session.createSQLQuery(query).executeUpdate();
      }
    } finally {
      session.close();
    }
  }
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
    String recordsLeftMsg = "";
    Session session = sessionFactory.openSession();
    try {
      for (String tableName : tableNames) {
        String countSql = "select count(*) as RECORD_COUNT_ from "+tableName;
        SQLQuery sqlQuery = session.createSQLQuery(countSql);
        sqlQuery.addScalar("RECORD_COUNT_", Hibernate.LONG);
        Long recordCount = (Long) sqlQuery.uniqueResult();
        if (recordCount>0L) {
          recordsLeftMsg += tableName+":"+recordCount+", ";
        }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    }


    public TipoDeficiencia pesquisarTipoDeficienciaPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_deficiencia.*} FROM tipo_deficiencia {tipo_deficiencia} WHERE cod_tipo_deficiencia = "+cod);

        query.addEntity("tipo_deficiencia", TipoDeficiencia.class);

        TipoDeficiencia df = null;
        if(query.list().size() > 0){
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
        return df;
    }

    public TipoDeficiencia pesquisarTipoDeficienciaPorDescricao(String desc){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_deficiencia.*} FROM tipo_deficiencia {tipo_deficiencia} WHERE descricao like '"+desc+"'");

        query.addEntity("tipo_deficiencia", TipoDeficiencia.class);

        TipoDeficiencia df = null;
        if(query.list().size() > 0){
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    }


    public List pesquisarTipoDeficienciaTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_deficiencia.*} FROM tipo_deficiencia {tipo_deficiencia}");

        query.addEntity("tipo_deficiencia", TipoDeficiencia.class);

        List df = query.list();

View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    }


    public TipoSitOcupacional pesquisarTipoSitOcupacionalPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_sit_ocupacional.*} FROM tipo_sit_ocupacional {tipo_sit_ocupacional} WHERE cod_tipo_sit_ocupacional = "+cod);

        query.addEntity("tipo_sit_ocupacional", TipoSitOcupacional.class);

        TipoSitOcupacional to = null;
        if(query.list().size() > 0){
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.