Hi Conny, as you have recognized, this isn't possible with Castor at the moment. Having said that I think this would be a reasonable new feature for Castor.
Without a detailed look at the code I am not able to tell you how difficult it will be to add this, but I expect to hit some problems. I can see to different solutions to reduce memory footprint with mappings shared by multiple databases. The first is to change connection or its factory on one Database instance. A good starting point for this will be to search when a connection or its factory get created and how they are used until a Database instance got created. I expect a problem with life cycle management of the Database instance here, as a Database instance can not be reused after it got closed at the moment. Another option would be to detect if a mapping got already loaded to reuse the ClassDescriptors for multiple JDOManager/Database instances. To keep the history of any discussion we have regarding this feature I would suggest to create a new issue in jira where we can add comments on our findings. Regards Ralf Kreyßel schrieb: > Hello castor team, > > we have one basic design question. Today we have circa 40 databases with the > following schemes: > > db_a_1 -> table scheme a > db_a_2 -> table scheme a > db_a_3 -> table scheme a > db_b_1 -> table scheme b > db_b_1 -> table scheme b > db_b_1 -> table scheme b > db_c_1 -> table scheme c > db_c_1 -> table scheme c > db_c_1 -> table scheme c > ... > ... > > The table schemes have a lot of tables (ca. 30 tables and average 200 columns > per table). > > Today we create and load for each database a jdomanager configuration and > create for each database a castor database instance. The mapping files are > very large and the result is a very large memory overhead. > > In hibernate i can submit a jdbc connection to a session instance, similar is > submit a connection to a database instance. Is this possible with castor? > > How is the best way to implement such a scenario? > > Thanx > > > --------------------------------------------------------------------- > To unsubscribe from this list please visit: > > http://xircles.codehaus.org/manage_email -- Syscon Ingenieurbüro für Meß- und Datentechnik GmbH Ralf Joachim Raiffeisenstraße 11 72127 Kusterdingen Germany Tel. +49 7071 3690 52 Mobil: +49 173 9630135 Fax +49 7071 3690 98 Internet: www.syscon.eu E-Mail: [EMAIL PROTECTED] Sitz der Gesellschaft: D-72127 Kusterdingen Registereintrag: Amtsgericht Stuttgart, HRB 382295 Geschäftsleitung: Jens Joachim, Ralf Joachim --------------------------------------------------------------------- To unsubscribe from this list please visit: http://xircles.codehaus.org/manage_email
