Welcome Guest  |  Register  |  Login
Login Name Password
  Search  
  Index  | Recent Threads  | Unanswered Threads  | Who's Online  | Help


Quick Go »

No member browsing this thread
Thread Status: Active
Total posts in this thread: 3
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 1636 times and has 2 replies Next Thread
Male mumu
Newbie




Joined: Aug 29, 2006
Post Count: 5
Status: Offline
Reply to this Post  Reply with Quote 
call a Stored Procedure

i want to call a stored procedure in my JDOQL-Statement like this:

Query query = new Query(...)
query.setFilter("userid == doAdd(1, 2)")

doAdd should be a stored procedure which does something and gives an integer as a result.

It is clear that JPOX says that it doesnt knows doAdd, but how can i tell JPOX that it should call the Stored Function doAdd.

thx
[Aug 29, 2006 9:01:08 PM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest [Link] Report threatening or abusive post: please login first  Go to top 
Male andy
Expert
Member's Avatar

UK
Joined: Mar 13, 2004
Post Count: 5686
Status: Offline
Reply to this Post  Reply with Quote 
Re: call a Stored Procedure

i want to call a stored procedure in my JDOQL-Statement like this:

http://www.jpox.org/docs/1_1/query_sql.html
----------------------------------------
-Andy smile

[Aug 30, 2006 4:50:44 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male mumu
Newbie




Joined: Aug 29, 2006
Post Count: 5
Status: Offline
Reply to this Post  Reply with Quote 
Re: call a Stored Procedure

thank you for your quick answer.

But on this link is only described how i call a single Stored Procedure, but i want to call the function within a select-query.
query.setFilter("userid == doAdd(1, 2)")
(doAdd should be the stored procedure (function))

how can i do that?
[Aug 30, 2006 6:58:48 AM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest [Link] Report threatening or abusive post: please login first  Go to top 
[ Jump to Last Post ]
Show Printable Version of Thread  Post new Thread