SQL & Websphere; how to set ?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL & Websphere; how to set ?

Hybrid View

  1. #1
    Vacca Davide Guest

    SQL & Websphere; how to set ?


    Hello to everybody,
    My problem consist in the accessing to a SQL DB (DB2) using a Websphere
    server. My application is written in Java language and it executes several
    queries on the DB. Initially everything is OK, i.e. the queries are correctly
    executed when overnight, the queries execution (not the connection to the
    DB) throws the following exception:
    "Exception: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1040N The
    maximum number of applications is already connected to the database. SQLSTATE=57030"
    I always execute a query in the following way:
    a-)I excute the connection by the method DriveManager.getConnession() (with
    the right parameters).
    b-) I retrieve the statement using the method createStatement() called on
    the connection object
    c-) I execute the query and I retrieve the datas using the object which comes
    from the query statement, as written on the Sun documentation.
    d-) I close, by the close() method, either the connection and the statement

    e-) I execute again the query as I've described above if I need to do another
    query on the DB
    I believed it was a problem related to the Websphere server configuration
    so I've tried to set the number of the total connections opened at the same
    time to 100, from 25 as default, without any result.
    Thank you very much to everybody who will help me.

    Vacca Davide
    dvx70@hotmail.com
    Methosystem S.r.L.
    Via VIII Marzo Collecchio (PR)
    Italy



  2. #2
    Mark Guest

    Re: SQL & Websphere; how to set ?


    When does the problem clear up? Have you tried 'list applications' to see
    who is connected?

    Mark

    "Vacca Davide" <dvx70@hotmail.com> wrote:
    >
    >Hello to everybody,
    >My problem consist in the accessing to a SQL DB (DB2) using a Websphere
    >server. My application is written in Java language and it executes several
    >queries on the DB. Initially everything is OK, i.e. the queries are correctly
    >executed when overnight, the queries execution (not the connection to the
    >DB) throws the following exception:
    >"Exception: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1040N The
    >maximum number of applications is already connected to the database. SQLSTATE=57030"
    >I always execute a query in the following way:
    >a-)I excute the connection by the method DriveManager.getConnession() (with
    >the right parameters).
    >b-) I retrieve the statement using the method createStatement() called on
    >the connection object
    >c-) I execute the query and I retrieve the datas using the object which

    comes
    >from the query statement, as written on the Sun documentation.
    >d-) I close, by the close() method, either the connection and the statement
    >
    >e-) I execute again the query as I've described above if I need to do another
    >query on the DB
    >I believed it was a problem related to the Websphere server configuration
    >so I've tried to set the number of the total connections opened at the same
    >time to 100, from 25 as default, without any result.
    >Thank you very much to everybody who will help me.
    >
    >Vacca Davide
    >dvx70@hotmail.com
    >Methosystem S.r.L.
    >Via VIII Marzo Collecchio (PR)
    >Italy
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center