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.
