1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
<!--plsfield:text-->
<HTML><HEAD>
<TITLE>C API Reference -- Ns_DbPoolGetMultipleHandles</TITLE>
<LINK rel=Previous href="c-ch146.htm">
<LINK rel=ToC href="toc.htm">
<LINK rel=Index href="master.htm">
<LINK rel=Next href="c-ch148.htm">
</HEAD><BODY BGCOLOR="#ffffff"><A NAME="topofpage"></A>
<TABLE WIDTH=100%>
<TR>
<TD ALIGN=LEFT>
<A NAME="topofpage"></A> <IMG SRC="as-c-sm.gif">
</TD>
<TD ALIGN=RIGHT>
<A href="c-ch146.htm"><IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm> <IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm> <IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="c-ch148.htm"> <IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<A name="7983"> </A>
</TD>
</TR>
</TABLE>
<a name="115298">
</a><h3>Ns_DbPoolGetMultipleHandles</h3>
<a name="115299">
</a><h4>Overview</h4>
Get multiple database handles from pool
<a name="78002">
</a><a name="132764">
</a><h4>Syntax</h4>
<pre> <a name="78004"></a>int Ns_DbPoolGetMultipleHandles(
<a name="78005"></a>Ns_DbHandle **handles,
<a name="78006"></a>char *poolname,
<a name="78007"></a>int nhandles
<a name="78008"></a>);
</pre><p><a name="134125">
</a><h4>Description</h4>
<p><a name="78010">
</a>The Ns_DbPoolGetMultipleHandles function gets a database handle from the pool specified by <code>poolname</code> and returns an array of handles (<code>handles</code>). If all of the specified number of handles (<code>nhandles</code>) are not available, the function waits until they are. It returns NS_OK if all requested handles are returned or NS_ERROR on an error condition. <i>You must request all the database handles you will need for a specific pool with one call to Ns_DbPoolGetHandle (if you need only one handle) or Ns_DbPoolGetMultipleHandles (if you need more than one handle). </i>You must release all your database handles explicitly (with Ns_DbPoolPutHandle) before acquiring more.</p>
<a name="224934">
</a><h4>Examples</h4>
<pre> <a name="224937"></a>#define NUM_HANDLES 5
<a name="224945"></a>Ns_DbHandle **handles;
<a name="224956"></a>
<a name="224948"></a>handles = Ns_Malloc(NUM_HANDLES * sizeof (Ns_DbHandle *));
<a name="224938"></a>if (Ns_DbPoolGetMultipleHandles(handles, "aPoolName",
<a name="224951"></a> NUM_HANDLES) != NS_OK) {
<a name="224939"></a> Ns_Set *row;
<a name="224940"></a> row = Ns_DbSelect(handles[0], "select * from aTable");
<a name="224941"></a> ...
<a name="224942"></a>} else {
<a name="224954"></a> /* handle error condition */
<a name="224955"></a>}
<a name="224935"></a>
</pre><p>
<TABLE BORDER="2" CELLPADDING="1" width="100%">
<TR><TD COLSPAN=3><P ALIGN=Center>
<IMG SRC="bluebult.gif">
<A HREF="#topofpage">
<FONT SIZE=-1>Top of Page</FONT></A>
<IMG SRC="bluebult.gif">
</TD></TR>
<TR><TD COLSPAN=3><P ALIGN=Center>
<A href="c-ch146.htm">
<IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm>
<IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm>
<IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="c-ch148.htm">
<IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<BR align=center>
<FONT size=-1>Copyright © 1998-99 America Online,
Inc.</FONT>
</TD></TR></TABLE></BODY></HTML><!--plsfield:end-->
|
