Sorry, I'll try to be more concrete: With schema I mean the schema attribute of "<class>" in the hbm.xml, which is a synonym for the table name. So I see, "customerdb" was a wrong name, should be "customertable".
I want to be able to persist into another table than it was originally defined in the hbm.xml mapping file. For e.g.: Instead of using "customertable", which is defined in the mapping xml, I want to switch that to "customertable_2" (creative, I know), but after the whole project has been compiled. This change should be possible for example via the nhibernate configuration file (using query.substitutions as parameter does not seem to work here), or via command line parameter where I would have to extend my program to handle that parameter and then change the schema name programatically, again without having to change the mapping xmls (this is where I thought Interceptors could come in handy?). I'm trying to avoid having to set up a second database, just to be able to use the once defined schema (table) names twice - so different configurations of my program should be able to run on the same database. Regards, Peter On 7 Mai, 14:45, Fabio Maulo <[email protected]> wrote: > For example: what mean "different schema" ? > only different schema-name ? > only different tables name ? > different schema-name, different catalog-name, different table-name, > different columns names, different columns specifications, different > tables/columns at all ? > > > > > > On Fri, May 7, 2010 at 9:40 AM, Fabio Maulo <[email protected]> wrote: > > Please try to explain the problem 'A' instead the problem ('B') you have > > found trying to resolve the problem 'A' > > > On Fri, May 7, 2010 at 9:23 AM, Peter Leeter > > <[email protected]>wrote: > > >> Hi there, > > >> I have another question today: > > >> In the hbm.xml-descriptor files of my project I use the schema- > >> attribute for each model. > > >> I got the requirement today that I have to be able to change the > >> schemata for different database configurations. > > >> Example: I my project compiled with an hbm.xml which has: > >> <class name="Person" table="persons" schema="customerdb"> > > >> Now I want to be able to change customerdb to another schema without > >> having to change the hbm.xml - file. > > >> I think I have to implement something like a replace logic for that > >> attribute, which can be changed for e.g. at startup via a command line > >> parameter. > > >> Does somebody has an idea how I can achieve this? Are interceptors a > >> way? > > >> Thanks in advance again for any help! > >> Peter > > >> -- > >> You received this message because you are subscribed to the Google Groups > >> "nhusers" group. > >> To post to this group, send email to [email protected]. > >> To unsubscribe from this group, send email to > >> [email protected]<nhusers%[email protected] > >> > > >> . > >> For more options, visit this group at > >>http://groups.google.com/group/nhusers?hl=en. > > > -- > > Fabio Maulo > > -- > Fabio Maulo > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
