Hi,

I seem to be having some trouble reverse engineering my postgres database using the reverse engineer tool in the hibernate eclipse plugin.

Tool version Alpha 4a


Name and version of the database you are using:postgres version 7.4.7

OS: linux

Key Error The column name FKTABLE_CAT not found. What does this mean??

Stack trace:

!SUBENTRY 2 org.hibernate.eclipse.console.HibernateConsolePlugin 4 150 2005-08-10 15:32:07.248
!MESSAGE Reading from database
!STACK 0
org.hibernate.exception.GenericJDBCException: Reading from database
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:125)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:213)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:77)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:210)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:147)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:127)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:95)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:105)
Caused by: org.postgresql.util.PSQLException: The column name FKTABLE_CAT not found.
at org.postgresql.jdbc1.AbstractJdbc1ResultSet.findColumn(AbstractJdbc1ResultSet.java:673)
at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:475)
at org.hibernate.cfg.JDBCBinder.processForeignKeys(JDBCBinder.java:1041)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:119)
... 8 more
!SUBENTRY 2 org.hibernate.eclipse.console.HibernateConsolePlugin 4 150 2005-08-10 15:32:07.248
!MESSAGE The column name FKTABLE_CAT not found.
!STACK 0
org.postgresql.util.PSQLException: The column name FKTABLE_CAT not found.
at org.postgresql.jdbc1.AbstractJdbc1ResultSet.findColumn(AbstractJdbc1ResultSet.java:673)
at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:475)
at org.hibernate.cfg.JDBCBinder.processForeignKeys(JDBCBinder.java:1041)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:119)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:213)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:77)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:210)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:147)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:127)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:95)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:105)

so postgressql does not include the jdbc API specified columns when reading exportedkeys. surprisingly..

Max,

Does this mean you cannot reverse engineer a postgres database? Or is there another jdbc driver that I can use?

thanks,
Glenn

try with their latest version - i'm surprised they dont obey the jdbc api