Hibernate version:
hibernate-tools 3.1.0 alpha

Name and version of the database you are using:
postgresql 7.4

I have some trouble with the artifact generation. When I open the wizard and try to create an reveng.xml it doesnt show my database tables. It shows nothing although there are tables in my db. I double checked the url configuration and tried different users/schemas, it doesnt work. is there any hint on this ?

is your database case sensitive ? then it is important to have the schema/catalog in teh right case (if you have those specificed)

postgresql save identifiers to lower case (oracle do it in upper case)

You have to use lower case for schema, for example - there is DatabaseMetaData methods
storeLowerCaseIdentifiers and storeUpperCaseIdentifiers (in standard jdbc), but tools don't use it

regards

eh - tell me again why tools should behave differently than the db on this ?

we simply ask the database what schemas it has under this name - and if case matters it should matter, correct ?

I don't tell that tools have to use it - i tell that methods for check uper/lower case exists and any tools can use it

for example, postgresql and oracle are case insensitive, but oracle save identifiers too upper case and postgresql in lower case (except you escape it) - you can use tow methods before that check this behavior and don't force user that set identifiers in lower or upper case

I can develop system for both databases - and I have to change all identifiers (shemas,tables etc) if tools don't use storeUpper/LowerCaseIdentifiers - it isn't strong request, it tell about possibilities, only
regards

postgres and oracle ARE case sensitive when it comes to the metadata

I talk about this - internal they are case sensitive, but tools (sqlplus in oracle or psql in postgresql) aren't (and standard sql isn't, too) - you can mimic this behavior for different databases with jdbc's methods before (if you want it, of course)

i hcecked this, thanks fpr your hints but case senstitivity is not my trouble.. still no tables visible...

send us hibernate.cfg.xml ?

<?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="testfact">
<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.connection.url">jdbc:postgresql://eiswind/wba</property>
<property name="hibernate.connection.username">wba</property>
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
</session-factory>
</hibernate-configuration>

I try it (postgresql 8.0beta 1) and it work fine.
Have you any table in database wba when try with psql ?

regards