Re: Closed Statement issue

From:

francan <francan00@yahoo.com>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 29 Dec 2009 18:43:08 -0800 (PST)

Message-ID:

<074c664c-882f-4c99-9914-d12224fa9cd2@j24g2000yqa.googlegroups.com>

On Dec 29, 8:53 pm, Arne Vajh=F8j <a...@vajhoej.dk> wrote:

On 29-12-2009 19:38, francan wrote:

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.prepar=

edStatement

(BankQuery);
rs = preparedStatement.executeQuery()=

;

                while(rs.next())
                {
                     MoneyBean money = new Mone=

yBean();

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;
}

It may help us if you told us where the exception was thrown.

The exceptions seems to indicate a closed connection. Any chance
another thread could have closed the connection ?

Arne- Hide quoted text -

- Show quoted text -

The exception occurs here:
catch(SQLException ex)
      {
          System.out.println(ex);
      }

Not sure what you mean by another thread? Do you mean another class
with a Database connection?