/**
 * Copyright 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());
    }
}

@@ -10,16 +10,21 @@
 pyright 
+2014 
 Andrew C

fix licence header