Hibernate Tools Reveng does not work with generated-class

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

Hi,

I've tried to use the meta attribute "generated-class" inside the hibernate.reveng.xml but it did not work... I've tried several configurations:

Code:

<hibernate-reverse-engineering>
   <table-filter match-name="email_messages">
      <meta attribute="generated-class">EmailMessage</meta>
   </table-filter>
</hibernate-reverse-engineering>

Code:

<hibernate-reverse-engineering>
   <table-filter match-name="email_messages"/>
   <table name="email_messages" class="EmailMessage"/>
</hibernate-reverse-engineering>

Code:

<hibernate-reverse-engineering>
   <table-filter match-name="email_messages"/>
   <table name="email_messages" class="EmailMessage">
      <meta attribute="generated-class">EmailMessage</meta>
   </table>
</hibernate-reverse-engineering>

Any idea? I can not do it using hbm.xml as I'm just using POJO with annotations...

Thanks,
Leonardo

max · **Posted:** Fri Oct 12, 2007 1:43 am

What db ? casing might be relevant.

How does your generate classes look like ?

How are you calling this ?

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

Database: Mysql 5
Database Driver: Mysql JDBC 5.0.7

The classname looks like the default name (camelCase): "EmailMessages".

I'm using ant task to invoke hibernate tools:

Code:

<taskdef name="hibernatetool"
        classname="org.hibernate.tool.ant.HibernateToolTask"
        classpathref="class.path"/>

<target name="hbm2java" description="hbm2java">
         <hibernatetool destdir="${src-hbmtools.dir}">
            <jdbcconfiguration configurationfile="${hbm.tools}/hibernate-mysql.cfg.xml"
                             revengfile="${hbm.tools}/hibernate.reveng.xml"
                         packagename="bizservices.test.model"
                         detectmanytomany="true"/>            
                <!-- Generate POJOs -->
            <hbm2java jdk5="true" ejb3="true"/>
         </hibernatetool>
</target>

hibernate-mysql.cfg.xml

Code:

<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/dpst</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">xxxxx</property>
        <property name="hibernate.default_schema">DPST</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
    </session-factory>
</hibernate-configuration>

max · **Posted:** Fri Oct 12, 2007 9:22 am

you did not show me the actual generated files. please do.

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

OK...

EmailMessages.java

Code:

package bizservices.test.model;

import bizservices.framework.model.BaseModel;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;

/**
 * Model Class: EmailMessages 
 * @author HibernateTools3.2.0.b9 12-Oct-2007 9:24:28 AM
 */
@Entity
@Table(name="email_messages"
      ,uniqueConstraints = @UniqueConstraint(columnNames="EML_MSG_CD")) 
@NamedQuery(name  = "jpql.EmailMessages.by.uk",
         query = "select o from EmailMessages o where o.emlMsgCd = :emlMsgCd")
public class EmailMessages extends BaseModel {

    @Id 
    @Column(name="EML_MSG_ID", unique=true, nullable=false)     
   private int emlMsgId;

    @Column(name="EML_MSG_CD", unique=true, nullable=false, length=30)     
   private String emlMsgCd;

    @Column(name="EML_MSG_SUBJECT", nullable=false)     
   private String emlMsgSubject;

   /**
    * Default Constructor
    */
   public EmailMessages() {
   }
   /**
    * Minimum Constructor
    */
   public EmailMessages(int emlMsgId, String emlMsgCd, String emlMsgSubject) {
      this.emlMsgId = emlMsgId;
      this.emlMsgCd = emlMsgCd;
      this.emlMsgSubject = emlMsgSubject;
   }
   public int getEmlMsgId() {
      return this.emlMsgId;
   }
   public void setEmlMsgId(int emlMsgId) {
      this.emlMsgId = emlMsgId;
   }

   public String getEmlMsgCd() {
      return this.emlMsgCd;
   }
   public void setEmlMsgCd(String emlMsgCd) {
      this.emlMsgCd = emlMsgCd;
   }

   public String getEmlMsgSubject() {
      return this.emlMsgSubject;
   }
   public void setEmlMsgSubject(String emlMsgSubject) {
      this.emlMsgSubject = emlMsgSubject;
   }
}

PojoTypeDeclaration.ftl:

Code:

/**
 * Model Class: ${pojo.getDeclarationName()} 
 * @author HibernateTools${version} ${date}
 */
<#include "Ejb3TypeDeclaration.ftl"/>
${pojo.getClassModifiers()} ${pojo.getDeclarationType()} ${pojo.getDeclarationName()} extends ${pojo.importType("bizservices.framework.model.BaseModel")} {

If you need to see more templates, let me know...

By the way, is it possible to attach some file in this forum?

Thanks again!

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

Do you have some idea to solve this problem? or anybody?

Thanks!

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

Do you have some idea to solve this problem? or anybody?

Thanks!

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

Do you have some idea to solve this problem? or anybody?

Thanks!

max · **Posted:** Wed Oct 17, 2007 12:49 am

I can't see why your match shouldn't be found since the table name matches.

What is weird though is that the table names seem to be in lower case, but columns in uppercase ...not seen that before.

Have you tried using uppercase table names in the filter?

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

If I use uppercase, no file is generated as if the table had not been found... The DDL for the table is:

Code:

CREATE TABLE email_messages ( 
    EML_MSG_ID        int(11) AUTO_INCREMENT NOT NULL,
    EML_MSG_CD        VARCHAR(30) NOT NULL,
    EML_MSG_SUBJECT     VARCHAR(255) NOT NULL,
    PRIMARY KEY(EML_MSG_ID)
);
ALTER TABLE email_messages
    ADD CONSTRAINT EMAIL_MESSAGES_CD_UK
   UNIQUE (EML_MSG_CD);

However, I can do:

SELECT * FROM EMAIL_MESSAGES
or
SELECT * FROM email_messages

Both work...

Thanks for helping again!

max · **Posted:** Thu Oct 18, 2007 1:23 am

if that is the case then the following *must* work:

Code:

<hibernate-reverse-engineering> 
   <table-filter match-name="email_messages"/> 
   <table name="email_messages" class="EmailMessage"/> 
</hibernate-reverse-engineering>

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

Yeah, but unfortunetly it is not working... It generates the classname as EmailMessages... Any idea? Did you try it?

By the way, I'm using hibernate tools beta9, because I got some errors using beta10 in my eclipse (3.2)...

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

Any ideia? May I open a jira request?

max · **Posted:** Wed Oct 24, 2007 4:40 pm

sure,but please try with latest release first.

leopinho · **Joined:** Sun Sep 30, 2007 2:58 pm **Posts:** 26

I tried using the latest version CR1 and didn't work. So I created a Jira request:

http://opensource.atlassian.com/projects/hibernate/browse/HBX-1031