Middlegen for Hibernate

In case anyone else had trouble getting started with middlegen, there is
a handy download at sourceforge:
http://prdownloads.sourceforge.net/hibernate/?sort_by=date&sort=desc
(also linked from the downloads section) of the hibernate site.

It is pretty close to plug and play, and has helped me a great deal with
understanding middlegen.

Thanks to all involved.

hi,
   I set up the middlegen-hibernate-r2 and configure the buid.xml and 
oracle.xml and then execute the ant command,but exception out is there 
is no tables .but i am sure there is lots of tables with my oracle.xml 
configuration. 
    Doesn't It support oracle generation?

I am using middlegen and hibernate to generate hbm.xml files and java
files from an existing database.  My ant script runs middlegen and all
the output files from that process are written to the build dir. 
Consequently  an "ant clean" will remove all that generated code.  I
would like to keep this behaviour as that is what you would expect a
clean to do.  What I want to do is skip the middlgen target if the
database has not changed.  Any suggestions on how to do this?  I have
looked at the ant "uptodate" task but I can't see how to effectively use
that.

I noticed in the example above there is a unless="middlegen.skip" and
thought maybe you have figured out a way to do what I want to do.

Thanks for any input. 

Craig Duncan

On 06 Jan 2004 21:33, craigduncan wrote:

>I am using middlegen and hibernate to generate hbm.xml files and java
>files from an existing database.  My ant script runs middlegen and all
>the output files from that process are written to the build dir.
>Consequently  an "ant clean" will remove all that generated code.  I
>would like to keep this behaviour as that is what you would expect a
>clean to do.  What I want to do is skip the middlgen target if the
>database has not changed.  Any suggestions on how to do this?  I have
>looked at the ant "uptodate" task but I can't see how to effectively
use
>that.

>I noticed in the example above there is a unless="middlegen.skip" and
>thought maybe you have figured out a way to do what I want to do.

>Thanks for any input.

>Craig Duncan


How you detect the database has changed is difficult. If you can just 
set the proerty and your done. If you cannot, you would know as a 
developer (maybe), so you can set the property on the Ant command line 
prepared for processing the target.

(using middlegen preview downloaded from hibernate sourceforge; 
Middlegen-Hibernate-r4.zip)
When using MySQL the relations of the airline example is not detected. 
As a solution you should download middlegen from the middlegen website 
and extract the "mysql-connector-java-3.0.0-beta-bin.jar" from the 
archive and put that into the /lib/ directory. When you do that 
relations are getting detected.

Seems that the developers from Middlegen does not seem to reply some 
questions...

I can't get middlegen to work with db2 and to generate my mapping 
files for hibernate... The problem is on the driver that for some 
reason does not work...

Does anybody have a clue on this?

You must use InnoDB tables (and have the foreign keys set) for Middlegen
to pick up the relationships.

If you already have MyISAM tables, see...

http://www.mysql.com/doc/en/Converting_tables_to_InnoDB.html

I was able to pick up relationships using
mysql-connector-java-3.0.10-stable-bin.jar.

ernani,

   Your \config\database\db2.xml file should look something like the 
following. I have DB2 installed to c:\sqllib.


   <!-- 
=================================================================== -->
   <!-- ant properties/targets for IBM 
DB2                                   -->
   <!-- note: this is not a proper xml file (there is no root 
element)      -->
   <!--       it is intended to be imported from a *real* xml 
file          -->
   <!-- 
=================================================================== -->

   <property name="sqllib.home"                    value="C:/sqllib"/>
   <property name="database.script.file"           
value="${src.dir}/sql/${name}-db2.sql"/>
   <property name="database.driver.file"           
value="${sqllib.home}/java/db2java.zip"/>
   <property name="database.driver.classpath"      
value="${database.driver.file}"/>
   <property name="database.driver"                
value="COM.ibm.db2.jdbc.app.DB2Driver"/>
   <property name="database.url"                   
value="jdbc:db2:SAMPLE"/>
   <property name="database.userid"                value="userid"/>
   <property name="database.password"              value="password"/>
   <property name="database.schema"                value="CLEX"/>
   <property name="database.catalog"               value=""/>


Your build.xml should contain the following...

<!DOCTYPE project [
    <!ENTITY database SYSTEM "file:./config/database/db2.xml">
]>

See if those work for you

Cheers
Chris

There is one other thing to keep in mind with the Hibernate plugin for 
Middlegen. In the build.xml file, on roughly line 145, in 
the "middlegen" target, you may need to modify these lines:
  schema="${database.schema}"
  catalog="${database.catalog}"

I had to delete the "catalog=..." line before I could get things 
working with a DB2400 database. It seems that even if this property is 
empty, passing it as a parameter may cause an error that middlegen 
cannot find any tables. (The forums mention you may need to remove one 
or both the lines to get things working). Beyond following Chris' 
suggestion, adding a few "<table..." tags and tweaking the default 
generated package names, it seems to be working for me.

I downloaded the package and ran it against a mysql database, and 
well, how do I get my .java files? :-)

I do see my relationships and a bunch of .hbm.xml files, but nothing 
else.

Did I miss something?

Thanks,
Acco

On 02 Apr 2004 09:37, Acco Lade wrote:

>I downloaded the package and ran it against a mysql database, and
>well, how do I get my .java files? :-)

>I do see my relationships and a bunch of .hbm.xml files, but nothing
>else.

>Did I miss something?

>Thanks,
>Acco

Correction: I used version R4 and the latest xyz-11 JDBC connector 
from mysql.com.

On 02 Apr 2004 09:39, Acco Lade wrote:

>On 02 Apr 2004 09:37, Acco Lade wrote:

>>I downloaded the package and ran it against a mysql database, and
>>well, how do I get my .java files? :-)

>>I do see my relationships and a bunch of .hbm.xml files, but nothing
>>else.

>>Did I miss something?

>>Thanks,
>>Acco

>Correction: I used version R4 and the latest xyz-11 JDBC connector
>from mysql.

One way to get it working is to:

1. add target hbm2java(I copied it from the Middlegen build.xml) to 
your build.xml.

2. modify target compile-hibernate by adding hbm2java to the depends 
(see below).

3. add any missing .jars from Middlegen.  To download Middlegen you 
can go to: http://sourceforge.net/project/showfiles.php?group_id=36044 
then unzip the files. I was in a rush so I copied the files in the 
Middlegen lib folder to your lib folder.  You may only need to add the 
hibernate jars ??

<!-- ============================================================= -->
<!-- Run hbm2java                                                  -->
<!-- ============================================================= -->
<target name="hbm2java" depends="middlegen" 
        description="Generate .java from .hbm files.">
  <taskdef
    name="hbm2java"
    classname="net.sf.hibernate.tool.hbm2java.Hbm2JavaTask"
    classpathref="lib.class.path"
  />
		
  <hbm2java output="${build.gen-src.dir}">
  <fileset dir="${build.gen-src.dir}">
  <include name="**/*.hbm.xml"/>
  </fileset>
  </hbm2java>
</target>

---------------------------------------------------

<!-- ============================================================= -->
<!-- Compile business logic (hibernate)                            -->
<!-- ============================================================ -->
   <target name="compile-hibernate" depends="middlegen, hbm2java" 
           description="Compile hibernate Business Domain Model">
...

I can't seem to get middlegen-hibernate-r4 to work with db2. My
build.xml has...

      <middlegen
         appname="${name}"
         prefsdir="${src.dir}"
         gui="${gui}"
         databaseurl="${database.url}"
         initialContextFactory="${java.naming.factory.initial}"
         providerURL="${java.naming.provider.url}"
         datasourceJNDIName="${datasource.jndi.name}"
         driver="${database.driver}"
         username="${database.userid}"
         password="${database.password}"
         schema="${database.schema}"
         catalog="${database.catalog}"
      >

As suggested in the previous posts, I tried removing the catalog, then
schema, then both. No luck. If I remove both, I can see it scanning each
table and shows a message saying that it did not generate any mapping
since the schema is not specified. Like...


[middlegen] (middlegen.MiddlegenPopulator        929 ) The table named
EXPENSETYPE was found in the schema named "DBA". However, Middlegen was
not configured to look for tables in a specific schema. You should
consider specifying schema="DBA" in the middlegen task.


But if I specify schema as "DBA", I get 

Middlegen successfully connected to the database, but couldn't find any
tables. Perhaps the specified schema or catalog is wrong? -Or maybe
there aren't any tables in the database at all?

I cannot help other than pointing out that Middlegen is using a 
standard JDBC connection. Once you have the appropriate configuration 
then its up to the JDBC driver to provide the meta data about the 
database. In your case, your tables are likely to not be under the DBA 
schema. Ask your DBA to tell you the owner of the tables.

Does anyone know to make middlegen to read in subset of tables in a 
schema? I only want to map new tables. 

Middlegen tried to read in all tables in my schema. It takes forever 
to finish. As of writing this, it is still running!

On 08 Jun 2004 19:09, alu wrote:

>Does anyone know to make middlegen to read in subset of tables in a
>schema? I only want to map new tables.

>Middlegen tried to read in all tables in my schema. It takes forever
>to finish. As of writing this, it is still running!

It's possible to specify table names, but it's also ugly.  See the 
Middlegen site documentation on the ant target options.

We run it on a database with 500+ tables, takes 5 minutes to complete 
using the full catalogue and passing it through hbm2java.  With a 
properly defined ant target structure this is only done once and the 
output is sent to a jar in a dependency list.  Subsequent compiles 
ignore it and go straight to compiling application code.

Hi,

I solved this problem by removing the 
schema="${database.schema}
catalog="${database.catalog}
lines from the build.xml file.

After this, everything started to work as expected.

On 10 Mar 2004 06:49, wiverson wrote:

>You must use InnoDB tables (and have the foreign keys set) for Middlegen
>to pick up the relationships.

>If you already have MyISAM tables, see...

>http://www.mysql.com/doc/en/Converting_tables_to_InnoDB.html

>I was able to pick up relationships using
>mysql-connector-java-3.0.10-stable-bin.jar.


I have the 3.0.14 version of this driver and still cannot pick up the
relationships. I know its not the driver as the eclipse plugin Hibernate
Synchroniser can pick up the relationships with this driver.

Is there some sort of option I am supposed to pass to the ant script to
pick up the relationships?

I'm trying to run middlegen against an oracle database. It does 
connect to the db and finds the table in question but I get the 
following message:

middlegen.MiddlegenException: Wow! Synonym DWPTD not found. How can it 
happen?

Anyone knows what this means?

- ayush

Can the middlegen plugin do Sequence name generation.  I'm using the
plugin with Postgresql which creats it's sequences in the form
<tablename>_<idcolumnname>_seq.  As of now i'm editing the structure in
middlegen to make the appropriate tables use sequence key generation and
manually type in the sequence name for each table. Is there a way I can
get middlegen to do that for me?

I try to define my own JavaTypeMapper.
i set the value of my class to the property "javaTypeMapper" in the
hibernate section of my ant file.
then i start middlengen via ant and it seems that my mapper is never call.

more exactly, the constructor is called, but the method
"getPreferredJavaType" is never called


any idea ?

thx in advance
Christophe

When I use the build.xml file, I can create the tables and see them in
Pointbase, but the middlegen task fails, saying the tables aren't
there!!!  Here are my Pointbase-specific property settings.  I tried it
with and without the schema and catalog settings:

   <property environment="env"/>

   <property name="database.script.file"     
value="${src.dir}/sql/${name}-pointbase.sql"/>
   <property name="database.driver.file"     
value="C:/sftwTools/pointbase/lib/pbclient44.jar"/>
   <property name="database.driver.classpath"
value="${database.driver.file}"/>
   <property name="database.driver"          
value="com.pointbase.jdbc.jdbcUniversalDriver"/>
   <property name="database.url"             
value="jdbc:pointbase:server://localhost:9093/workshop"/>
   <property name="database.userid"           value="weblogic"/>
   <property name="database.password"         value="weblogic"/>
   <property name="database.schema"           value=""/>
   <property name="database.catalog"          value=""/>

   <property name="jboss.datasource.mapping"  value="Pointbase"/>

C:\sftwTools\Middlegen-Hibernate-r3>ant middlegen
Buildfile: build.xml

init:

fail-if-no-xdoclet-1.2:

check-driver-present:

panic-if-driver-not-present:

middlegen:
     [echo] Class path = C:\sftwTools\Middlegen-Hibernate-r3
[middlegen] Database URL:jdbc:pointbase:server://localhost:9093/workshop

BUILD FAILED
C:\sftwTools\Middlegen-Hibernate-r3\build.xml:130:
middlegen.MiddlegenException:
 The database doesn't have any table named weblogic.PERSONS.  Please
make sure t
he table exists. Also note that some databases are case sensitive.

Total time: 1 second
C:\sftwTools\Middlegen-Hibernate-r3>


What am I doing wrong?

Hi all,

does anyone know how to change class-/attributes-names in the 
middlegen UI ...

I've a legacy model to map which resides in an Oracle 9iR2 instance.
Table and Relationship detection is quite fine ...

The GUI shows up, I can manipulate relation-cardinality, I can change 
almost all settings of Tables and Columns, except the names of the
java elements, which will be described and later on generated via 
hbm2java ...

any hints are welcome!

Thx in advance

K:) Unger
klaus (at) ungers-online (dot) com

On 17 Aug 04 11:38, ctof wrote:

>I try to define my own JavaTypeMapper.
>i set the value of my class to the property "javaTypeMapper" in the
>hibernate section of my ant file.
>then i start middlengen via ant and it seems that my mapper is never
call.

>more exactly, the constructor is called, but the method
>"getPreferredJavaType" is never called


>any idea ?

>thx in advance
>Christophe

As stated in the Hibernate Middlegen doc, the only time the 
javaTypeMapper is called is the first time a new table is mapped.  All 
subsequent times the saved types are used and the mapper is not called 
again.

Perhaps delete your prefs file to "fool" middlegen into thinking this 
is the first time.

Daniel

Hey,
   ive been using middlegen to generate my mapping files. It works 
great. It generates a mapping for all the tables in my schema 
(approximately 20 tables) . Except when I added the following 
        <many2many>
            <tablea generate="true" name="MERCHANTS" /> 
            <jointable name="GROUPS_MERCHANTS" generate="false" /> 
            <tableb generate="true" name="GROUPS" /> 
         </many2many>

After I added this many-to-many restraint, all the other tables in my 
schema (except groups and merchants) disappeared. The middlegen view 
now only shows 2 tables!! This is what my ant task looks like:

<target
   name="mymiddlegen"
   description="Run Middlegen"
   unless="middlegen.skip"
   depends="init,fail-if-no-xdoclet-1.2,check-driver-present,panic-if-
driver-not-present"
>
  <mkdir dir="${build.gen-src.dir}"/>
  <echo message="Class path = ${basedir}"/>

  <taskdef
    name="middlegen"
    classname="middlegen.MiddlegenTask"
    classpathref="lib.class.path"
  />

  <middlegen
    appname="${name}"
    prefsdir="${src.dir}"
    gui="${gui}"
    databaseurl="${database.url}"
    initialContextFactory="${java.naming.factory.initial}"
    providerURL="${java.naming.provider.url}"
    datasourceJNDIName="${datasource.jndi.name}"
    driver="${database.driver}"
    username="${database.userid}"
    password="${database.password}"
    schema="${database.schema}"
    catalog="${database.catalog}"
  >

       <many2many>
            <tablea generate="true" name="MERCHANTS" /> 
            <jointable name="GROUPS_MERCHANTS" generate="false" /> 
            <tableb generate="true" name="GROUPS" /> 
         </many2many>

     <!-- Plugins -->
     <hibernate
        destination="${build.gen-src.dir}"
        package="${name}.hibernate"
        
javaTypeMapper="middlegen.plugins.hibernate.HibernateJavaTypeMapper"
     />

   </middlegen>
   <mkdir dir="${build.classes.dir}"/>
</target>

Any ideas?

Hi,

You have to specify all the other tables, otherwise middlegen will
generate code only for what you have specified.

On 15 Dec 2004 15:32, vivekvik wrote:

>After I added this many-to-many restraint, all the other tables in my
>schema (except groups and merchants) disappeared. The middlegen view
>now only shows 2 tables!! This is what my ant task looks like:

       <table name="table_1"/>
       <table name="table_2"/>

>       <many2many>
>            <tablea generate="true" name="MERCHANTS" />
>            <jointable name="GROUPS_MERCHANTS" generate="false" />
>            <tableb generate="true" name="GROUPS" />
>       </many2many>

This way works for me.

I definitely appreciate everyone's work here, but not being a regular user 
of Ant or Middlegen, this is an uphill climb.  There have been two 
projects now where I've thought, "I'll try Middlegen w/ Hibernate", only 
to revert back to hand-coding the XML files.

(I think) all the pieces are there - couldn't this just be a big 
executable jar file with an adjacent folder to place jdbc drivers in?  
Download the jar, copy your JDBC drivers to the folder, double click, type 
in connection info or browse to a previously saved profile.  Man, would 
that make life easy.

Just thinking outloud...

I use middlegen 2.1.
I need to change the generator class fron default
"assigned" to another value, for instance "native".
The Ant tag looks like this:

<hibernate standardGeneratorScheme="native" destination="${src.dir}"
package="${target.package}"/>

My output files are still generated with the "assigned" class
regardless what value I provide in the build script:

<generator class="assigned" />

Please, help!

On 06 Jan 2005 14:47, ipolevoy wrote:

>I use middlegen 2.1.
>I need to change the generator class fron default
>"assigned" to another value, for instance "native".
>The Ant tag looks like this:

><hibernate standardGeneratorScheme="native" destination="${src.dir}"
>package="${target.package}"/>

>My output files are still generated with the "assigned" class
>regardless what value I provide in the build script:

><generator class="assigned" />

>Please, help!

I used Middlegen-Hibernate-r5 and the middlegen-hibernate-plugin-2.1.jar
from middlegen-2.1 and it works:

<hibernate
 destination="${build.gen-src.dir}"
 package="${name}.hibernate"
 standardGeneratorScheme="sequence"
 standardGeneratorArg="{0}_SEQ"
 genXDocletTags="false"
 javaTypeMapper="middlegen.plugins.hibernate.HibernateJavaTypeMapper"
/>

gives output like:

<generator class="sequence">
 <param name="sequence">MARK_SEQ</param>
</generator>

Hibernate version: 2.0 
Middlegen-Hibernate version: R-5 
Name and version of the database you are using:Oracle 9i 
The generated SQL (show_sql=true):True 

Hi,.. I Just got some problem from XBM Generated by Middlegen, 

In the oracle table description look like this : 

SQL> desc systlogin; 
Name Null? Type 
----------------------------------------- -------- --------------------
------- 
SYSTLOGIN_PK NOT NULL NUMBER(38) 
SYSTROLE_FK NUMBER(38) 
CUSTOMER_FK NUMBER(38) 
LOGINID NOT NULL VARCHAR2(10) 
NAMA VARCHAR2(50) 
ATASAN NUMBER(38) 
PASSWORD VARCHAR2(20) 
LANGUAGE VARCHAR2(2) 

Look at this,.. 
SYSTLOGIN_PK NOT NULL NUMBER(38) <--- its was Integer in Oracle PL/SQL 


The Question is : WHY everytime i try to generate XBM from this table 
its produce UNEXPECTED type of Data, Middelegen will produce XBM type 
data to BIGDECIMAL..In this case i want Middlegen to produce 
SYSTLOGIN_PK type data to INTEGER 

Systlogin.xbm.xml similar look like this : 

<class 
name="com.latih.db.Systlogin" 
table="SYSTLOGIN" 
>

<id 
name="systloginPk" 
type="java.math.BigDecimal" 
column="SYSTLOGIN_PK" 
>
<generator class="native" /> 
</id> 

Anyone can figure me out ? Thanks,..

On 10 Jun 2004 20:16, decairn wrote:

>On 08 Jun 2004 19:09, alu wrote:

>>Does anyone know to make middlegen to read in subset of tables in a
>>schema? I only want to map new tables.

>>Middlegen tried to read in all tables in my schema. It takes forever
>>to finish. As of writing this, it is still running!

>It's possible to specify table names, but it's also ugly.  See the
>Middlegen site documentation on the ant target options.

>We run it on a database with 500+ tables, takes 5 minutes to complete
>using the full catalogue and passing it through hbm2java.  With a
>properly defined ant target structure this is only done once and the
>output is sent to a jar in a dependency list.  Subsequent compiles
>ignore it and go straight to compiling application code.

Hi decairn,
You wrote that it takes only 5 minutes to complete on a database with 
500+ tables.
In my setup, it took 224 minutes to generate the xml and java files 
for ONE table (with 40 columns).
What is your secret ?
What is critical in the setup to get your kind op performance ?
Thanks,
PG

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE PAGE!

!On 12 Aug 2004 22:32, ayush wrote:

>I'm trying to run middlegen against an oracle database. It does
>connect to the db and finds the table in question but I get the
>following message:

>middlegen.MiddlegenException: Wow! Synonym DWPTD not found. How can it
>happen?

>Anyone knows what this means?

>- ayush

I've just come across this and I suspect it might be a small bug in
middlegen. If you look at getSynonymOwner() on MiddlegenPopulator.java,
the SQL is as follows:

select table_owner from sys.all_synonyms where table_name=? and owner=?
PreparedStatement variables are set as follows:

         ps.setString(1, synonymName);
         ps.setString(2, _schema);

Now, the structure of the oracle table sys.all_synonyms looks like this:

SQL> desc sys.all_synonyms;
 Name                                      Null?    Type
 ----------------------------------------- -------  -------- 
 OWNER                                     NOT NULL VARCHAR2(30)
 SYNONYM_NAME                              NOT NULL VARCHAR2(30)
 TABLE_OWNER                                        VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 DB_LINK                                            VARCHAR2(128)

So, looking at the method, it appears that the idea is to get the
synonym owner given the SYNONYM_name (and NOT the table_name). This
implies the SQL ought to read:

select table_owner from sys.all_synonyms where synonym_name=? and owner=?

I've only just spotted this (in my copy of the middlegen 2.1 source) so
I'm not sure if this is the crux of the matter. Hope it helps

Joe

Note that you only set the standard preference with this setting.
This means, that as soon as you have a middlegen properties file, the
setting will be saved in this file and the standardGeneratorScheme will
be ignored.

Simply delete your properties file, then it will work.
cheers
Stefan

PS Unfortunately, only standard Hibernate ID generators are supported, I
did not manage do set a class that I have written as standard generator...

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!I now found out how you can make Middlegen use any Java class as a
generator. Simply add the class's name to both  of the following attributes:
standardGeneratorScheme
standardGeneratorArg

e.g.:
<hibernate 
  destination="${gensrc.basedir}" 
  package="${gensrc.package}"
  standardGeneratorScheme="at.xxx.TableIdGenerator"
  standardGeneratorArg="at.xxx.TableIdGenerator"
  javaTypeMapper="middlegen.plugins.hibernate.HibernateJavaTypeMapper"
  genXDocletTags="true"/>

Note that as soon as you change any value in middlegen's key generator
drop-down box, it will never again use your owb Java class (unless you
edit the properties file)

I am trying to implement Optimistic Locking via Middlegen IDE with JBoss
4.0.2 and Hibernate 3.0.5.  

I saw this tidbit in the original text of this forum:

------------------------------------------------------------
David, how did you get middlegen to create the timestamp tag?

<timestamp name="departureUtc" column="departure_utc" />

Add this in your node column in your preference file :

<entry key="columnspecialty" value="version" />
------------------------------------------------------------

Could someone let me know to which "preference file" we should add the
<entry.../> line mentioned above?  

Maybe a sample section of the file would be helpful too.  

I actually plan to use "version" instead of "timestamp".  

It's easy enough to add the timestamp tag manually, but it will be wiped
out sny time we update the schema and re-run Middlegen!  So we need to
be able to add this via Middlegen config somehow.

Thanks!
Vick

Here is one way to get Middlegen to generate the <version> tag content
in the xxx.hbm.xml files.

In the Middlegen GUI, the only choice for "column specialty" is
"property", but we need another choice: "version".  To get around this,
edit the model-prefs.properties file for your application. Find the line
for your version attribute that says something like:

   hibernate.tables.CLAIM.columns.VERSION.columnspecialty=property

and change it to:

   hibernate.tables.CLAIM.columns.VERSION.columnspecialty=version

This is what would happen if you chose "version" from the drop down in
the Middlegen GUI.  Then re-run Middlegen as usual to get the desired
<version> section in your xxx.hbm.xml file(s).

>------------------------------------------------------------
>David, how did you get middlegen to create the timestamp tag?

><timestamp name="departureUtc" column="departure_utc" />

>Add this in your node column in your preference file :

><entry key="columnspecialty" value="version" />
>------------------------------------------------------------

Hi, I still want to know how can I create the "timestamp" tag with
middlegen. 

The prefs file is not a good solution, because sometimes we have to
delete the file so that middlegen can create the file again.

>Could someone let me know to which "preference file" we should add the
><entry.../> line mentioned above?
>It's easy enough to add the timestamp tag manually, but it will be
>wiped
>out sny time we update the schema and re-run Middlegen!  So we need to
>be able to add this via Middlegen config somehow.

I wanna know a way to specify this by build.xml or some ANT or VM parameter.

Someone can tell where we use the "entry" tag? Seens to be a good
solution, but I'm afraid that can't be used with Hibernate Plugin. Is
that correct?

Someone can help me?

Thanks,

Abner

Please fix the scrambled text in the code sample followed by - The
internal generation of composite keys can be selected as below.

I know that there is a way to get .hbm files from .java files. Using the
class xdoclet.modules.hibernate.HibernateDocletTask. Can't middlegen do
that? I know this class is from xdoclet, but I would like to use only
one tool for everything...

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE 
PAGE!On 29 Jan 2007 12:44, neuquino wrote:

>I know that there is a way to get .hbm files from .java files. Using
the
>class xdoclet.modules.hibernate.HibernateDocletTask. Can't middlegen
do
>that? I know this class is from xdoclet, but I would like to use only
>one tool for everything...


There are two approaches to software engineering: top down and 
button up.

XDoclet focuses on the top down approach: from .java files it 
generates .hbm.xml mapping files and from these, it is posible to
generate database using hbm2ddl tool.

Middlegen focuses on the button up approach: from database it 
generates .hbm.xml mappins files, and from these, it is posible to 
generate .java files using hbm2java tool (only for hibernate 2.x).

Conclusion: these tools (XDoclet and Middlegen) have diferente 
porpuses. Therefore, you can choose one depending on what you 
want to do.


PS: I'm "neuquino" too, I give you my email address in order to keep in
touch: emiliano.pereyra (at) hotmail (dot) com

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!I have MSSQLSERVER Express on windows Vista I can setup the database
using the Ant task but when I try to execute the middlegen ant task it
gives me an error saying 

Before getting the following error there was Ant debug statement 

- Class com.inet.tds.h loaded from ant loader (parentFirst)
Class java.lang.Math loaded from parent loader (parentFirst)
Class java.lang.OutOfMemoryError loaded from parent loader (parentFirst)
 
is the above line causes to load the driver?

\build.xml:453: middlegen.MiddlegenException: Couldn't connect to
database: [TDS Driver]Connection was closed from the SQL Serv
er site or network at header (0)
        at middlegen.MiddlegenTask.execute(MiddlegenTask.java:477)
        at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
        at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at

-Santosh

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!I got this working. The problem was windows Vista firewall setting.

-Santosh

I have shared my experience here.

http://rmwebcafe.blogspot.com/

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE PAGE!
On 10 Nov 2003 04:17, hudh wrote:

>hi,
>   I set up the middlegen-hibernate-r2 and configure the buid.xml and
>oracle.xml and then execute the ant command,but exception out is there
>is no tables .but i am sure there is lots of tables with my oracle.xml
>configuration.
>    Doesn't It support oracle generation?


set the schema="" attribute and try.