Re: Native SQL Query

2011-08-02 Thread lspasam 
Any updates? Has this been tested yet?

On 06/14/2011 02:37 PM, Pinaki Poddar [via OpenJPA] wrote:
 If possible, try revision 1135806 from trunk.

 I have committed a draft version that would execute SQL in Slice. I 
 have not tested it and I have concerns about sorting etc.

 If possible, let me know whether it gets you out of NPE.
 Also check for ORDER By or SUM() type support which perhaps will 
 simply not work.
 Pinaki


 
 If you reply to this email, your message will be added to the 
 discussion below:
 http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6476092.html 

 To unsubscribe from Native SQL Query, click here 
 http://openjpa.208410.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=6432918code=bGVzQGVkZWxlbWVudHMuY29tfDY0MzI5MTh8LTE3NTY0MTAyMjc=.
  



-- 
Les Pasamonte
Engineering
Edelements Inc.



--
View this message in context: 
http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6645883.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Native SQL Query

2011-08-02 Thread lspasam 
I just checked out, built and ran the code against revision 1135806.  
Error is the same. Attached:

Caused by: java.lang.NullPointerException
 at 
org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:154)
 at 
org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:672)
 at 
org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:640)
 at 
org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)
 ... 51 more

Please advise.

Thanks!

On 08/02/2011 11:41 AM, Pinaki Poddar [via OpenJPA] wrote:
  Any updates? Has this been tested yet?
 As a brave user of Open Source software, you will be testing it, I 
 hoped :)
 Of course, It is checked-in with some degree of testing.
 Pinaki Poddar
 Chair, Apache OpenJPA Project


 
 If you reply to this email, your message will be added to the 
 discussion below:
 http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6645971.html 

 To unsubscribe from Native SQL Query, click here 
 http://openjpa.208410.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=6432918code=bGVzQGVkZWxlbWVudHMuY29tfDY0MzI5MTh8LTE3NTY0MTAyMjc=.
  



--
View this message in context: 
http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6646144.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Native SQL Query

2011-06-06 Thread lspasam 
Additional information I found, is that this only happens in a Distributed
environment (Slice).  Below is the method that is returning null for
ExpressionParser.  At this point in execution, language is openJpa.SQL. 
There doesn't seem to be an ExpressionParser mapped to this language.



public StoreQuery newQuery(String language) {
ExpressionParser parser =
QueryLanguages.parserForLanguage(language);
DistributedStoreQuery ret = new DistributedStoreQuery(this, parser);
for (SliceStoreManager slice : _slices) {
ret.add(slice.newQuery(language));
}
return ret;
}


Is this a bug or is native queries not going to be supported in a sliced
environment?



--
View this message in context: 
http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6433509.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.