OracleDatabase.h

Go to the documentation of this file.

/*
* FinTP - Financial Transactions Processing Application
* Copyright (C) 2013 Business Information Systems (Allevo) S.R.L.
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>
* or contact Allevo at : 031281 Bucuresti, 23C Calea Vitan, Romania,
* phone +40212554577, office@allevo.ro <mailto:office@allevo.ro>, www.allevo.ro.
*/

#ifndef ORACLEDATABASE_H
#define ORACLEDATABASE_H

#include "../Database.h"
#include "../ConnectionString.h"

#ifdef WIN32
#define __MSXML_LIBRARY_DEFINED__
#include <windows.h>
#define sleep(x) Sleep( (x)*1000 )
#else
#include <unistd.h>
#endif

#include <string>
#include <oci.h>
using namespace std;

#define MAX_DOCUMENT_LENGTH 8000

namespace FinTP
{
        class OracleDatabase : public Database
        {
                public :

                        OracleDatabase();
                        ~OracleDatabase();

                        void BeginTransaction( const bool readonly );
                        void EndTransaction( const TransactionType::TRANSACTION_TYPE transactionType, const bool throwOnError  );

                        void Connect( const ConnectionString& connectionString );

                        void Disconnect();

                        // Gets the connected/disconnected status
                        bool IsConnected();

                        void ExecuteNonQuery( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, bool onCursor )
                        {
                                DataCommand nonquery( commType, DataCommand::NONQUERY, stringStatement, false );
                                ParametersVector tempParams;
                                (void)innerExecuteCommand( nonquery, tempParams, onCursor, 0 );
                        }

                        void ExecuteNonQueryCached( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, bool onCursor )
                        {
                                DataCommand nonquery( commType, DataCommand::NONQUERY, stringStatement, true );
                                ParametersVector tempParams;
                                (void)innerExecuteCommand( nonquery, tempParams, onCursor, 0 );
                        }

                        void ExecuteNonQuery( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, const ParametersVector& vectorOfParameters, bool onCursor )
                        {
                                DataCommand nonquery( commType, DataCommand::NONQUERY, stringStatement, false );
                                (void)innerExecuteCommand( nonquery, vectorOfParameters, onCursor, 0 );
                        }

                        void ExecuteNonQueryCached( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, const ParametersVector& vectorOfParameters, bool onCursor )
                        {
                                DataCommand nonquery( commType, DataCommand::NONQUERY, stringStatement, true );
                                (void)innerExecuteCommand( nonquery, vectorOfParameters, onCursor, 0 );
                        }

                        DataSet* ExecuteQuery( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, bool onCursor, const unsigned int fetchRows )
                        {
                                DataCommand query( commType, DataCommand::QUERY, stringStatement, false );
                                ParametersVector tempParams;
                                return innerExecuteCommand( query, tempParams, onCursor, fetchRows );
                        }

                        DataSet* ExecuteQuery( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, const ParametersVector& vectorOfParameters, bool onCursor, const unsigned int fetchRows )
                        {
                                DataCommand query( commType, DataCommand::QUERY, stringStatement, false );
                                return innerExecuteCommand( query, vectorOfParameters, onCursor, fetchRows );
                        }

                        DataSet* ExecuteQueryCached( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, const bool onCursor, const unsigned int fetchRows )
                        {
                                DataCommand queryCached( commType, DataCommand::QUERY, stringStatement, true );
                                ParametersVector tempParams;
                                return innerExecuteCommand( queryCached, tempParams, onCursor, fetchRows );
                        }

                        DataSet* ExecuteQueryCached( const DataCommand::COMMAND_TYPE commType, const string& stringStatement, const ParametersVector& vectorOfParameters, const bool onCursor, const unsigned int fetchRows )
                        {
                                DataCommand queryCached( commType, DataCommand::QUERY, stringStatement, true );
                                return innerExecuteCommand( queryCached, vectorOfParameters, onCursor, fetchRows );

                        }

                        void ReleaseStatement( const bool isCommandCached, const string& key );
                        void ReleaseCursor( const bool checkConn );
                        void RewindCursor() {}

                private :

                        bool m_IsConnected, m_IsReconnecting;

                        ConnectionString m_ConnectionString;

                        OCIEnv          *m_hEnv;                        // environment handle
                        OCIError        *m_hError;                      // error handle
                        OCISvcCtx       *m_hServiceContext;     // ServiceContext handle
                        OCISession      *m_hSession;            // session handle
                        OCIServer       *m_hServer;                     // server handle
                        OCITrans        *m_hTransaction;        // transaction handle
                        OCIStmt         *m_StatementHandle;     // statement handle
                        OCIStmt         *m_hCursor;                     // cursor handle
                        OCIRowid        *m_HoldCursorRowId;     // held rowid
                        xmlctx          *m_XmlContext;          // XML context required by XDB

                        OCIClobLocator *m_ClobLocator;
                        OCIBlobLocator *m_BlobLocator;
                        OCIClobLocator *m_FetchClobLocator;
                        OCIClobLocator *m_FetchBlobLocator;
                        OCIType *m_ArrayType;
                        // binds for date/timestamp columns in a returned dataset
                        vector< OCIDate** > m_Date;
                        vector< OCIDateTime** > m_Timestamp;

                        CacheManager< string, OCIType* > m_TypeCache;

                        void BindParams( const ParametersVector& vectorOfParameters, const unsigned int startIndex = 1 );

                        DataSet* innerExecuteCommand( const DataCommand& command, const ParametersVector& vectorOfParameters, const bool useCursor = false, const unsigned int fetchRows = 0 );

                        DataSet* executeQuery( DataCommand& command, const bool isCommandCached, const bool useCursor );
                        DataSet* getDataSet( DataCommand& command, const bool isCommandCached, OCIStmt *statementHandle, const bool useCursor );

                        void executeNonQuery( DataCommand& command, const bool isCommandCached, const bool useCursor );

                        // translates transaction type to a Oracle specific value
                        static int getOracleTransactionType( TransactionType::TRANSACTION_TYPE type );

                        string getErrorInformation( dvoid *errorHandle, sword status, ub4 handleType = OCI_HTYPE_ERROR, const bool connCheck = true );

                        OCIType* getMessageType( const string& typeName, const string& userName = "" );

                        void freeOCIArrays( const ParametersVector& vectorOfParameters );

                        void initXmlContext();

                        string RawToString( const OCIRaw* value );
                        OCIRaw* StringToRaw( const string& value );

                        // clears the m_Date, m_Timestamp vectors
                        void ClearDateTimestampBinds();
        };
}

#endif // ORACLEDATABASE_H