Databas closing issue

F

francan00

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.
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,056
Messages
2,570,441
Members
47,119
Latest member
NoeliaIrby

Latest Threads

Top