Re: Clojure Stored Procedure

2013-08-07 Thread ArturoH
+1 here. Has anyone been able to write stored procedures in Java? -- -- You received this message because you are subscribed to the Google Groups Clojure group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with

Re: Clojure Stored Procedure

2011-12-15 Thread Vinzent
Hello, I'm interested in this kind of thing too. Do you have any progress? -- You received this message because you are subscribed to the Google Groups Clojure group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient

Clojure Stored Procedure

2011-11-19 Thread Ghadi Shayban
I'm trying to load and execute an Oracle Java Stored Procedure... written in Clojure. Has anyone successfully managed to do this? Are you done throwing up? I would appreciate any direction I have a little clj that is AOT compiled, and I load the whole jar into the DB successfully. What I'm

Re: Clojure Stored Procedure

2011-11-19 Thread willyh
Here's how I do it with clojure.java.jdbc: (defn do-stored Executes an (optionally parameterized) SQL callable statement on the open database connection. Each param-group is a seq of values for all of the parameters. [sql param-groups] (with-open [stmt (.prepareCall (sql/connection)

Re: Clojure Stored Procedure

2011-11-19 Thread Ghadi Shayban
Your code calls an existing stored procedure on the database. I'm wondering about *creating* a native Java stored procedure *inside* the database. Oracle supports Java 1.5 inside the DB, might as well use clojure. On Nov 19, 3:34 pm, willyh wheine...@gmail.com wrote: Here's how I do it with

Re: Clojure Stored Procedure

2011-11-19 Thread willyh
Sorry. I read your message too fast. Cheers, Willy On Nov 19, 3:52 pm, Ghadi Shayban gshay...@gmail.com wrote: Your code calls an existing stored procedure on the database.  I'm wondering about *creating* a native Java stored procedure *inside* the database.  Oracle supports Java 1.5 inside