I have my own custom version where I bind the generated keys in the metadata of the returned seq. I think that's only valuable for clojure 1.2 though.
The problem with returning an int is that many keys might be generated, though by the far the most common usage is simply an autoincrement column on id. Mark On Aug 11, 1:25 am, Shantanu Kumar <kumar.shant...@gmail.com> wrote: > Noticed that thread earlier. I hope this fresh thread is noticed by > Stephen (C. Gilardi) and others and a consensus can be reached on this > to do in c.c.sql proper. > > Cheers, > Shantanu > > On Aug 11, 1:15 pm, Remco van 't Veer <rwvtv...@gmail.com> wrote: > > > There was a thread about this some months ago; > > > http://groups.google.nl/group/clojure/browse_thread/thread/e95d477830... > > > Somebody came up with his own version of insert-record: > > > http://gist.github.com/373564#LC62 > > > On 2010/08/11 09:10, Shantanu Kumar wrote: > > > > Hi, > > > > I need to retrieve auto-generated IDs after executing INSERT > > > statements (c.c.sql/insert-values ...). Inspecting c.c.sql sources > > > reveals that (in c.c.sql/do-prepared) a prepared statement is made > > > with the connection and then the SQL statement is run in that context. > > > It appears there is a standard API to retrieve the auto-generated IDs: > > > >http://download-llnw.oracle.com/javase/6/docs/api/java/sql/Statement....() > > > > However, this method needs the (prepared) statement object to run. I > > > would suggest adding another "do-prepared-insert" method that does > > > same things as do-prepared but rather return the following: > > > > (.getGeneratedkeys stmt) > > > > Function "insert-values" may be made to call "do-prepared-insert" to > > > suit this. > > > > Cheers, > > > Shantanu -- 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 your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en
