October 13th, 2004, 05:45 PM
|
 |
Bug Hunter
|
|
Join Date: May 2003
Location: Transylvania (Romania)
Posts: 274
Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9
|
|
Quote: | Originally Posted by Sanket_devshed Hello all,
I am using Firebird 1.5.
1) I want to query my database to find out the current
number of Active Connections (That how many users are
connected to the database currently).
|
What language do you use ?
for example in c++ you can call the api function isc_database_info
and here is how is implemented in ibpp
Quote:
void DatabaseImpl::Users(std::vector<std::string>& users)
{
if (mHandle == 0)
throw ExceptionImpl("Database::Users", "Database is not connected.");
char items[] = {isc_info_user_names,
isc_info_end};
IBS status;
RB result(8000);
status.Reset();
(*gds.Call()->m_database_info)(status.Self(), &mHandle, sizeof(items), items,
result.Size(), result.Self());
if (status.Errors())
{
status.Reset();
throw ExceptionImpl(&status, "Database::Users", "isc_database_info failed");
}
users.clear();
char* p = result.Self();
while (*p == isc_info_user_names)
{
p += 3; // Get to the length byte (there are two undocumented bytes which we skip)
int len = (int)(*p);
++p; // Get to the first char of username
if (len != 0) users.push_back(std::string().append(p, len));
p += len; // Skip username
}
return;
}
|
Quote:
2) One more doubt :-
If i am connected to Firebird Database through JDBC ... and that program terminates abnormally after successfully obtaining the Connection.
What will happen to the Active Connection Count ... will it be decremented ?
Sanket |
it should be decremented
ps : ok now i see that you use jdbc i guess is java what is used ?
Last edited by mariuz : October 13th, 2004 at 05:48 PM.
|
Dev Shed Forums Sponsor:
Query :- find Count of Active Connections
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
