Pb with Spring & Metadat - Mailing list pgsql-jdbc

From TNO
Subject Pb with Spring & Metadat
Date
Msg-id 43EB7D89.4050406@free.fr
Whole thread Raw
Responses Re: Pb with Spring & Metadat  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Hello,

I want to get database information using metadata with Spring (1.2.4).
It's OK with postGre8.0, but when I use postGre8.1, error...

what about this function "information_schema._pg_keypositions()" ?

Caused by: org.springframework.jdbc.support.MetaDataAccessException:
Error while extracting DatabaseMetaData; nested exception is
org.postgresql.util.PSQLException: ERROR: function
information_schema._pg_keypositions() does not exist
   at
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:180)

   at
arc.bd.spring.service.TableService.fillRelation1_1(TableService.java:181)
   ... 4 more
Caused by: org.postgresql.util.PSQLException: ERROR: function
information_schema._pg_keypositions() does not exist
   at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)

   at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)

   at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)

   at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)

   at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)

   at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)

   at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3237)

   at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3533)

   at
arc.bd.spring.callback.ImportedKeyInfo.processMetaData(ImportedKeyInfo.java:28)

   at
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:174)

   ... 5 more

--
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs



pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: New releases for 8.0, 8.1, and 8.2dev
Next
From: till toenges
Date:
Subject: Re: Bug in TypeInfoCache causes getObject to fail