This is a multi-part message in MIME format.
------=_NextPart_000_0035_01BFCA4C.1E9D1700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello, all.
Does anyone know how CFTRANSACTION and database connection pooling =
interact? =20
My specific question is: If I wrap a series of SQL commands (some =
creating temp tables, some updating temp tables, some querying those =
same tables) within a CFTRANSACTION tag, does CF Server maintain the =
connection to the database, in spite of the fact that we are using =
connection pooling? =20
Or does it (potentially) grab a different connection for each command? =
That is, are these two completely unrelated?
Please let me know if you need more detail.
Thanks!
Brian
---------------------------------
Brian P. Cusack
[EMAIL PROTECTED]
------=_NextPart_000_0035_01BFCA4C.1E9D1700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hello, all.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Does anyone know how CFTRANSACTION and database =
connection pooling interact? </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>My specific question is: If I wrap a series =
of SQL=20
commands (some creating temp tables, some updating temp tables, =
some=20
querying those same tables) within a CFTRANSACTION tag, does CF Server =
maintain=20
the connection to the database, in spite of the fact that we are using=20
connection pooling? </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Or does it (potentially) grab a different connection =
for each=20
command? That is, are these two completely unrelated?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Please let me know if you need more =
detail.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Thanks!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV>
<DIV><FONT size=3D2>---------------------------------<BR>Brian P. =
Cusack<BR><A=20
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A></FONT></DIV></BOD=
Y></HTML>
------=_NextPart_000_0035_01BFCA4C.1E9D1700--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
