Could you post your build.properties, and the output from seam-gen where it is accessing a different DB?
hibernate.connection.password=manager workspace.home=D\:/scoala/JAVA/workspace/ model.package=beans.entity hibernate.default_catalog=hotel driver.jar=lib/postgresql-8.2-506.jdbc4.jar action.package=beans.session test.package=beans.test database.type=postgres richfaces.skin=ruby hibernate.default_schema.null= database.drop=n project.name=hblv hibernate.connection.username=manager hibernate.connection.driver_class=org.postgresql.Driver hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider project.type=war icefaces.home= database.exists=y jboss.home=D\:/scoala/JAVA/install/jboss-4.2.2.GA/ hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect hibernate.connection.url=jdbc\:postgresql\://localhost\:5432 icefaces=n
hibernate] INFO: Named query checking : enabled [hibernate] Mar 5, 2008 7:11:56 PM org.hibernate.connection.DriverManagerConnect ionProvider close [hibernate] INFO: cleaning up connection pool: jdbc:postgresql://localhost:5432 [hibernate] An exception occurred while running exporter #2:hbm2java (Generates a set of .java files) [hibernate] To get the full stack trace run ant with -verbose [hibernate] org.hibernate.exception.GenericJDBCException: Getting database metad ata [hibernate] org.postgresql.util.PSQLException: FATAL: database "manager" does no t exist BUILD FAILED D:\scoala\JAVA\install\jboss-seam-2.1.0.A1\seam-gen\build.xml:1067: org.hibernat e.exception.GenericJDBCException: Getting database metadata
I hope this gives you a little more infos about my problem... I don't understand because it worked on 2.0.0GA, but I don't have the exact build.properties from then...
Thank you, Alex.
Try specifing the database name as part of the url.
The quick look up I did showed the URL pattern
Perhaps setting it explicitly will help.
From what I found the properties are sent directly into the hibernate JDBC ant task, and that is used along with the driver to connect. Perhaps you could look in hibernate forums/mailing lists as well - I searched quick but could not find anything.
Yap, it did worked :). I've deleted the catalog and inserted into the url like you said and it worked! thank you.