Re: [Sqlrelay-discussion] Bug report, open client connections not freed, with code to reproduce problem

[Ingmar B. <sw...@gm...>]

Hi David,

I have been trying to debug what's going on. The connection process
crashes on this statement

                OCIHandleFree(def[i],OCI_HTYPE_DEFINE);

line 1744 of oracle8connection.C with a segmentation fault. I've not
been able to figer out why this happens. I am new to C++ and GDB and I
cannot view the contents of the OCIDefine object. However, when I
looked into the Oracle Call Interface Programmer's Guide

http://www.ewp.rpi.edu/hartford/webgen//appdocs/oracle/doc/appdev.920/a96584/oci02bas.htm

it said the following:

OCI_HTYPE_DEFINE = OCI define handle

and

Bind and define handles are freed when the statement handle is freed
or when a new statement is prepared on the statement handle.

So my question is, why is it being freed explicitly anyway? I've
compiled sqlrelay with the statement commented out, and now everything
seems to be going fine. For what situations is the
OCIHandleFree(def[i],OCI_HTYPE_DEFINE) statement neccesary?

Anxiously awaiting your reply,

Ingmar