👋:skin-tone-4: - I'd like to use java.jdbc with postgres jsonb. is there something specific i need to do in order to work with such types?

I get this error when I try to insert:

user=> (j/insert-multi! db :schemas [ {:datab {:hello 123}} ])

PSQLException ERROR: column "datab" is of type jsonb but expression is of type hstore
  Hint: You will need to rewrite or cast the expression.
  Position: 40  org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:2412)

Take a look at http://clojure-doc.org/articles/ecosystem/java_jdbc/using_sql.html#protocol-extensions-for-transforming-values

PostgreSQL is kinda weird with so many custom data types 😐

Or you could use raw SQL with a CAST() in it, via the j/execute! function

ah cool! thanks for pointing me in the right direction. so i'll have to modify a few protocols and i should be set! definitely weird 🙂

BTW, there’s a java.jdbc mailing list so once you have that working, you might consider joining that list and posting your solution there so it’s in the archives for the future!

https://groups.google.com/group/clojure-java-jdbc

oh that would be great! thanks

No, thank you (in advance!).

That documentation is community-maintained so feel free to add issues and/or send PRs.