DB2 poolled Connection problem

From: David Touzart (david.touzart_at_wanadoo.fr)
Date: 11/28/04

  • Next message: Wiseguy: "Re: Apache-Derby" 
    Date: Sun, 28 Nov 2004 17:08:58 +0100

    Hello,

    I try to use a pooled Connection, I use DB2DataSource.
    I take a Connection from this pool,with function getConnection()...I close
    this connection with the classic close function ,
    but if I try to Do this, forty times in my program , I catch a SQLException
    : all connections are already in use...
    what matter ?
    What have I to do to release the connection ?

    Other problem..
    If I want to use a connection after used the execute function from object
    PrepareCallSatatement , my program sometimes freeze when I execute the same
    function execute . MayBe the Object connection was bad (but it's not close).
    How can I get back the statement of the Connection (and try to close the bad
    connections), or know why my program freeze ?
    I use UDB personal edition 8
    Thank you

    David

  • Next message: Wiseguy: "Re: Apache-Derby"

    Relevant Pages

    • [Full-Disclosure] Advanced usage of system() function.
      ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit ... Connection closed by foreign host. ... think what we want to execute. ...
      (Full-Disclosure)
    • Advanced usage of system() function.
      ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit we are ... Connection closed by foreign host. ... think what we want to execute. ...
      (Bugtraq)
    • Re: ADODB Command memory leak
      ... _ConnectionPtr conn = NULL; ... // Execute statement. ... > My logic is such that the connection to the database is not maintained ... Create/Append command parameters ...
      (microsoft.public.data.ado)
    • Re: Script Controlled Dynamic Task Execution
      ... My package had three connections to three ... and each had a transformation for itself. ... After posting, I just created three packages for each connection, and my ... >> need to execute one transformation on a text file, ...
      (microsoft.public.sqlserver.dts)
    • Re: Error 80040e14 (ADO -2147217900) Die Datenbank-ID-X konnte nicht gefunden werden
      ... Wenn ich die Execute Methode nutze wieviele "Wordload ... Du darfst durchaus mehr Verbindungen haben, ... > Problem habe was was soll ich den beim Connection setzen. ... > Danach wird auf der bestehenden Connection nur noch mit Recordsets und ...
      (microsoft.public.de.sqlserver)