> We are running a shop engine (build in perl) that uses MaxDB as its > database. At one of our customers the system uses a single > database-instance for about 120 shops utilizing a model like SAP does > (client-dependent and client-independent tables).
Try using schemas. - Create one SCHEMA per shop - create all the tables, indices and views in each schema - when you get the session from the session pool, execute SET CURRENT_SCHEMA = <schema name of current shop> - if you have shared tables, you can probably create them in a special schema and then create SYNONYMs in all the shop schemas The remainder of your code can then ignore the problem. I hope that Hibernate does. If they generate SQL statements with fully qualified table names, then some tweaking is in order. OK, tweaking might be an euphemism. Daniel Dittmar -- Daniel Dittmar MaxDB, SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
