Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

Mapping documents:NA

Code between sessionFactory.openSession() and session.close():NA

Full stack trace of any exception that occurs:

Name and version of the database you are using:Oracle 10g

The generated SQL (show_sql=true):NA

Debug level Hibernate log excerpt:


!ENTRY org.hibernate.eclipse.console.HibernateConsolePlugin 4 4 2005-04-11 14:19:08.265
!MESSAGE Error under artifact generation
!STACK 0
org.hibernate.cfg.JDBCBinderException: org.hibernate.mapping.Column(OWNER) already exist in org.hibernate.mapping.Table(null.OLAPSYS.ALL$OLAP2_DIM_LEVEL_ATTR_MAPS)
at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:725)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:106)
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:76)
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:113)
!SUBENTRY 1 org.hibernate.eclipse.console.HibernateConsolePlugin 4 4 2005-04-11 14:19:08.265
!MESSAGE org.hibernate.mapping.Column(OWNER) already exist in org.hibernate.mapping.Table(null.OLAPSYS.ALL$OLAP2_DIM_LEVEL_ATTR_MAPS)
!STACK 0
org.hibernate.cfg.JDBCBinderException: org.hibernate.mapping.Column(OWNER) already exist in org.hibernate.mapping.Table(null.OLAPSYS.ALL$OLAP2_DIM_LEVEL_ATTR_MAPS)
at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:725)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:106)
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:76)
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:113)
!SUBENTRY 2 org.hibernate.eclipse.console.HibernateConsolePlugin 4 150 2005-04-11 14:19:08.265
!MESSAGE org.hibernate.mapping.Column(OWNER) already exist in org.hibernate.mapping.Table(null.OLAPSYS.ALL$OLAP2_DIM_LEVEL_ATTR_MAPS)
!STACK 0
org.hibernate.cfg.JDBCBinderException: org.hibernate.mapping.Column(OWNER) already exist in org.hibernate.mapping.Table(null.OLAPSYS.ALL$OLAP2_DIM_LEVEL_ATTR_MAPS)
at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:725)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:106)
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:76)
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:113)


Trying to generate Atrifacts for ORacle database.
Any ideas? I think this is an Oracle table not mine.

you are scanning the whole db and the oracle system tables has some "extranous" metadata that confuses the rev.eng.

you can limit the scan to a single catalog/schema to avoid this issue - set default catalog and default schema in the hibernate.cfg.xml

(in a future release you will be able to limit it to specific schemas)

When I add
<property name="hibernate.default_schema">schemaName</property>
to the highbernate.cfg.xml file the Artifact Window simple disappears. When I add default_catalog it gives me the same error as before

Any ideas?

Thanks

the config file

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="eSessionFactory">
<property name="hibernate.connection.url">jdbc:oracle:thin:@gondor:1521:orcl</property>
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.connection.password">schemaName</property>
<property name="hibernate.connection.username">schemaName</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
</session-factory>
</hibernate-configuration>

check and see what is output in the error log

The schema name is case sensitive.

Thanks :)