Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
- Subject: Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
- From: Mike Schrag <email@hidden>
- Date: Wed, 14 May 2008 08:02:59 -0400
As an aside, could anyone suggest why this error would occur? Is
Entity Modeler (or more likely, I suppose, the JDBC layer) executing
some of these generated SQL statements concurrently, and hence
exceeding 30 connections?
No ... We do fire up EOF, and EOF leaves a connection open after
starting things up -- I should try to forcefully close that when SQL
gen is done. That you're getting THIRTY is really suspicious. I just
did a test and I only get one, but you PROBABLY get one per
classloader, which would mean at least one per project that SQL gen
in, and if you change your classpath, you'd get an extra one. So I
can totally believe they build up over time. You can check this by
running:
"SELECT datname,procpid,current_query FROM pg_stat_activity ORDER BY
procpid ;"
in psql and it will show a row per connection. Can you restart
eclipse, run this before sql gen, sql gen, run again, and see what it
shows? In 5.3 + latest PG plugin from Wonder, this is one connection.
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden