postgresql « Schema « JPA Q&A





1. changes to the schema while hibernate is running    stackoverflow.com

I'm working on a high usage system which maps a few "read only" tables and views. At various points in time I need to replace the data in these tables with ...

2. Run code after Hibernate updates database schema?    stackoverflow.com

Is there a way to register some kind of SchemaExportEventListener (that's a name I've chosen) with Hibernate, so that after it has generated the DDL we can make some updates (which ...

3. SchemaUpdate for PostgreSQL    forum.hibernate.org

Hi, does anyone know if SchemaUpdate works correctly on PostgreSQL? The Hibernate Reference docs say something about how SchemaUpdate depends heavily on JDBC metadata API. However, the JDBC driver for PostgreSQL supports JDBC 3.0, so shouldn't this be enough for it to work? When I run the schema update, I get an error message that looks like the one I have ...

4. dynamically select database schema with postgresql    forum.hibernate.org

thanks a lot for your answer. here is what I have done. The first request using JDBC retrieve the right informations but retrieving the information with hibernate did retrieve the information from the 'public' schema instead of the 'customer1' schema. I guess that is probably due to something I misunderstand in the way hibernate works. Why is hibernate still requesting the ...

5. Schema update broken for PostgreSQL 8.1    forum.hibernate.org

Beginner Joined: Tue Jun 21, 2005 1:36 am Posts: 24 Location: Houston, TX Hibernate version:3.0.5 Name and version of the database you are using: PostgreSQL 8.1 I upgraded to PostgreSQL 8.1 and scehma update stopped functioning because information_schema._pg_keypositions() no longer exists. I solved this by creating the funtion manually. I posted this to the PostgreSQL mailing list and was told that ...

6. PostgreSQL schemas auto generation    forum.hibernate.org

Hi there, I am using Hibernate with PostgreSQL 8.0 and want to achieve the following: In my web application I want to use a different postgre schema for every new customer. I then use a different SessionFactory for every schema setting the hibernate.default_schema property. Do you think this is agood approach or is there a way to do this with one ...

7. GENERATING SEQUENCES and PostgreSQL Schemas    forum.hibernate.org

...