• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

EJB QL exception

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am getting following excpetion
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.sql.SQLException: Invalid parameter index 1.

while running EJB QL on j2ee RI server EJB QL query is geting generated properly but while running i am getting the above exception

my query definition in home interface:
public CourseRemote findByCourseId(String courseId) throws RemoteException, FinderException;

the ejb ql query as generated by j2ee ri server:
SELECT OBJECT(c) FROM Course as c
where c.courseId = ?

please help me as query generation is right but whilwe running this stmt:
<CourseRemote courseremoteId = home.findByCourseId("X0001");>

please help e as i have run out of options.. thanks
 
Sheriff
Posts: 67752
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
"vai Avvvva", please check your private messages for an important administrative matter.
 
Sheriff
Posts: 28325
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
And your question might be better posted in a forum which is about EJB. It isn't about XML in any way at all.
 
That is a really big piece of pie for such a tiny ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic