473,406 Members | 2,467 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Connect & Disconnect

In testing our app, we connected and disconnected like 1000 times and
noticed a 5 meg memory leak. The sequence of connecting and disconnecting
is as follows:

1. OdbcSQLAllocHandle
2. OdbcSQLAllocConnect
3. OdbcSQLConnect
4. OdbcSQLDisconnect
5. OdbcSQLFreeConnect
6. OdbcSQLFreeEnv

.. . . is there some step missing that might prevent the leak?

Thanks.

-g
Nov 1 '06 #1
2 2087
Geoff wrote:
In testing our app, we connected and disconnected like 1000 times and
noticed a 5 meg memory leak. The sequence of connecting and disconnecting
is as follows:

1. OdbcSQLAllocHandle
2. OdbcSQLAllocConnect
3. OdbcSQLConnect
4. OdbcSQLDisconnect
5. OdbcSQLFreeConnect
6. OdbcSQLFreeEnv

. . . is there some step missing that might prevent the leak?
Where does the leak occur? At the database server or at the client? Could
you locate where the leak happens? In the CLI (ODBC) functions or maybe it
is your own application?

That doesn't seem to be the DB2 CLI driver. Have you tried the IBM driver?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 1 '06 #2
Leaks on the client side but these are low level calls, not from the app.

-g
"Knut Stolze" <st****@de.ibm.comwrote in message
news:ei**********@lc03.rz.uni-jena.de...
Geoff wrote:
>In testing our app, we connected and disconnected like 1000 times and
noticed a 5 meg memory leak. The sequence of connecting and
disconnecting
is as follows:

1. OdbcSQLAllocHandle
2. OdbcSQLAllocConnect
3. OdbcSQLConnect
4. OdbcSQLDisconnect
5. OdbcSQLFreeConnect
6. OdbcSQLFreeEnv

. . . is there some step missing that might prevent the leak?

Where does the leak occur? At the database server or at the client?
Could
you locate where the leak happens? In the CLI (ODBC) functions or maybe
it
is your own application?

That doesn't seem to be the DB2 CLI driver. Have you tried the IBM
driver?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Nov 1 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Amir | last post by:
Hi, According to Application Programming and SQL Guide chapter 29: "If DB2 terminates, a task that issued CONNECT must issue DISCONNECT to reset the CAF control blocks. The function returns...
4
by: banz | last post by:
Hello I have a problem to resolve: I wrote a Perlscript which caches data from a server (local on my machine) I would like to have a other connection to a remote server but I don't know how to...
2
by: yyy | last post by:
Hello, Can someone please tell me how I can connect to the Internet and/or disconnect from it using C#.NET ? I just want to open this window in order to connect:...
1
by: Sparky | last post by:
Hi I was wondering if someone can please enlighten me as to the best and most approved way to connect and disconnect network drives in vb.net. I have been using Mpr.dll API calls such as...
2
by: http://www.visual-basic-data-mining.net/forum | last post by:
Say i have declare a module for connection and two buttons... one button has the method connect() and the other has the method disconnect().... how do i actually connect after i had disconnect...
2
by: dan kisting | last post by:
Hi, I wrote a chat program and it uses Sockets to connect. There is no intentional port scan going on, however I am seeing tons of port scans on that port in our firewall, and it (the firewall)...
1
by: Maximus | last post by:
hi all, I want to kow if there is a way to connet a machine using a VPN client through vb.net or c# code. I have requirement where i need to copy file using VPN. Hence, I need to start the...
3
by: Laurence | last post by:
Hi there, Does anyone know what's difference among "connect reset", "disconnect", and "terminate"? Thanks in advance,
13
by: trymore | last post by:
Hi all, can anybody help me out there? I am developing a client sockect to send transactions form a DB to a server socket. the way i want is to connect, send, recieve , disconnect, connect, send,...
3
by: jc | last post by:
Hi there: Reading from internet i found that the best way to use a database is to connect and disconnect on every single database request, so if you are loading a listbox manually from a...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.