/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you 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.    
 */
#ifndef CONNECTION_H
#define CONNECTION_H

#include <windows.h>
#include <sql.h>
#include <sqlext.h>

#include <string>
#include <list>
#include <iostream>
#include <algorithm>

#include "apache/das/rdb/StatementPtr.h"
#include "apache/das/rdb/Statement.h"
#include "apache/das/rdb/SQLException.h"

using std::string;
using std::exception;

namespace apache {
	namespace das {
		namespace rdb {

class Connection {

	private:
		SQLHDBC connection;
		SQLHENV environment;
		std::list<StatementPtr*> statements;

		void setAutoCommit(bool autoCommit);
		
	public:
		Connection(string dsn, string user, string password);
		Connection(string connectString);
		virtual ~Connection(void);
		SQLHDBC getODBCConnection(void) const;
		void commit(void);
		void rollback(void);
		StatementPtr createStatement(void);
		//PreparedStatement& prepareStatement(string sql);
		
};

		};
	};
};

#endif //CONNECTION_H