nz.geek.caffe.hdb.hibernate.demo.TestEmployee.java Source code

Introduction

Here is the source code for nz.geek.caffe.hdb.hibernate.demo.TestEmployee.java

Source

/**
 * Copyright 2014 Andrew Clemons
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package nz.geek.caffe.hdb.hibernate.demo;

import javax.sql.DataSource;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.AvailableSettings;
import org.hibernate.dialect.HANAColumnStoreDialect;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.hibernate4.HibernateTransactionManager;
import org.springframework.orm.hibernate4.HibernateOperations;
import org.springframework.orm.hibernate4.HibernateTemplate;
import org.springframework.orm.hibernate4.LocalSessionFactoryBuilder;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionOperations;
import org.springframework.transaction.support.TransactionTemplate;

/**
 */
public class TestEmployee {

    private SessionFactory sessionFactory;

    HibernateOperations template;

    private TransactionOperations transactionTemplate;

    /**
     */
    @Before
    public void setUp() {
        final DataSource ds = new DriverManagerDataSource(
                System.getProperty("jdbc.url", "jdbc:sap://localhost:30115"),
                System.getProperty("jdbc.user", "hibernate"), System.getProperty("jdbc.password", "hibernate"));

        final LocalSessionFactoryBuilder builder = new LocalSessionFactoryBuilder(ds);
        builder.setProperty(AvailableSettings.DIALECT,
                System.getProperty("hibernate.dialect", HANAColumnStoreDialect.class.getName()));
        builder.setProperty(AvailableSettings.HBM2DDL_AUTO, "create-drop");
        builder.setProperty(AvailableSettings.USE_NEW_ID_GENERATOR_MAPPINGS, "true");

        builder.addAnnotatedClass(Employee.class);

        this.sessionFactory = builder.buildSessionFactory();

        final HibernateTemplate ht = new HibernateTemplate();
        ht.setSessionFactory(this.sessionFactory);

        ht.afterPropertiesSet();

        this.template = ht;

        final HibernateTransactionManager txnMgr = new HibernateTransactionManager();
        txnMgr.setDataSource(ds);
        txnMgr.setSessionFactory(this.sessionFactory);
        txnMgr.afterPropertiesSet();

        this.transactionTemplate = new TransactionTemplate(txnMgr);
    }

    /**
     */
    @Test
    public void testHdb() {
        final String name = "Timmi Tester";

        final Integer id = this.transactionTemplate.execute(new TransactionCallback<Integer>() {

            public Integer doInTransaction(TransactionStatus status) {
                final Employee e = new Employee();
                e.setName(name);

                TestEmployee.this.template.save(e);

                return Integer.valueOf(e.getId());
            }
        });

        final Employee employee = this.template.get(Employee.class, id);

        Assert.assertEquals(name, employee.getName());
    }
}