HADR works well with CLP (Command Line Processor) but what about applications ? Could they also benefit from being connected to HADR environment ? To check it I created simple C++/ODBC application.
Application
The application is available here. There is a simple class encapsulating access to DB2.
class person {
friend class QueryCommand;
person(int pid,const char *pname, const char *pfamilyname) : id(pid),name(pname),familyname(pfamilyname) {}
public:
int id;
std::string name;
std::string familyname;
};
class hadrmodel
{
friend class SqlCommand;
friend class LogoutCommand;
std::string lastActionStatus;
SQLHANDLE EnvHandle;
SQLHANDLE ConHandle;
public:
hadrmodel() {
EnvHandle = ConHandle = 0;
}
void connect();
void disconnect();
void createPersons();
void dropPersons();
void autoCommit(bool on);
std::vector<person> getListOfPersons();
void addPerson(const std::string &name, const std::string &familyName);
SQLHANDLE getConHandle() const { return ConHandle; }
std::string getConnectionStatus() const;
std::string getLastActionStatus() const { return lastActionStatus; }
};
And simple console application making usage of the methods exposed.#include <iostream>
#include "hadrmodel.h"
namespace {
void P(std::string s) {
std::cout << s << std::endl;
}
void textInterface(hadrmodel &ha) {
while (1) {
P("=======================");
P(ha.getConnectionStatus());
P("1) Connect");
P("2) Disconnect");
P("3) Get list of persons");
P("4) Add person");
P("5) Create table PERSONS");
P("6) Drop table PERSONS");
P("7) Switch on autommit");
P("8) Switch off autommit");
P("99) Exit");
int iChoice;
std::cout << "Enter:";
std::cin >> iChoice;
bool action = true;
switch (iChoice) {
case 99:
return;
case 1:
ha.connect();
break;
case 2:
ha.disconnect();
break;
case 3:
{
std::vector<person> pList = ha.getListOfPersons();
std::vector<person>::iterator i = pList.begin();
for (; i != pList.end(); i++) {
std::cout<< "id:" << i->id << " name: " << i->name << " family name:" << i->familyname << std::endl;
}
}
break;
case 4:
{
std::string name;
std::string familyName;
std::cout << "Name: ";
std::cin >> name;
std::cout << "Family name: ";
std::cin >> familyName;
ha.addPerson(name,familyName);
}
break;
case 5:
ha.createPersons();
break;
case 6:
ha.dropPersons();
break;
case 7:
case 8:
ha.autoCommit(iChoice == 7 ? true : false);
break;
default:
action = false;
break;
} // switch
if (!action) {
P("Invalid action.");
}
else {
P(ha.getLastActionStatus());
}
} // while
}
} // namespace
int main(int argc, char **argv) {
P("Hello, world!");
hadrmodel ha;
textInterface(ha);
P("I'm done");
}
TestOne can replay all test described before and be sure that everything is working perfectly also with this simple C++ application.
Autocommit on/off
There is only a difference in behavior related to "autocommit" mode. More information about autocommit mode here. Below is an example where autocommit mode is "on". The HADR takeover was performed at option 4) - adding a new person to the person table.
One interesting thing - there is nothing special in this screen. Although takeover has been performed the new person have been added smoothly without throwing any exception. So C++/ODBC application in autocommit mode "on" is takeover resistant.
But most database application must have autocommit switch "off" and mark transaction boundaries by releasing "commit" command manually.
So run again the same test but with autocommit mode off (option 8).
This time 'SQL30108N' exception is thrown and transaction is rolled back. But the connection is still alive. We can repeat the last operation and this time it will be successful.
Conclusion
Also C++ application can benefit from HADR without any changes in the code. What is mode - if the autocommit mode is "on" the application is takeover transparent. In case of autocommit mode "off" (probably most applications are running in this mode) the exception is thrown exactly like CLP behaves but the connection still exists. But there is a question - is it possible to create a C++/ODBC application takeover resistant also for autocommit mode "off".
