openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey" <plins...@gmail.com>
Subject Re: How to get the compiled JPQL query string as SQL
Date Thu, 05 Jul 2007 20:53:25 GMT
That was a bug (OPENJPA-278). Sorry about that. It's fixed now.

-Patrick

On 7/5/07, Daniel Migowski <dmigowski@ikoffice.de> wrote:
>
>  Hello Patrick,
>
>  I tried to compile, too, but this is what my code delivered:
>
>          Query q = em.createQuery("select currency.name, currency.isoCode3
> "+
>                                   "from Currency
> currency");
>
>          for (Object[] o :
> (List<Object[]>)q.getResultList()) {
>              System.out.println(o[0] + " - " + o[1]);
>  ... prints all the names and isocodes ...
>          }
>
>          OpenJPAQuery q2 = (OpenJPAQuery)q;
>          System.out.println(q2.getQueryString());
>  ... prints "select currency.name, currency.isoCode3 from Currency currency"
> ...
>
>          q2 = q2.compile();
>
>          System.out.println(q2.getLanguage());
>  ... prints something about JPQL ...
>
>             String[] actions = q2.getDataStoreActions(null);
>          for( String s : actions ) {
>              System.out.println(s);
>          }
>  ... prints nothing, since the array has the size 0 ...
>
>  Just looking at the log does not help, because i need the query to modify
> it and work around the but in my previous post :))
>
>  Greetings,
>  Daniel Migowski
>
>
>
>  Patrick Linskey schrieb:
> If you're just looking to get logging data, you can just set the
>  'openjpa.Log' property to 'SQL=TRACE'.
>
>  However, getDatastoreActions() should return the strings. Can you post
>  the code corresponding code snippet? Also, what happens if you do
>  ((OpenJPAQuery) myQuery).compile() before trying to get the actions?
>  (I don't have the source in front of me right now, so that's a bit of
>  a shot in the dark.)
>
>  -Patrick
>
>  On 7/5/07, Daniel Migowski <dmigowski@ikoffice.de> wrote:
>
> Hi OpenJPA users,
>
>  Is there a wy to get the SQL the would be executed, if I execute a
>  JPQL-query? The method
> (OpenJPAQuery)myQuery).getDatastoreActions()
>  always returns an empty String array.
>
>  With best regards,
>  Daniel Migowski
>
>
>
>
>
>
> --
>  |¯¯|¯¯| IKOffice GmbH Daniel Migowski
>  | | |/| Mail: dmigowski@ikoffice.de
>  | | // | Nordstr. 10 Tel.: +49 (441) 21 98 89 52
>  | | \\ | 26135 Oldenburg Fax.: +49 (441) 21 98 89 55
>  |__|__|\| http://www.ikoffice.de Mob.: +49 (176) 22 31 20 76
>
>  Geschäftsführer: Ingo Kuhlmann, Daniel Migowski
>  Amtsgericht Oldenburg, HRB 201467
>


-- 
Patrick Linskey
202 669 5907

Mime
View raw message