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