F
francan
I am getting closed exception messages with my below jdbc connection
to Oracle 9i from Tomcat 6 container:
java.sql.SQLException: Closed Statement
and
java.sql.SQLException: Closed Statement: next
private Connection connection;
public ArrayList<MoneyBean> getMoneyList()
{
ArrayList<MoneyBean> list = new ArrayList<MoneyBean>();
connection = new DatabaseConnector.getConnection();
if(connection != null)
{
ResultSet rs = null;
PreparedStatement preparedStatement = null;
try {
String BankQuery = "Select money from Bank";
preparedStatement = connection.preparedStatement
(BankQuery);
rs = preparedStatement.executeQuery();
while(rs.next())
{
MoneyBean money = new MoneyBean();
money.setMoney(rs.getString("money"));
list.add(money);
}
}
}
catch(SQLException ex)
{
System.out.println(ex);
}
finally
{
try
{
if(rs != null)
{
rs.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
if(preparedStatement != null)
{
preparedStatement.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
if(connection != null)
{
connection.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
return list;
}
to Oracle 9i from Tomcat 6 container:
java.sql.SQLException: Closed Statement
and
java.sql.SQLException: Closed Statement: next
private Connection connection;
public ArrayList<MoneyBean> getMoneyList()
{
ArrayList<MoneyBean> list = new ArrayList<MoneyBean>();
connection = new DatabaseConnector.getConnection();
if(connection != null)
{
ResultSet rs = null;
PreparedStatement preparedStatement = null;
try {
String BankQuery = "Select money from Bank";
preparedStatement = connection.preparedStatement
(BankQuery);
rs = preparedStatement.executeQuery();
while(rs.next())
{
MoneyBean money = new MoneyBean();
money.setMoney(rs.getString("money"));
list.add(money);
}
}
}
catch(SQLException ex)
{
System.out.println(ex);
}
finally
{
try
{
if(rs != null)
{
rs.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
if(preparedStatement != null)
{
preparedStatement.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
if(connection != null)
{
connection.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
return list;
}