Re: Native SQL Query

2011-08-08 Thread Pinaki Poddar
Thank you for testing and validating the new changes. Enjoy Slice :) - Pinaki Poddar Chair, Apache OpenJPA Project -- View this message in context: http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6664880.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

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

Re: Native SQL Query

2011-08-02 Thread Pinaki Poddar
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 -- View this message in context:

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

Re: Native SQL Query

2011-08-02 Thread Pinaki Poddar
Hi, I just cross checked with a native SQL query on Slice. It does run. Though the new addition lacked thorough testing, I would not expect the error you have reported provided the new changes are applied in your environment. To ensure that the change is available in your environment, please

Re: Native SQL Query

2011-06-14 Thread Pinaki Poddar
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

Re: Native SQL Query

2011-06-06 Thread Rick Curtis
I know this isn't a good answer, but is it possible to use JPQL as opposed to native queries? On Fri, Jun 3, 2011 at 3:40 PM, Chaos907 da...@edelements.com wrote: Below is our persistence.xml. When we are using the persistence-unit platform (no sharding), then createNativeQuery works. But if

Re: Native SQL Query

2011-06-06 Thread Chaos907
For our application we want to support both native queries and JPQL. Does open JPA not support native query under a distributed environment yet? -- View this message in context: http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6446011.html Sent from the OpenJPA Users mailing list

Re: Native SQL Query

2011-06-06 Thread Rick Curtis
I dug around the code a little bit and native queries don't work with slice... I'm not sure if it is a simple bug to fix, or if it will take a large effort to fix. Can I have you open a JIRA[1] for this bug? [1] https://issues.apache.org/jira/browse/OPENJPA On Mon, Jun 6, 2011 at 12:15 PM,

Re: Native SQL Query

2011-06-06 Thread Chaos907
I've created a JIRA issue for this bug: https://issues.apache.org/jira/browse/OPENJPA-2008 -- View this message in context: http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6447446.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.

Re: Native SQL Query

2011-06-03 Thread Michael Dick
Which properties do you have in persistence.xml? A reply on Nabble (not accepted by the mailing list yet) asserts that this only happens with slice. If that's the case we can look into reproducing the problem outside of your container environment. Thanks -mike -- View this message in context:

Re: Native SQL Query

2011-06-03 Thread Chaos907
Thanks for the reply. Yes you are right, we are using a distributed environment (Slice) and we did find out that this only happens when we are using 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

Re: Native SQL Query

2011-06-03 Thread Chaos907
Below is our persistence.xml. When we are using the persistence-unit platform (no sharding), then createNativeQuery works. But if we use the persistence-unit platform-slice, then createNativeQuery fails with the stacktrace in the previous post. ?xml version=1.0 encoding=UTF-8? persistence