Re: [xwiki-devs] [Proposal] Implementation for XWIKI-8271 (extensible Hibernate mappings)

2012-10-03 10:55, Denis Gervalle skrev: I wrote a small test application to see how this would work. The schema and catalog parameters did not work as I expected. But it does work on both MySQL and PostgreSQL to instead use template with fully qualified table name like this: <class name="${entityNamePrefix}:com.xpn.xwiki.doc.XWikiDocument" table="${databaseOrSchema}.xwikidoc"> I had to use two hacks to get it working: 1. I had to use a custom class loader just to strip the prefix from the class name. While the mapping from class to entity name can be controlled by implementing the EntityNameResolver interface, there is surprisingly no way to control the inverse mapping. The entity name (the name attribute of the class element) is passed directly to the class loader. 2. The session factory interface does not contain the method 'registerEntityNameResolver', so I have to access the internal hibernate class SessionFactoryImpl. But I think that this is less kludgy than the current implementation. The test application use these mappings: <class name="foo:se.kreablo.hibernatetest.TestEntity" table="test_foo.testentity"> <id name="id" column="id"> <generator class="increment"/> </id> <property name="value" type="text" column="value"/> </class> <class name="bar:se.kreablo.hibernatetest.TestEntity" table="test_bar.testentity"> <id name="id" column="id"> <generator class="increment"/> </id> <property name="value" type="text" column="value"/> </class> public class HibernateTest { private static class PrefixRemovingClassLoader extends ClassLoader { private String transformName(String name) { int i = name.indexOf(':'); if (i > 0) { return name.substring(i + 1); } return name; } @Override public Class<?> loadClass(String name) throws ClassNotFoundException { return getParent().loadClass(transformName(name)); } } private static class TestEntityNameResolver implements EntityNameResolver { private String currentPrefix = "foo"; @Override public String resolveEntityName(Object entity) { return currentPrefix + ":" + entity.getClass().getName(); } public void setCurrentPrefix(String prefix) { currentPrefix = prefix; } } public static void main(String args[]) { Thread.currentThread().setContextClassLoader(new PrefixRemovingClassLoader()); SessionFactory sessionFactory = new Configuration() .configure() // configures settings from hibernate.cfg.xml .buildSessionFactory(); final TestEntityNameResolver entityNameResolver = new TestEntityNameResolver(); ((SessionFactoryImpl) sessionFactory).registerEntityNameResolver(entityNameResolver); Session session = sessionFactory.openSession(); session.beginTransaction(); session.save( new TestEntity("First") ); entityNameResolver.setCurrentPrefix("bar"); session.save( new TestEntity("Second") ); session.getTransaction().commit(); session.close(); } } Best Regards, /Andreas