The right place for those questions is http://forum.hibernate.org
To answer your question, you have different DBs, so different
SessionFactory configurations (using the same mapping I imagine).
You will just have to change the following property in each
hibernate.cfg.xml
hibernate.search.default.indexBase /usr/local/lucene/indexes/dbXX
Please follow up on the forum if you have further questions.
On Feb 23, 2008, at 11:42, Aleksander M. Stensby wrote:
Hello, my name is Aleksander M. Stensby.
We are currently using Apache Lucene for our full-text indexing/
search system, but are considering a possible move over to
Hibernate Search (or possibly Compass).
I've been looking at Hibernate Search and have a question that I
hope to get some help with here (if this is the right list to ask
the question, that is.)
We currently have a pretty big and complex database system
consisting of several "similar" databases. That is, the tables and
the table structure of each of these X databses are the same, but
the content is not, meaning it is not a mirroring og sharding system.
What we do at the moment is run X different indexes, each
representing a different database. The indexing is done by batch
jobs running several times a day (we have a pretty large flow into
our database every day). The solution is not very scalable, as we
have experienced, and it causes big problems if something goes
wrong with one of these batch jobs. Also, we actually run one of
these processes for each database, each dealing with its own index.
So yeah... a big mess in general.
Since we do use Hibernate, I fell in love with the idéa of
Hibernate's Event system taking care of this indexing for us, but
one big and essential question remains:
How can Hibernate "tackle" several different "identical" databases?
I mean, the layout would be something like this:
DB#1
- TableA
DB#2
- TableA
DB#X
- TableA
TableA in DB#1 would refer to entity no.integrasco.xxx.tableA, but
so would TableA in DB#2, and TableA in DB#X...
So how can we handle indexing of these entities into different
indexes?
So that DB#1 - TableA goes into:
/usr/local/lucene/indexes/db1/tableA
DB#2 into
/usr/local/lucene/indexes/db2/tableA
etc..
Is it possible? Maybe I haven't spent enough time on this yet, if
the answer is simple, please forgive me for wasting your time...
Best Regards,
Aleksander M. Stensby
--
Aleksander M. Stensby
Senior Software Developer
Integrasco A/S
[EMAIL PROTECTED]
Tlf.: +47 41 22 82 72
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
