Re: [JDBC] ERROR: No such attribute or function 'oid' - Mailing list pgsql-general
| From | Patrik Lundgren |
|---|---|
| Subject | Re: [JDBC] ERROR: No such attribute or function 'oid' |
| Date | |
| Msg-id | 000b01c2f706$e440ed80$0300a8c0@energy Whole thread Raw |
| In response to | ERROR: No such attribute or function 'oid' (milend <milend@ansco.com>) |
| List | pgsql-general |
When you want to get the oid column you have to specify it in the sql query. Example: SELECT oid, * FROM <table>. If the query is just: SELECT * FROM <table> then the oid column won't be included. The exception message you get is what you would get if the oid colum is not specified in the query and then asked for.
Since this is not a query you have written yourself, changing isn't an option. It would be helpfull if you posted the code you are using, most importantly which arguments are used for the getColumns method in DatabaseMetadata.
Regards,
Patrik Lundgren
-----Ursprungligt meddelande-----Hi,
Från: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] För milend
Skickat: Sunday, March 30, 2003 11:30 PM
Till: pgsql-general@postgresql.org; pgsql-jdbc@postgresql.org
Ämne: [JDBC] ERROR: No such attribute or function 'oid'
I have postgresql 7.2.3-5.80 running on RedHat 8.0 distribution.
I got the error message:
ERROR: No such attribute or function 'oid'
I'm using the JDBC driver that comes with RedHat 8.0 Distribution.
I'm able to create tables in the database but metadata.getColumns() fails.
Does anyone else have the same problem?
What possibly could be the reason for this error message?
Any help will be greatly appreciated!
Thank you in advance!
Milen
P.S. please find detailed error log bellow:
-----------------------------------------------------------------------------
[dspace@localhost dspace]$ ant fresh_install
Buildfile: build.xml
update:
install_code:
setup_database:
[java] 2003-03-30 16:09:44,832 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
load_registries:
[java] 2003-03-30 16:09:48,518 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:
[java] java.sql.SQLException: ERROR: No such attribute or function 'oid'
[java] at org.postgresql.Connection.ExecSQL(Connection.java:533)
[java] at org.postgresql.Connection.ExecSQL(Connection.java:400)
[java] at org.postgresql.jdbc2.DatabaseMetaData.getColumns(DatabaseMetaData.java:1894)
[java] at org.dspace.storage.rdbms.DatabaseManager.retrieveColumnInfo(DatabaseManager.java:1078)
[java] at org.dspace.storage.rdbms.DatabaseManager.getColumnInfoInternal(DatabaseManager.java:1044)
[java] at org.dspace.storage.rdbms.DatabaseManager.getColumnInfo(DatabaseManager.java:525)
[java] at org.dspace.storage.rdbms.DatabaseManager.getColumnNames(DatabaseManager.java:584)
[java] at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:260)
[java] at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:358)
[java] at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:205)
[java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:172)
[java] at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:111)
BUILD FAILED
file:/dspace/build.xml:257: Java returned: 1
Total time: 7 seconds
[dspace@localhost dspace]$
pgsql-general by date: