• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
      • From: Paul Hoadley <email@hidden>
References: 
 >Generated SQL failing to execute cleanly with PostgreSQL: a fix (From: Paul Hoadley <email@hidden>)

  • Prev by Date: Re: takeFormValuesFromRequest problem
  • Next by Date: Re: takeFormValuesFromRequest problem
  • Previous by thread: Generated SQL failing to execute cleanly with PostgreSQL: a fix
  • Next by thread: Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
  • Index(es):
    • Date
    • Thread