Hello, Your use-case is a very common one, and we strive to help new users get started as quickly as possible. For this, we are maintaining a small Spring-DBCP-jOOQ tutorial, which is based on Petri Kainulainen's tutorial here:
- Petri's tutorial: http://www.petrikainulainen.net/programming/jooq/using-jooq-with-spring-configuration/ - Our tutorial: http://www.jooq.org/doc/latest/manual/getting-started/tutorials/jooq-with-spring/ I suggest that you follow this tutorial. Spring for transactions will help you scale this setup to any size of web application. As far as the connection pool is concerned, you can easily replace DBCP with your favourite pool. Hope this helps, Lukas 2014-04-02 18:02 GMT+02:00 siki <[email protected]>: > Hi, > > I've been doing Java development for a quite a while but haven't done it > for a few years. Returning to it after this hiatus, I'm just overwhelmed > with the amount of APIs and libraries, especially when it comes to managing > DB connections, transactions, etc. There's Hibernate, Spring, BoneCP, > HikariCP, and the list goes on. I know I'm mixing apples and oranges here a > bit, but there are so many options to achieve essentially the same thing > and most of them have poor or missing documentation, sloppy use-case > demonstrations, and are grossly over-engineered IMO. > > I'm glad I found JOOQ as it seems to help me get to where I want to be, > plus it has great, clear documentation which helps a lot. I appreciate the > fact that it allows the user the ability to manage DB access separately, > however this is where I'm lost a bit. > > I want to write multi threaded server-side applications that query a DB > (Postgres, for now). I want to be able to do things within transactions and > sometimes outside of transactions. I (think I) need some kind of a > connection pool manager because I'll have multiple threads (sometimes 100s) > running at the same time. I have found HikariCP and I like the "looks" of > it very much. > > Do I need something like Spring or Hibernate or any other framework for > this or can I do without? (to manage transactions, for example) Basically > I'd like to be able to quickly (read: with one line of code) get a > connection (or DSLContext for Jooq), (optionally) begin a transaction, > execute some SQL via Jooq, and (optionally) close the transaction. > > Any and all help is greatly appreciated! Thanks Lukas for creating and > maintaining this wonderful library! > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
