About Jdbc Connection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gollamudi
    New Member
    • Sep 2007
    • 5

    #1

    About Jdbc Connection

    1.what is the connectionpool in jdbc connection?
    2.diffrence between normal jdbc connection and connectionpool jdbc connection?
  • madhoriya22
    Contributor
    • Jul 2007
    • 251

    #2
    Originally posted by gollamudi
    1.what is the connectionpool in jdbc connection?
    2.diffrence between normal jdbc connection and connectionpool jdbc connection?
    Hi,
    Look for your answers here
    This JDBC Java tutorial describes how to use JDBC API to create, insert into, update, and query tables. You will also learn how to use simple and prepared statements, stored procedures and perform transactions

    Comment

    • JosAH
      Recognized Expert MVP
      • Mar 2007
      • 11453

      #3
      Originally posted by gollamudi
      1.what is the connectionpool in jdbc connection?
      2.diffrence between normal jdbc connection and connectionpool jdbc connection?
      Connections are 'expensive' objects: i.e. the need quite some resources and
      it takes time to build them. You don't want a new connection for every little
      database interaction. It is possible to reuse such connections, instead of
      closing connections you can store them in a pool, ready for reuse when needed.

      There are quite a few connection pool implementations available; see the apache
      project for a few fine examples.

      kind regards,

      Jos

      Comment

      Working...