final static String SQL_USER = "ephesoft";
	final static String SQL_PASSWORD = "C@pture2O2O";
	final static String SQL_DRIVER = "net.sourceforge.jtds.jdbc.Driver";
	final static String DATABASE_NAME = "ephesoft";
	final static String SQL_CONNECTION_STRING = "jdbc:jtds:sqlserver://localhost:1433/" + DATABASE_NAME;
	final static String SQL_TABLE = "batch_instance_groups";


import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.io.OutputStream;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

import org.hibernate.HibernateException;
import org.hibernate.SQLQuery;
import org.hibernate.StatelessSession;
import org.hibernate.Transaction;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.input.SAXBuilder;
import org.jdom.output.XMLOutputter;

import com.ephesoft.dcma.core.DCMAException;
import com.ephesoft.dcma.core.component.ICommonConstants;
import com.ephesoft.dcma.core.hibernate.DynamicHibernateDao;
import com.ephesoft.dcma.script.IJDomScript;
import com.ephesoft.dcma.util.ApplicationConfigProperties;
import com.ephesoft.dcma.util.logger.EphesoftLogger;
import com.ephesoft.dcma.util.logger.ScriptLoggerFactory;



	//method to get batch instance identifier
	public static void assignedBatchInstanceGroup(String batchInstanceIdentifier, String userRole ) throws DCMAException {

		DynamicHibernateDao dynamicHibernateDao = null;
		try {
			dynamicHibernateDao = new DynamicHibernateDao(SQL_USER, SQL_PASSWORD, SQL_DRIVER, SQL_CONNECTION_STRING);
			StatelessSession statelessSession = null;

			statelessSession = dynamicHibernateDao.getStatelessSession();
			Transaction transaction = statelessSession.getTransaction();
			StringBuffer dbQueryBuffer = new StringBuffer();
			if (SQL_CONNECTION_STRING.contains("mysql")) {
				dbQueryBuffer.append("INSERT INTO ");
				dbQueryBuffer.append(SQL_TABLE);
				dbQueryBuffer.append(" (creation_date, last_modified, batch_instance_id, group_name) VALUES (NOW(), NOW(), '");
				dbQueryBuffer.append(batchInstanceIdentifier);
				dbQueryBuffer.append("', '");
				dbQueryBuffer.append(userRole);
				dbQueryBuffer.append("')");
			} else if (SQL_CONNECTION_STRING.contains("sqlserver")) {
				dbQueryBuffer.append("INSERT INTO ");
				dbQueryBuffer.append(SQL_TABLE);
				dbQueryBuffer.append(" (creation_date, last_modified, batch_instance_id, group_name) VALUES (GETDATE(), GETDATE(), '");
				dbQueryBuffer.append(batchInstanceIdentifier);
				dbQueryBuffer.append("', '");
				dbQueryBuffer.append(userRole);
				dbQueryBuffer.append("')");
			}

			SQLQuery query = statelessSession.createSQLQuery(dbQueryBuffer.toString());
			transaction.begin();
			query.executeUpdate();
			transaction.commit();
			statelessSession.close();
		} catch (HibernateException e) {
			System.err.println(e.getMessage());
			e.printStackTrace();
		} finally {
			if (dynamicHibernateDao != null) {
				dynamicHibernateDao.closeSession();
			}
		}


	}