Have you tried the do-prepared function?

On Mar 5, 5:43 am, rdunklau <rdunk...@gmail.com> wrote:
> Hello.
>
> I'm trying to use clojure.contrib.sql to set up my database (on
> postgresql)
> However, i'm running into some problems : I did not find a way to
> execute a (prepared) statement outside a transaction WITHOUT returning
> the results.
>
> What I tried so far:
>
> (def mystatement "CREATE DATABASE mydb WITH TEMPLATE = template0
> ENCODING = 'UTF8' LC_COLLATE = 'fr_FR.utf8' LC_CTYPE = 'fr_FR.utf8';")
>
> (do-commands mystatement)
>
> --> PSQLException:
>  Message: ERROR: CREATE DATABASE cannot run inside a transaction block
>
> (with-query-results rs mystatement)
>
> -->org.postgresql.util.PSQLException: No results were returned by the
> query.
>
> So, is there any function which exposes the
> PreparedStatement.executeUpdate() method directly ?
>
> Thanks !

-- 
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

Reply via email to