Hi,
I was just wonderin if there is a Hibernate IDE for 3.0 yet.

Thanks

The hibernate eclipse plugin's (with JBoss IDE) is the GUI tool kit for Hibernate 3.0 . Its under active development, get eclipse 3.1M6 and get latest JBoss IDE for a test run.

I am using Eclipse 3.1M6 with the JBoss IDE-1.5M1-Hibernate-Tools with Oracle 10g as my database. When trying to reverse engineer the "scott" schema from oracle, I get the following error under artifact generation:

Reason: org.hibernate.exception.GenericJDBCException:Getting database metadata.
I have added classes12.jar in the hibernate console configuration.

Here is my hibernate.cfg.xml 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="test">
<property name="hibernate.connection.username">scott</property>
<property name="hibernate.connection.password">tiger</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
</session-factory>
</hibernate-configuration>

Doing reverse engineering against "scott" using Eclipse 3.1M5, Oracle 10g and JBoss IDE 1.5M1. Now, I am getting the following error after changing my hibernate.cfg.xml to have the following line using the loopback adapter:

<property name="hibernate.connection.url">jdbc:oracle:thin:@10.10.10.10:1521:orcl</property>

Error under artifact generation

Reason:
org.hibernate.cfg.JDBCBinderException:org.hibernate.mapping.Column(AO_OBJ_ID) already exist in
org.hibernate.mapping.Table(DMSYSDM_APPLY_CONTENT_ITEM)

Thanks

Try adding the following line in your configuration file (.cfg.xml)
<property name="hibernate.default_schema">scott</property>

HTH.

I did that and it and it generates the file "GeneralHbmSettings.hbm.xml" but no POJO's are generated for the scott schema.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<!--
Auto-generated mapping file from
the hibernate.org cfg2hbm engine
for General Global Setttings
-->


</hibernate-mapping>

Any other suggestions?

Thanks

try SCOTT

Works!

Thanks

While reverse engineering should we select the join tables during mapping files generation or should we leave'em out?


Thanks

dont know what you mean ;)

in the alpha 1 version you cannot select stuff...

Max,

Do you have any plans to support "selecting" tables in the Hibernate Artifact Generation - during "Reverse Engineer from JDBC Connection".

Thanks.

yes ;)

Max,
I was playing around with http://hibernatesynch.sourceforge.net/ and this plugin lets me select the tables.

But I've another question. Using middlegen to generate hbm files from the database. But middlegen generates mapping files for the join tables (used to resolve many-to-many relationship) as well.

For example: table Album, table Track, table ALBUM_TRACK

table ALBUM_TRACK has
id (pri key)
album_id (fr key)
track_id (fr key)


So is it a good idea to have the mapping files and POJO for those joint tables or should i delete those mapping files and POJOs and edit the associations in hbm files manually?

Thanks for your help.

Middlegen allows you to select if the join tables are generated or not for Many-to-many. This is done with the appropriate Ant tags and settings. See Middlegen docs for further information.

Is there an easy way to make all the properties to have the first char in lowercase? Right now it generates all the properties with first char in uppercase.

For example, it generates:
<property
name="CcNumber"
type="java.lang.String"
>
instead of
<property
name="ccNumber"
type="java.lang.String"
>

Thanks.