• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Bear Bibeault
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Piet Souris
  • salvin francis
  • Stephan van Hulst
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Jj Roberts

JBoss-QL in 3.2.x Vs 3.0.x

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Im using the following JBoss-QL query in JBoss 3.2.x :
SELECT OBJECT(f) FROM Filme f WHERE f.tipoFilme.tipo = ?1 and f.vitrine = true order by f.codigo desc limit ?2
and it works perfectly.
When i deployed my application on JBoss 3.0.x, a FinderException is thrown complaining about the limit clause:
09:04:29,067 ERROR [STDERR] javax.ejb.FinderException: Error compiling ejbql: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "limit" at line 1, column 103.
Was expecting one of:
<EOF>
"," ...

Is there a syntax diference between 3.2.x and 3.0.x ?
Doesnt JBoss-QL in 3.0.x support the limit clause ?
Thanks in advance ...
Thomas
 
The world's cheapest jedi mind trick: "Aw c'mon, why not read this tiny ad?"
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic