how alfresco uses the ddbb connection?

[dacedos]

Hi,

I created some custom tables to audit,

I'd like to know how alfresco uses connections with database to avoid me a custom DAO and to avoid create a new connection everytime I want to write into tables.

How could I get the default database connection? because I am pretty sure alfresco connect when tomcat starts, I tried to track for example when creating a node because alfresco writes in tables but I do not know how it does.

thanks!

[derek]

Take a look at the code

org.alfresco.repo.domain.schema.SchemaBootstrap‍

and how it gets hold of the connection from the SessionFactory.  Instead of

        Session session = getSessionFactory().openSession();
‍‍

you would use

        Session session = getSessionFactory().getCurrentSession();‍