Package org.eclipse.persistence.internal.jpa

Examples of org.eclipse.persistence.internal.jpa.EJBQueryImpl

83
84
85
86
87
88
89
90
   * Rewrite the JPQL query string in a SQL String (The persistence provider implementation in use is EclipseLink)
   * @param query The String of the JPQL query
   * @return the string of the JPQL query translated in SQL
   */
  private String rewriteEclipseLink(String query) {
    EJBQueryImpl qi = (EJBQueryImpl) this.entityManager.createQuery(query);
    return rewriteEclipseLink(qi);
  }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
   * Rewrite the JPQL query in a SQL String (The persistence provider implementation in use is EclipseLink)
   * @param query The JPQL query
   * @return the string of the JPQL query translated in SQL
   */
  private String rewriteEclipseLink(Query query) {
    EJBQueryImpl qi = (EJBQueryImpl) query;
    Session session = this.entityManager.unwrap(JpaEntityManager.class).getActiveSession();
    DatabaseQuery databaseQuery = (qi).getDatabaseQuery();
    databaseQuery.prepareCall(session, new DatabaseRecord());
    String sqlString = databaseQuery.getTranslatedSQLString(session,  new DatabaseRecord());
   
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    Query q  = em.createQuery(query);
   
   
    List<String> queryParameters = new ArrayList<String>();
    queryParameters.add("USA");
    EJBQueryImpl qi = (EJBQueryImpl)q;
    String sqlQueryString = qi.getDatabaseQuery().getSQLString();
    System.out.println(sqlQueryString);
    EJBQueryImpl countQuery = (EJBQueryImpl)em.createNativeQuery("SELECT COUNT(*) FROM (" + sqlQueryString + ") temp");
    for(int i=0; i<queryParameters.size(); i++ ){
      countQuery.setParameter(1+i, queryParameters.get(i));
    }
    System.out.println("result "+countQuery.getDatabaseQuery().getSQLString());


    System.out.println(((Long)countQuery.getResultList().get(0)).intValue());

  }
View Full Code Here
TOP

Related Classes of org.eclipse.persistence.internal.jpa.EJBQueryImpl

  • it.eng.qbe.statement.jpa.JPQL2SQLStatementRewriter
  • it.eng.spagobi.TestJPA
  • org.eclipse.persistence.expressions.Expression
  • org.eclipse.persistence.internal.helper.ConversionManager
  • org.eclipse.persistence.internal.helper.DatabaseField
  • org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree
  • org.eclipse.persistence.internal.jpa.querydef.ParameterExpressionImpl
  • org.eclipse.persistence.platform.database.oracle.plsql.PLSQLargument
  • org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall
  • org.eclipse.persistence.queries.DatabaseQuery
    • Copyright © 2018 www.massapicom. 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.