Hi - I am trying to reverse engineer pojos (using hibernate tools plugin v3.2.4x in eclipse 3.4.2) from a database that I have created in Postgres but my tables are being ignored. It works if I specify 'public' as the value for the 'hibernate.default_schema' property in my hibernate.cfg.xml file but if I try to specify a different schema then nothing is generated.

I've tried modifying the case (i.e. lower, upper, camel) but I still get the same result. Here is my hibernate.cfg.xml file:


Here is a picture of my setup in pgAdmin III - http://twitpic.com/snj8i

and my hibernate code generation config in eclipse
1) http://twitpic.com/snjhs
2) http://twitpic.com/snjlk

I modified the log4j properties so that I could get some debug messages in eclipse:


I'm pretty sure that I'm doing (or missing) something easy. As I say, if I change the schema to public then pojos from all tables in that schema are generated!

Can anyone help?

Many thanks,
Damian

OK, well I still haven't found a solution to this yet so in order to make some progres I have created my tables in the public schema. However, now it seems that hibernate is somehow using a cached version of that schema and so generates pojos for the original tables in the public schema but ignores my new tables!

Arrgghhhh! (cached copy not yet stale; using cached.)

How can I tell hibernate to ignore its cache?
N.B. I have tried setting hibernate.cache.use_query_cache to false. Debug output below:

Thanks,
Damian

[code]2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [events.event_id t:BIGINT l:255 p:19 s:2 n:false id:false] to [long]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [events.event_date t:TIMESTAMP l:29 p:19 s:2 n:true id:false] to [timestamp]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [events.title t:VARCHAR l:255 p:19 s:2 n:true id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - No default type found for [events.loc t:OTHER l:255 p:19 s:2 n:true id:false] falling back to [serializable]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [geometry_columns.f_table_catalog t:VARCHAR l:256 p:19 s:2 n:false id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [geometry_columns.f_table_schema t:VARCHAR l:256 p:19 s:2 n:false id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [geometry_columns.f_table_name t:VARCHAR l:256 p:19 s:2 n:false id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [geometry_columns.f_geometry_column t:VARCHAR l:256 p:19 s:2 n:false id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [geometry_columns.coord_dimension t:INTEGER l:255 p:19 s:2 n:false id:false] to [int]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [geometry_columns.srid t:INTEGER l:255 p:19 s:2 n:false id:false] to [int]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [geometry_columns.type t:VARCHAR l:30 p:19 s:2 n:false id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [gtest.id t:INTEGER l:255 p:19 s:2 n:true id:false] to [java.lang.Integer]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [gtest.name t:VARCHAR l:20 p:19 s:2 n:true id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - No default type found for [gtest.geom t:OTHER l:255 p:19 s:2 n:true id:false] falling back to [serializable]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [spatial_ref_sys.srid t:INTEGER l:255 p:19 s:2 n:false id:false] to [int]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [spatial_ref_sys.auth_name t:VARCHAR l:256 p:19 s:2 n:true id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [spatial_ref_sys.auth_srid t:INTEGER l:255 p:19 s:2 n:true id:false] to [java.lang.Integer]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [spatial_ref_sys.srtext t:VARCHAR l:2048 p:19 s:2 n:true id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy - Default type found for [spatial_ref_sys.proj4text t:VARCHAR l:2048 p:19 s:2 n:true id:false] to [string]
2009-12-10 10:14:08,812 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/Pojo.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,812 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/Pojo.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/pojo/Pojo.ftl
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/PojoTypeDeclaration.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/PojoTypeDeclaration.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... ration.ftl
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/Ejb3TypeDeclaration.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/Ejb3TypeDeclaration.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... ration.ftl
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/PojoFields.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/PojoFields.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/pojo/PojoFields.ftl
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/PojoConstructors.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/PojoConstructors.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... uctors.ftl
2009-12-10 10:14:08,828 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/PojoPropertyAccessors.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/PojoPropertyAccessors.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... essors.ftl
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... tation.ftl
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... tation.ftl
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/PojoToString.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/PojoToString.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... String.ftl
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/PojoEqualsHashcode.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/PojoEqualsHashcode.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... shcode.ftl
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Could not find template in cache, creating new one; id=[pojo/PojoExtraClassCode.ftl[en_GB,Cp1252,parsed] ]
2009-12-10 10:14:08,843 DEBUG Worker-14 freemarker.cache - Compiling FreeMarker template pojo/PojoExtraClassCode.ftl[en_GB,Cp1252,parsed] from bundleresource://871.fwk22522451:19/poj ... ssCode.ftl
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/Pojo.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/PojoTypeDeclaration.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/Ejb3TypeDeclaration.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/PojoFields.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/PojoConstructors.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/PojoPropertyAccessors.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/GetPropertyAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
2009-12-10 10:14:08,859 DEBUG Worker-14 freemarker.cache - pojo/Ejb3PropertyGetAnnotation.ftl[en_GB,Cp1252,parsed] cached copy not yet stale; using cached.
etc...
[code]

I have tried to do the same thing and it works.
Build console configuration and go to Database item, open it (with and without schema set). Do you see your schema "locatimus"?

Hi Dmitry,

Thanks for the reply. Yes, if I set the property



in my hibernate.cfg.xml and rebuild my console configuration, I can see all the tables for the Locatimus schema as pictured http://twitpic.com/swvj2

If I then run hibernate code generation - nothing is output.

If I change back to using the public schema and rebuild, I see my original tables + new locatimus tables (now that I have created them in the public schema). But if I run the hibernate code generation, only pojos for the original tables in the public schema are generated!

Hope that makes sense.

Damian

Could it be that you use wrong console configuration in your Hibernate Code Generation Configuration? Show me your Hibernate Code Generation Configuration (Main tab) please.

Pretty sure that I'm using the correct one....

Code generation config:
http://twitpic.com/swzm5

and here's my console config:
http://twitpic.com/swzsi

Thanks again for the help.

Damian

Could it be that schema name in DB is not equals schema name in hibernate.cfg.xml? I mean may be you type you scema name in DB with German(any other?) keyboard layout.

Could not be as you see the tables in Console Configuration View :(

This is quite strange. If I (in my code generation config) deselect .java and .hbm.xml exporters and instead select schema documentation (.html) then, despite an IndexOutOfBoundsException that is thrown by Eclipse, it generates the documentation for all of the tables in the locatimus schema.

http://twitpic.com/sxah3

hmmm????

I found the problem. You need to make your tables to have names in lowercase. This is a bug of PostgresSQL dialect or Hibernate.

Dmitry, I just did a quick test and you are indeed correct! Thank you so much for your help!!!!!

"I'm pretty sure that I'm doing (or missing) something easy." <-- I was right ;-)