Skip to Content.
Sympa Menu

grouper-dev - head+postgres test failure

Subject: Grouper Developers Forum

List archive

head+postgres test failure

Chronological Thread 
  • From: "Tom Zeller" <>
  • To: "Grouper Dev" <>
  • Subject: head+postgres test failure
  • Date: Mon, 30 Jun 2008 12:34:05 -0500
  • Domainkey-signature: a=rsa-sha1; c=nofws;; s=gamma; h=message-id:date:from:sender:to:subject:mime-version:content-type :x-google-sender-auth; b=NyvNlBnA9+eynoszeLn+Ml6XcLk7ne4rFfbLMn+IMbVK+r+3bfIkBOWufHomzJxNtn 6yW2Z4dFtzkQffKe2dI2WFbgTGW9cfxIVXTRfsagGd4qDVxRCObYn9LtWYZCX1+a/A1C j7Sz3BryggDomRnLjQZ1cb9tgb+jckZ/28Bo8=

I checked out grouper head to look at hooks, and found that when using postgres the tests fail.

In Hib3MembershipDAO.reset (line 477) :

 HibUtils.executeSql("update grouper_memberships gm set gm.PARENT_MEMBERSHIP = null", null);

doesn't seem to work for postgres, but the following does :

 HibUtils.executeSql("update grouper_memberships set PARENT_MEMBERSHIP = null"null);

From the postgres manual "Do not include the table's name in the specification of a target column — for example, UPDATE tab SET tab.col = 1 is invalid."

The error is:

java.lang.RuntimeException: Problem with sql: update grouper_memberships gm set gm.PARENT_MEMBERSHIP = null,


Caused by: org.postgresql.util.PSQLException: ERROR: column "gm" of relation "grouper_memberships" does not exist

I guess executeSql() should be replaced by executeHql() or somesuch ?

I'm not sure why 1.4 'exposed' this,


  • head+postgres test failure, Tom Zeller, 06/30/2008

Archive powered by MHonArc 2.6.16.

Top of Page