Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JPA 2.1 NamedStoredProcedureQuery using

 
Ilkin Abdullayev
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
Oracle procedure(REGION table in hr scheme)



I could call StoredProcedure by the waydynamically)



Run succesed:
[EL Info]: 2015-07-07 14:46:09.746--ServerSession(1948868640)--EclipseLink, version: Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5
[EL Info]: connection: 2015-07-07 14:46:10.006--ServerSession(1948868640)--file:/C:/xampp/htdocs/StoredProcedureWithJPA/build/classes/_StoredProcedureWithJPAPU login successful
Americas
-----------------------------------------------------------------------------------
But dont work below way:





Output error:
Exception in thread "main" java.lang.IllegalStateException: No value was bound to parameter named: reg_name
at org.eclipse.persistence.internal.jpa.QueryImpl.getParameterValue(QueryImpl.java:1098)
at storedprocedurewithjpa.StoredProcedureWithAnnotation.main(StoredProcedureWithAnnotation.java:31)
Java Result: 1

What do I do?Please help
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic