Since you don't see the problem with connection pooling in play, I suspect your code is structured so that it is holding connections open over the inserts. Without connection pooling, a new connection is created for each DB operation.
It's also possible you've found a bug in c.j.jdbc that is failing to close connections in some situations (which would be more noticeable without connection pooling). Perhaps you can share your code so we can all take a look? Sean On Sun, Jun 17, 2012 at 11:36 AM, Raju Bitter <rajubit...@googlemail.com> wrote: > I'm running into a problem with the clojure/java.jdbc wrapper. In my > program, I'm reading out a large text file and inserting around 24000 > items into one table. After around 18000 items I get the following > error message: > NoRouteToHostException Cannot assign requested address > java.net.PlainSocketImpl.socketConnect (PlainSocketImpl.java:-2) > > When I use c3p0 for connection pooling, I don't see the exception. > http://clojure.github.com/java.jdbc/doc/clojure/java/jdbc/ConnectionPooling.html > > Seems to be a problem with socket connections failing to localhost, > where both the client and MySQL server are running. Has anyone else > experienced the same problem in the past? > > OS: Mint Linux 3.0.0-12-generic #20-Ubuntu SMP Fri Oct 7 14:56:25 UTC > 2011 x86_64 x86_64 x86_64 GNU/Linux > MySQL: 5.1.63-0ubuntu0.11.10.1 > MySQL connector JAR: 5.1.6 > Clojure: 1.3.0 > Java: java version "1.6.0_31" Java(TM) SE Runtime Environment (build > 1.6.0_31-b04) > > Thanks, > Raju -- 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
