Databas closing issue

Discussion in 'Java' started by francan00@yahoo.com, Oct 16, 2007.

  1. Guest

    I have a method that inserts data into my Oracle 9i database with no
    problems or Database closing issues:

    CODE
    public class MainClass
    {

    public PreparedStatement preparer;
    public Connection connection;

    public MainClass()
    {
    connection = new DbConnectionClass().getConnection();
    }

    public int inserter(Beann abc)
    {
    int dat = 0;
    try
    {
    preparer = connection.prepareStatement("insert into abTable
    (one,two) values (?,?)");
    preparer.setString(1, abc.getOne());
    preparer.setString(2, abc.getTwo());
    preparer.executeUpdate();
    }
    catch(Exception e)
    {
    e.printStackTrace();
    }
    return dat;
    }

    public int matcher(Beann abc)
    {
    try
    {
    inserter(abc);
    }
    catch(Exception e)
    {
    e.printStackTrace();
    }
    finally
    {
    //close the ResultSet ....
    //close the Statement ....
    //close the Connection ....
    }
    }

    Now when I put the method (inserter) in another class called
    OtherClass, it does insert the data but now I have database closing
    issues:


    CODE
    public class OtherClass
    {
    ....
    public int inserter(Beann abc)
    {
    int dat = 0;
    try
    {
    preparer = connection.prepareStatement("insert into abTable
    (one,two) values (?,?)");
    preparer.setString(1, abc.getOne());
    preparer.setString(2, abc.getTwo());
    preparer.executeUpdate();
    }
    catch(Exception e)
    {
    e.printStackTrace();
    }
    return dat;
    }
    .....



    CODE
    public class MainClass
    {

    public PreparedStatement preparer;
    public Connection connection;

    public MainClass()
    {
    connection = new DbConnectionClass().getConnection();
    }

    public int matcher(Beann abc)
    {
    try
    {
    new OtherClass().insert(abc);
    }
    catch(Exception e)
    {
    e.printStackTrace();
    }
    finally
    {
    //close the ResultSet ....
    //close the Statement ....
    //close the Connection ....
    }

    In Oracle SQL Plus database resource check I see JDBC Thin Client is
    opened and not closed after each insert with the above attempt.
    This didnt happen when I had the method in the same class.

    Please advise.
     
    , Oct 16, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?Vk1J?=

    Closing popup window when closing parent window?

    =?Utf-8?B?Vk1J?=, Feb 14, 2007, in forum: ASP .Net
    Replies:
    3
    Views:
    662
    Thomas Hansen
    Feb 15, 2007
  2. JB
    Replies:
    1
    Views:
    354
    James Irvine
    Jun 11, 2010
  3. MilanB
    Replies:
    1
    Views:
    135
    Joe Kaplan \(MVP - ADSI\)
    May 10, 2005
  4. Lennie
    Replies:
    0
    Views:
    118
    Lennie
    Dec 15, 2003
  5. thomas
    Replies:
    0
    Views:
    237
    thomas
    Oct 23, 2003
Loading...

Share This Page