How to induce "ORA-03114: Not Connected to Oracle"?

--===============4628333874060267305==
Content-Type: multipart/alternative; boundary="000000000000c03fba057f67c3ab"

--000000000000c03fba057f67c3ab
Content-Type: text/plain; charset="UTF-8"

Hi all!

How can I induce ORA-03114 in cx_Oracle for the purpose of testing
application behavior?

I tried blocking network traffic after the connection has been established
but this resulted in cx_Oracle (I guess) waiting for a response from the
server and after a couple of minutes I gave up. Strangely it seems like
there are no timeouts in this situation.

I guess inducing ORA-03114 might require closing all connections (I'm using
connection pool in SQLAlchemy) and then somehow preventing new ones from
establishing?

Best regards,
Piotr Dobrogost

--000000000000c03fba057f67c3ab
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi all!<div><br></div><div>How can I induce=C2=A0ORA-03114=
 in cx_Oracle for the purpose of testing application behavior?</div><div><b=
r></div><div>I tried blocking network traffic after the connection has been=
 established but this resulted in cx_Oracle (I guess) waiting for a respons=
e from the server and after a couple of minutes I gave up. Strangely it see=
ms like there are no timeouts in this situation.</div><div><br></div><div>I=
 guess inducing ORA-03114 might require closing all connections (I&#39;m us=
ing connection pool in SQLAlchemy) and then somehow preventing new ones fro=
m establishing?</div><div><div><br></div><div>Best regards,</div><div>Piotr=
 Dobrogost</div></div></div>

--000000000000c03fba057f67c3ab--


--===============4628333874060267305==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============4628333874060267305==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

--===============4628333874060267305==--