Re: Pb with Spring & Metadat

I have both postgre8.0 and 8.1 on my station.
8.0 on port 5432 and 8.1 on port 54321

when I use pg8.0 and driver postgresql-8.0-315.jdbc3.jar, works fine...
when I use pg8.1 and driver postgresql-8.1-404.jdbc3.jar error !

here's the full trace

arc.bd.service.exception.ArcException:
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
arc.bd.spring.service.TableService.fillRelation1_1(TableService.java:194)
at arc.bd.spring.service.TableService.fillTable(TableService.java:107)
at arc.bd.spring.service.TableService.getTablePg(TableService.java:67)
at
arc.bd.spring.service.TestTableService.testTableService(TestTableService.java:15)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
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)
... 18 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)
... 19 more

Kris Jurka a écrit :

>
>
> On Thu, 9 Feb 2006, TNO wrote:
>
>> 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()" ?
>>
>> org.postgresql.util.PSQLException: ERROR: function
>> information_schema._pg_keypositions() does not exist
>> at
>
>
> If you're going to use a 8.1 server you need the 8.1 driver as well.
>
> Kris Jurka
>
>
>
>