Great! Thank you very much!
With best regards,
Daniel Migowski
Patrick Linskey schrieb:
That was a bug (OPENJPA-278). Sorry about that. It's fixed
now.
-Patrick
On 7/5/07, Daniel Migowski <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
| | // | 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
--
|¯¯|¯¯| IKOffice GmbH Daniel Migowski
| | |/| Mail: [EMAIL PROTECTED]
| | // | 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
|
