I have a method that inserts data into my Oracle 9i database with no problems and no 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 using try/catch
//close the Statement using try/catch
//close the Connection using try/catch
}
}
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 int matcher(Beann abc)
{
try
{
new OtherClass().insert(abc);
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
//close the ResultSet using try/catch
//close the Statement using try/catch
//close the Connection using try/catch
}
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.
| 