Inject SessionFactory Hibernate to ActionHandler

[Łukasz Bączek]

Hello,

Do you know how to inject SessionFactory to ActionHandler?

For example:

public class ConfigGridSQLHandler extends AbstractActionHandler<ConfigGridSQL, ConfigGridSQLResult> {

@Inject

public ConfigGridSQLHandler() {

super(ConfigGridSQL.class);

}

public ConfigGridSQLResult execute(ConfigGridSQL arg0, ExecutionContext arg1) throws ActionException {

String primaryKeyName = null;

List<MetaDataFieldConfigSQL> list = null;

try {

String sql = "SELECT k.COLUMN_NAME FROM information_schema.table_constraints t LEFT JOIN information_schema.key_column_usage k USING(constraint_name,table_schema,table_name) WHERE t.constraint_type='PRIMARY KEY' AND t.table_schema=DATABASE() AND t.table_name=:TABLE_NAME";

SQLQuery query = {INJECT SESSIONFACTORY HIBERNATE}.openSession().createSQLQuery(sql);

query.setParameter("TABLE_NAME", SQLToolsImpl.getFirstTableFromSQL(arg0.getSql()).toUpperCase().trim());

System.out.println(SQLToolsImpl.getFirstTableFromSQL(arg0.getSql()).toUpperCase().trim());

List<Object[]> resultKey = query.list();

System.out.println(resultKey.size());

if (resultKey.size() != 0) {

primaryKeyName = String.valueOf(resultKey.get(0));

} else {

throw new PrimaryKeyNotFound();

}

list = SQLToolsImpl.getColumnFromSQL(getSessionFactory(), arg0.getSql());

} catch (HibernateException | JSQLParserException e) {

throw new OtherPrimaryKeyException(e.getMessage());

}

return new ConfigGridSQLResult(primaryKeyName, list);

@Override

public void undo(ConfigGridSQL action, ConfigGridSQLResult result, ExecutionContext context)

throws ActionException {

// TODO Auto-generated method stub

}

I would like to inject SessionFactory (Hibernate) without rigid in its definition of ActionHandler. Is it possible?

Regards

[Asier]

Hi

Have you considered using something like onami-persist?

If you can't include that package then I suppose it's easy to get with a @Provides method in a guice module.

Regards

[Łukasz Bączek]

Hi,

Yes, I did it using Guice.

My test code:

package pl.cba.lukaszbaczek.ApplicationTestSQLGrid.server;

import org.hibernate.SessionFactory;

import com.google.inject.AbstractModule;
import com.google.inject.name.Names;

import pl.cba.lukaszbaczek.webMuseumDatabase.server.HibernateUtils;

public class SessionFactoryModule extends AbstractModule {

    @Override
    protected void configure() {
        bind(SessionFactory.class).annotatedWith(Names.named("test")).toInstance(HibernateUtils.getSessionFactory());
    }   
}


package pl.cba.lukaszbaczek.gxtSQLGrid.server.data;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

import com.google.inject.Inject;
import com.google.inject.name.Named;
import com.gwtplatform.dispatch.rpc.server.ExecutionContext;
import com.gwtplatform.dispatch.rpc.server.actionhandler.AbstractActionHandler;
import com.gwtplatform.dispatch.shared.ActionException;

import net.sf.jsqlparser.JSQLParserException;
import pl.cba.lukaszbaczek.gxtSQLGrid.client.data.ConfigGridSQL;
import pl.cba.lukaszbaczek.gxtSQLGrid.client.data.ConfigGridSQLResult;
import pl.cba.lukaszbaczek.gxtSQLGrid.client.grid.OtherPrimaryKeyException;
import pl.cba.lukaszbaczek.gxtSQLGrid.client.grid.PrimaryKeyNotFound;
import pl.cba.lukaszbaczek.gxtSQLGrid.client.sqlTools.MetaDataFieldConfigSQL;
import pl.cba.lukaszbaczek.gxtSQLGrid.server.parserSQL.SQLToolsImpl;

public class ConfigGridSQLHandler extends AbstractActionHandler<ConfigGridSQL, ConfigGridSQLResult> {

    private SessionFactory sessionFactory;

    @Inject
    public ConfigGridSQLHandler() {
        super(ConfigGridSQL.class);
    }

    @Inject
    public void setSessionFactory(@Named("test") SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;

    }

    public ConfigGridSQLResult execute(ConfigGridSQL arg0, ExecutionContext arg1) throws ActionException {
        String primaryKeyName = null;
        List<MetaDataFieldConfigSQL> list = null;

        Session session = null;

        String sql = "SELECT k.COLUMN_NAME FROM information_schema.table_constraints t LEFT JOIN information_schema.key_column_usage k USING(constraint_name,table_schema,table_name) WHERE t.constraint_type='PRIMARY KEY' AND t.table_schema=DATABASE() AND t.table_name=:TABLE_NAME";

        try {
            session = sessionFactory.openSession();
            SQLQuery query = session.createSQLQuery(sql);
            query.setParameter("TABLE_NAME", SQLToolsImpl.getFirstTableFromSQL(arg0.getSql()).toUpperCase().trim());

            List<Object[]> resultKey = query.list();

            if (resultKey.size() != 0) {
                primaryKeyName = String.valueOf(resultKey.get(0));
            } else {
                throw new PrimaryKeyNotFound();
            }

            list = SQLToolsImpl.getColumnFromSQL(session, arg0.getSql());

        } catch (HibernateException | JSQLParserException e) {
            throw new OtherPrimaryKeyException(e.getMessage());

        } finally {
            session.close();

        }
        return new ConfigGridSQLResult(primaryKeyName, list);
    }

    @Override
    public void undo(ConfigGridSQL action, ConfigGridSQLResult result, ExecutionContext context)
            throws ActionException {
    }
}

Thank you for your interest.


W dniu 23.12.2016 o 18:33, Asier
 pisze:

--
You received this message because you are subscribed to a topic in the Google Groups "GWTP" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/gwt-platform/-TVLttt40Qs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to gwt-platform...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.