Accessing postgresql db

dilan · **Posted:** Mon Sep 19, 2005 1:33 am

Hello,
first of all, i have created a database in postgresql, and accessing through the hibernate,
for the database of 20+ tables, i use one indexing number.

Will that gives any preformance problem if so , how can i over come it?

and i'm try to create a second database, and try to access it via hibernate as well, how could i able to access the new database via hibernate as well as the one i created before, and are they both going to use the same indexing value?

kdekooter · **Joined:** Mon Apr 12, 2004 6:33 pm **Posts:** 35

What do you mean by "indexing number"? A sequence?

dilan · **Posted:** Mon Sep 19, 2005 7:57 pm

yep the sequence.

kdekooter · **Joined:** Mon Apr 12, 2004 6:33 pm **Posts:** 35

OK. Using a sequence for multiple tables is not a problem. You only have to make sure you size it properly so you dont't run out of sequence numbers.

For a second database you need to create a second sessionfactory. I am afraid if you want to use the same sequence you have to create your own generator by implementing the org.hibernate.id.IdentifierGenerator interface, or use the assigned type.