Glad to hear this problem is solved. I was a bit worried about
PostgreSQL leaking connections in light of our recent discussions on
user.
I also noticed that we need 1.2.3 Maven bundles under [1]. Tore,
could you please run "ant mvn-bundle -Dproject.version=1.2.3" and
appload all generated *bundle.jar files to people.apache.org? I just
updated the release guide to include this step.
Thanks
Andrus
[1] http://people.apache.org/~torehalset/release/1.2.3/
On May 7, 2007, at 1:56 AM, Tore Halset wrote:
Hello.
Working on the release today I got a problem with testing on
PostgreSQL. Others did not see the problem. The problem was that to
many connections to the database was opened, but not closed.
ERROR CayenneTestResources: Error generating schema...
org.postgresql.util.PSQLException: ERROR: language "plpgsql" does
not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults
(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute
(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute
(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
(AbstractJdbc2Statement.java:337)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute
(AbstractJdbc2Statement.java:329)
at org.objectstyle.cayenne.unit.AccessStackAdapter.executeDDL
(AccessStackAdapter.java:217)
at org.objectstyle.cayenne.unit.AccessStackAdapter.executeDDL
(AccessStackAdapter.java:226)
at org.objectstyle.cayenne.unit.PostgresStackAdapter.createdTables
(PostgresStackAdapter.java:99)
at org.objectstyle.cayenne.unit.AbstractAccessStack.createSchema
(AbstractAccessStack.java:304)
at org.objectstyle.cayenne.unit.SimpleAccessStack.createSchema
(SimpleAccessStack.java:156)
at org.objectstyle.cayenne.unit.CayenneTestResources.rebuildSchema
(CayenneTestResources.java:228)
at org.objectstyle.cayenne.unit.CayenneTestResources.loadResources
(CayenneTestResources.java:135)
at org.objectstyle.cayenne.unit.CayenneTestResources.getResources
(CayenneTestResources.java:158)
at org.objectstyle.cayenne.unit.CayenneTestCase.<init>
(CayenneTestCase.java:101)
at org.objectstyle.cayenne.query.SelectQueryBase.<init>
(SelectQueryBase.java:63)
at org.objectstyle.cayenne.query.SelectQueryTst.<init>
(SelectQueryTst.java:75)
After issuing a "createlang plpgsql cayenne" the problem went away
and all tests pass. Even with this SQLException, the Connections
should be closed.
Regards,
- Tore.
