Re: [JDBC] ERROR: No such attribute or function 'oid'

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-----
Från: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] För milend
Skickat: Sunday, March 30, 2003 11:30 PM
Till: pgsql-general(at)postgresql(dot)org; pgsql-jdbc(at)postgresql(dot)org
Ämne: [JDBC] ERROR: No such attribute or function 'oid'

Hi,

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(at)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:1
894)
[java] at
org.dspace.storage.rdbms.DatabaseManager.retrieveColumnInfo(DatabaseMana
ger.java:1078)
[java] at
org.dspace.storage.rdbms.DatabaseManager.getColumnInfoInternal(DatabaseM
anager.java:1044)
[java] at
org.dspace.storage.rdbms.DatabaseManager.getColumnInfo(DatabaseManager.j
ava: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(at)localhost dspace]$