Hello,
we are able to reverse engineer the database into hbm.xml and .java files. Based on the output generated we have the following questions/feedback:

1. We have a Contract table with 10 IDs that have foreign key relations with a lookup table. The generated hbm.xml and .java did not seem to have useful names for these. I got the following entry in the hbm.xml from ContactLookup to ContactLookup_6



It would be great if the names are more friendly, such as ContractStatusIDlookup instead of ContractLookup and OptionPeriodSuffixTypeIDLookup instead of ContractLookup_1. With the current output the developers will having to refer the hbm.xml file to find the correct property.

2. Integer primary keys are being converted to BigDecimal in the hbm.xml file
It would be great if the IDs are maintained as Integer, as they are in the database.



3. Nice to have-Property names as strings: It would be great if the .java files contain the property names as strings. An example would be:



This way we can refer to the strings in our code that uses hibernate to populate the domain objects.

Any thoughts on these would be most appreciated.

Thanks.

#1 is a known limitation. we will provide ui for overwriting this - but we would also like to find a more automatic way of deducing a proper name.
We have a ReverseNamingStrategy that we just need a good implementation for.

#2 it all depends on how the db reports it. If it reports it as something that is only containable inside a BigDecimal then it will be mapped to that. please remember that a java.lang.Integer < jdbc INTEGER.
We should probably also provide a usercontrollable map for controlling these.

#3 sounds like a job for a custom template.

Hello Max,
Thanks for your response.

2. Regarding the integer primary key: Currently, even though the size of the column is defined as NUMBER(8), which amounts to data in the range +/-(10^8 - 1), the tool creates the mapping and java files with properties of type java.math.BigInteger. Can you please tell us if there is a setting that can be altered to make this a java.lang.Long/java.lang.Integer. (we are using these integer IDs with Oracle sequences in the system)

4. We also have read the code and it seems like the code is designed to support the autogeneration of views and tables (Synonyms are commented out). But when the tool runs in eclipse, For some reason, the tool is skipping all the views. Can you point us to a solution to this?

3. Please let us know the name of the template file that needs to be changed. I downloaded the source code from the CVS, but when I try to compile it, it gives the errors below:

C:\HibernateToolsCVS\HibernateExt>build

C:\HibernateToolsCVS\HibernateExt>set HIBERNATECORE=C:\ HibernateToolsCVS\HibernateExt\..\hibernate-3.0

C:\HibernateToolsCVS\HibernateExt>java -cp "C:\HibernateToolsCVS\HibernateExt\..\hibernate-3.0\lib\ant-lau
ncher-1.6.2.jar" org.apache.tools.ant.launch.Launcher -lib C:\HibernateToolsCVS\HibernateExt\..\hibernate-3.0/lib

Buildfile: build.xml

dist:

init:
[echo] Build Hibernate Console-3.0 (2005-02-16 01:47:45)
[mkdir] Created dir: C:\HibernateToolsCVS\HibernateExt\console\build\classes
[copy] Copying 21 files to C:\HibernateToolsCVS\HibernateExt\console\build\classes
[copy] Copying 2 files to C:\HibernateToolsCVS\HibernateExt\console\build

compile:
[javac] Compiling 69 source files to C:\HibernateToolsCVS\HibernateExt\console\build\classes
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\EventSink.java:16: package org.hibernate.event.def does not exist
[javac] import org.hibernate.event.def.AbstractEvent;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\EventSink.java:73: cannot resolve symbol
[javac] symbol : class AbstractEvent
[javac] location: class org.hibernate.console.EventSink
[javac] public void add(AbstractEvent event) {
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\EventSink.java:79: cannot resolve symbol
[javac] symbol : class AbstractEvent
[javac] location: interface org.hibernate.console.EventSink.Handler
[javac] Object getValue(AbstractEvent event, int column);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\EventSink.java:83: cannot resolve symbol
[javac] symbol : class AbstractEvent
[javac] location: class org.hibernate.console.EventSink.AbstractHandler
[javac] public Object getValue(AbstractEvent event, int column) {
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\HibernateIdentifierProperty.java:11: cannot resolve symbol
[javac] symbol : class EntityMode
[javac] location: package hibernate
[javac] import org.hibernate.EntityMode;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\HibernateProperty.java:7: cannot resolve symbol
[javac] symbol : class EntityMode
[javac] location: package hibernate
[javac] import org.hibernate.EntityMode;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\NodeFactory.java:27: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: package type
[javac] import org.hibernate.type.CollectionType;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\ClassNode.java:10: cannot resolve symbol
[javac] symbol : class EntityMode
[javac] location: package hibernate
[javac] import org.hibernate.EntityMode;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\ClassNode.java:14: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: package type
[javac] import org.hibernate.type.CollectionType;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\NodeFactory.java:190: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.node.NodeFactory
[javac] public PersistentCollectionNode createPersistentCollectionNode(ClassNode node, String name, ClassMetadata md, CollectionType type, Object baseObject, boolean objectGraph) {
[javac]
^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\PersistentCollectionNode.java:12: cannot resolve symbol
[javac] symbol : class EntityMode
[javac] location: package hibernate
[javac] import org.hibernate.EntityMode;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\PersistentCollectionNode.java:16: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: package type
[javac] import org.hibernate.type.CollectionType;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\PersistentCollectionNode.java:28: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.node.PersistentCollectionNode
[javac] CollectionType type;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\PersistentCollectionNode.java:36: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.node.PersistentCollectionNode
[javac] public PersistentCollectionNode(NodeFactory factory, BaseNode parent, String name, CollectionType type, ClassMetadata md, CollectionMetadata metadata, Object baseObject, boolean objectGraph) {
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\MappingsTreeCellRenderer.java:19: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: package type
[javac] import org.hibernate.type.CollectionType;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\PropertyNode.java:4: cannot resolve symbol
[javac] symbol : class EntityMode
[javac] location: package hibernate
[javac] import org.hibernate.EntityMode;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\views\GraphView.java:24: cannot resolve symbol
[javac] symbol : class EntityMode
[javac] location: package hibernate
[javac] import org.hibernate.EntityMode;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\EventSink.java:34: cannot resolve symbol
[javac] symbol: class AbstractEvent
[javac] public Object getValue(AbstractEvent event, int column) {
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\EventSink.java:58: cannot resolve symbol
[javac] symbol : class AbstractEvent
[javac] location: class org.hibernate.console.EventSink
[javac] AbstractEvent event = (AbstractEvent) events.get(rowIndex);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\EventSink.java:58: cannot resolve symbol
[javac] symbol : class AbstractEvent
[javac] location: class org.hibernate.console.EventSink
[javac] AbstractEvent event = (AbstractEvent) events.get(rowIndex);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\HibernateProperty.java:39: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.HibernateProperty
[javac] setValue(cmd.getPropertyValue(object, getName(),EntityMode.POJO));
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\HibernateProperty.java:43: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.HibernateProperty
[javac] cmd.setPropertyValue(object, getName(), getValue(), EntityMode.POJO);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\HibernateIdentifierProperty.java:28: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.HibernateIdentifierProperty
[javac] setValue(cmd.getIdentifier(object, EntityMode.POJO));
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\HibernateIdentifierProperty.java:32: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.HibernateIdentifierProperty
[javac] cmd.setIdentifier(object, (Serializable) getValue(), EntityMode.POJO);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\NodeFactory.java:197: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.node.NodeFactory
[javac] new Class[] { NodeFactory.class, BaseNode.class, String.class, CollectionType.class, ClassMetadata.class, CollectionMetadata.class, Object.class, boolean.class},
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\NodeFactory.java:216: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.node.NodeFactory
[javac] CollectionType pct = (CollectionType)type;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\NodeFactory.java:216: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.node.NodeFactory
[javac] CollectionType pct = (CollectionType)type;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\ClassNode.java:69: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.node.ClassNode
[javac] PersistentCollectionNode tn = factory.createPersistentCollectionNode(this, names[i], md, (CollectionType)type, getValue(), objectGraph);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\ClassNode.java:93: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.node.ClassNode
[javac] String cname = ((ClassNode)currentParent).md.getMappedClass(EntityMode.POJO).getName();
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\PersistentCollectionNode.java:58: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.node.PersistentCollectionNode
[javac] collectionObject = md.getPropertyValue(baseObject, name, EntityMode.POJO);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\MappingsTreeCellRenderer.java:93: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.MappingsTreeCellRenderer
[javac] CollectionType ptype = (CollectionType) type;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\MappingsTreeCellRenderer.java:93: cannot resolve symbol
[javac] symbol : class CollectionType
[javac] location: class org.hibernate.console.MappingsTreeCellRenderer
[javac] CollectionType ptype = (CollectionType) type;
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\node\PropertyNode.java:23: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.node.PropertyNode
[javac] return baseMetaData.getPropertyValue(baseObject, getName(), EntityMode.POJO);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\views\GraphView.java:114: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.views.GraphView
[javac] dgm.add(new DefaultPort(element.getMappedClass(EntityMode.POJO) + "/Center"));
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\views\GraphView.java:116: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.views.GraphView
[javac] class2Node.put(element.getMappedClass(EntityMode.POJO), dgm);
[javac] ^
[javac] C:\HibernateToolsCVS\HibernateExt\console\src\java\org\hibernate\console\views\GraphView.java:189: cannot resolve symbol
[javac] symbol : variable EntityMode
[javac] location: class org.hibernate.console.views.GraphView
[javac] String str = element.getMappedClass(EntityMode.POJO).getName();
[javac] ^
[javac] 36 errors

BUILD FAILED
C:\HibernateToolsCVS\HibernateExt\build.xml:25: The following error occurred while executing this line:
C:\HibernateToolsCVS\HibernateExt\common\common-build.xml:142: Compile failed; see the compiler error output for details.

Total time: 7 seconds

It would be nice if there was an option to map a DB's INT/INTEGER/NUMBER to a JAVA int or long. We prefer primitive types :-)

Speaking of naming strategies, can we have the POJO's variables start with a lowercase character instead of an uppercase one?

Thank-you.

Yet another wish is to be able from the UI set the option for the PK generator to native or whatever...

Right now there is not such an option.

You could look at SqlToJavaTypesStrategy.getPreferredJavaType which does this "magic".



Havent tested explicit for views, but it *should* pick them up.
Post it in jira as bug with as much info you got.

[/quote]



yes, there were some structure changes in H3 lately that im going to fix for the tools today. sorry about that.

You just need to provide a javaclass.vm replacement. Copy the one from cvs (in tools/src/velocity) and point to your template directory in the generation wizard - then it should pick it up.

For all you other guys - your ideas should be posted to the jira as improvements/new features (if they aint in there already).

And contributions are as always very welcome!

I have identified the fix for this and submitted JIRA issue HBX-114.

Joe Dunne.

Most of the items you have asked for is available with Middlegen. We intend to surpass that level of functionality. In a number of areas the backend can already do more. The front end GUI will get better. I don't think it should be rushed as it needs to done right. Lots to consider. There are very few ORM GUI tools where most of them don't work all that well. We intend to have an excellent product. Its just a matter of time.

Hello Max,
I have posted the issue with View generation in JIRA as HBX-123.

Thanks.

Hi,
Database views are not getting reverse engineered while running latest hibernate tools. Tables are getting correctly reverse engineered with pojos/ejb 3 annotations/generics/html docs..

Is this issue fixed in hibernate tools? or should I customize hibernate.reveng.xml?

I needed to get the mapping files for database views as well.

Thanks in Advance,
Hari Sujathan