PAMELA%20software/yodaUtility/YSQLConnection.cpp

#include <log4cxx/logger.h>
#include <YSQLConnection.h>

using namespace log4cxx;
using namespace yngn;
using namespace yngn::sql;
using namespace yngn::YException;

    TSQLServer       *YSQLConnection::sqlServer      = 0;
    YSQLConnection   *YSQLConnection::sqlConnection  = 0;
    static LoggerPtr  logger         = Logger::getLogger(_T("yngn.sql.YSQLConnection"));

    /**
    * Private constructor for the YSQLConnection.
    * @param URL  Path to the database to be used.
    * @param user Name of the user to open the database connection.
    * @param psw  Password of the user to open the database connection.
    */
    YSQLConnection::YSQLConnection(char *URL, char *user, char *psw) throw (YSQLNotConnectedException) {
            YSQLConnection::sqlServer = TSQLServer::Connect(URL, user, psw);
            if (YSQLConnection::sqlServer == 0) throw YSQLNotConnectedException("Connection to database failed");
    }

    /**
    * Get an instance of YSQLConnection opening a connection to the database.
    * @param URL  Path to the database to be used.
    * @param user Name of the user to open the database connection.
    * @param psw  Password of the user to open the database connection.
    */
    TSQLServer* YSQLConnection::getConnection(char *URL, char *user, char *psw) throw (YSQLNotConnectedException) {
        if (YSQLConnection::sqlConnection == 0){
            YSQLConnection::sqlConnection = new YSQLConnection(URL, user, psw);
        } 
        return sqlServer;
    }

    /**
    * Get an instance of YSQLConnection opening a connection to the database.
    * @param URL      Path to the database to be used.
    * @param fileName Name of the file containing user/password to use for connection.
    
    TSQLServer* YSQLConnection::getConnection(char *URL, char *fileName) throw (YSQLNotConnectedException) {
        if (YSQLConnection::sqlConnection == 0){
            FILE * pFile;
            long lSize;
            char * buffer;  
            pFile = fopen (fileName, "r" );
            // obtain file size.
            fseek (pFile , 0 , SEEK_END);
            lSize = ftell (pFile);
            rewind (pFile);
            // allocate memory to contain the whole file.
            buffer = (char*) malloc (lSize);
            if (buffer == NULL) throw YSQLNotConnectedException("Connection file empty");
            // copy the file into the buffer.
            fread (buffer,1,lSize,pFile);
            // the whole file is loaded in the buffer. 
            // terminate
            fclose (pFile);
            YSQLConnection::sqlConnection = new YSQLConnection(URL, user, psw);
        } 
        return sqlServer;
    }
    */

    /**
    * Get an instance of YSQLConnection if a connection has already been opened connection to the database.
    */
    TSQLServer* YSQLConnection::getConnection(void) throw (YSQLNotConnectedException) {
        if (sqlConnection == NULL) throw YSQLNotConnectedException("Please connect to the database specifing the required parameters");
        return sqlServer;
    }

1	kusanagi	1.1	#include <log4cxx/logger.h>
2			#include <YSQLConnection.h>
3
4			using namespace log4cxx;
5			using namespace yngn;
6			using namespace yngn::sql;
7			using namespace yngn::YException;
8
9			TSQLServer *YSQLConnection::sqlServer = 0;
10			YSQLConnection *YSQLConnection::sqlConnection = 0;
11			static LoggerPtr logger = Logger::getLogger(_T("yngn.sql.YSQLConnection"));
12
13			/**
14			* Private constructor for the YSQLConnection.
15			* @param URL Path to the database to be used.
16			* @param user Name of the user to open the database connection.
17			* @param psw Password of the user to open the database connection.
18			*/
19			YSQLConnection::YSQLConnection(char URL, char user, char *psw) throw (YSQLNotConnectedException) {
20			YSQLConnection::sqlServer = TSQLServer::Connect(URL, user, psw);
21			if (YSQLConnection::sqlServer == 0) throw YSQLNotConnectedException("Connection to database failed");
22			}
23
24			/**
25			* Get an instance of YSQLConnection opening a connection to the database.
26			* @param URL Path to the database to be used.
27			* @param user Name of the user to open the database connection.
28			* @param psw Password of the user to open the database connection.
29			*/
30			TSQLServer* YSQLConnection::getConnection(char URL, char user, char *psw) throw (YSQLNotConnectedException) {
31			if (YSQLConnection::sqlConnection == 0){
32			YSQLConnection::sqlConnection = new YSQLConnection(URL, user, psw);
33			}
34			return sqlServer;
35			}
36
37			/**
38			* Get an instance of YSQLConnection opening a connection to the database.
39			* @param URL Path to the database to be used.
40			* @param fileName Name of the file containing user/password to use for connection.
41
42			TSQLServer* YSQLConnection::getConnection(char URL, char fileName) throw (YSQLNotConnectedException) {
43			if (YSQLConnection::sqlConnection == 0){
44			FILE * pFile;
45			long lSize;
46			char * buffer;
47			pFile = fopen (fileName, "r" );
48			// obtain file size.
49			fseek (pFile , 0 , SEEK_END);
50			lSize = ftell (pFile);
51			rewind (pFile);
52			// allocate memory to contain the whole file.
53			buffer = (char*) malloc (lSize);
54			if (buffer == NULL) throw YSQLNotConnectedException("Connection file empty");
55			// copy the file into the buffer.
56			fread (buffer,1,lSize,pFile);
57			// the whole file is loaded in the buffer.
58			// terminate
59			fclose (pFile);
60			YSQLConnection::sqlConnection = new YSQLConnection(URL, user, psw);
61			}
62			return sqlServer;
63			}
64			*/
65
66			/**
67			* Get an instance of YSQLConnection if a connection has already been opened connection to the database.
68			*/
69			TSQLServer* YSQLConnection::getConnection(void) throw (YSQLNotConnectedException) {
70			if (sqlConnection == NULL) throw YSQLNotConnectedException("Please connect to the database specifing the required parameters");
71			return sqlServer;
72			}
73