Problemas com retorno de uma classe

Prezados Srs.
Estou com um probleminha aqui. Tenho uma classe que retorna uma StringBuffer, até ai tudo bem, só que quando entra no select ele simplesmente não executa o select, como posso debugar a query no código????? abaixo segue o código:
package estoque;

import java.io.*;
import java.sql.*;
import java.util.*;
    
public class Relatorio&#123;
    
    public static String geraRelatorio&#40;int cd_especie&#41;&#123;
    
    StringBuffer html = new StringBuffer&#40;&#41;;
    String retorno = null;
    
    html.append&#40;&quot;&lt;h1&gt;&quot;+cd_especie+&quot;&lt;/h1&gt;&quot;&#41;;
       html.append&#40;&quot;&lt;table border=\&quot;1\&quot; width=\&quot;750\&quot; cellspacing=\&quot;1\&quot; cellpadding=\&quot;2\&quot; align=\&quot;center\&quot;&gt;&quot;+
        &quot;&lt;tr&gt;&quot;+
        &quot;&lt;td width=\&quot;100%\&quot; colspan=\&quot;7\&quot; bgcolor=\&quot;#000099\&quot; align=\&quot;center\&quot;&gt;&quot;+
        &quot;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Relatório de Estoque&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;&quot;+
        &quot;&lt;/tr&gt;&quot;+
        &quot;&lt;tr&gt;&quot;+
        &quot;&lt;th width=\&quot;16%\&quot; bgcolor=\&quot;#800000\&quot;&gt;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Código&lt;/b&gt;&lt;/font&gt;&lt;/th&gt;&quot;+
        &quot;&lt;th width=\&quot;16%\&quot; bgcolor=\&quot;#800000\&quot;&gt;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Descrição&lt;/b&gt;&lt;/font&gt;&lt;/th&gt;&quot;+
        &quot;&lt;th width=\&quot;17%\&quot; bgcolor=\&quot;#800000\&quot;&gt;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Unidade&lt;/b&gt;&lt;/font&gt;&lt;/th&gt;&quot;+
        &quot;&lt;th width=\&quot;17%\&quot; bgcolor=\&quot;#800000\&quot;&gt;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Qtd. Atual&lt;/b&gt;&lt;/font&gt;&lt;/th&gt;&quot;+
        &quot;&lt;th width=\&quot;17%\&quot; bgcolor=\&quot;#800000\&quot;&gt;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Ult. Consumo&lt;/b&gt;&lt;/font&gt;&lt;/th&gt;&quot;+
        &quot;&lt;th width=\&quot;17%\&quot; bgcolor=\&quot;#800000\&quot;&gt;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Cons. Médio&lt;/b&gt;&lt;/font&gt;&lt;/th&gt;&quot;+
        &quot;&lt;th width=\&quot;17%\&quot; bgcolor=\&quot;#800000\&quot;&gt;&lt;font color=\&quot;#FFFFFF\&quot;&gt;&lt;b&gt;Duração&lt;/b&gt;&lt;/font&gt;&lt;/th&gt;&quot;+        
        &quot;&lt;/tr&gt;&quot;&#41;;
              
        try &#123;
      
      //Cria conexão com a base de dados
         
     Connection con = DataConnect.connectDb&#40;&#41;;
      
      Statement stmt = con.createStatement&#40;&#41;;
             
      String sql = &quot;select * from dbamv.v_estoque_atual where cd_especie = &quot;+cd_especie;
   
      ResultSet rs = stmt.executeQuery&#40;sql&#41;;
             
      //faz primeira busca no banco de dados
                      
        while &#40;rs.next&#40;&#41;&#41;&#123;
   
      int cd_produto = rs.getInt&#40;&quot;cd_produto&quot;&#41;;
        String ds_produto = rs.getString&#40;&quot;ds_produto&quot;&#41;;
        String ds_unidade = rs.getString&#40;&quot;ds_unidade&quot;&#41;;
        int qt_atual = rs.getInt&#40;&quot;qt_atual&quot;&#41;;
        int qt_ult_cons = rs.getInt&#40;&quot;qt_ultimo_consumo&quot;&#41;;
        int qt_cons_medio = rs.getInt&#40;&quot;qt_consumo_medio&quot;&#41;;
        
        int dura = qt_atual/qt_cons_medio;
        
html.append&#40;&quot;&lt;tr&gt;&quot;+
            &quot;&lt;td width=\&quot;16%\&quot; bgcolor=\&quot;#FFCC00\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;&quot;+cd_produto+&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&quot;+
            &quot;&lt;td width=\&quot;16%\&quot; bgcolor=\&quot;#FFCC00\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;&quot;+ds_produto+&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&quot;+
            &quot;&lt;td width=\&quot;17%\&quot; bgcolor=\&quot;#FFCC00\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;&quot;+ds_unidade+&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&quot;+
            &quot;&lt;td width=\&quot;17%\&quot; bgcolor=\&quot;#FFCC00\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;&quot;+qt_atual+&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&quot;+
            &quot;&lt;td width=\&quot;17%\&quot; bgcolor=\&quot;#FFCC00\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;&quot;+qt_ult_cons+&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&quot;+
            &quot;&lt;td width=\&quot;17%\&quot; bgcolor=\&quot;#FFCC00\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;&quot;+qt_cons_medio+&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&quot;+
            &quot;&lt;td width=\&quot;17%\&quot; bgcolor=\&quot;#FFCC00\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;&quot;+dura+&quot;&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&quot;+
            &quot;&lt;/tr&gt;&quot;&#41;;
        
   &#125;
      rs.close&#40;&#41;;
   
   //tenta fechar a conexão com o banco de dados
      
   try &#123;
            
    con.close&#40;&#41;;
      
      &#125; catch&#40;Exception e&#41;  &#123;
           
      e.printStackTrace&#40;&#41;;
            
      &#125;
      
     //pega erro &#40;se houver na query&#41;
            
  	 &#125; catch&#40;Exception e&#41; &#123;
      
     e.printStackTrace&#40;&#41;;
     
   	&#125;
   
    //fecha tabela do relatório
    
    html.append&#40;&quot;&lt;tr&gt;&lt;td colspan=\&quot;7\&quot;&gt;&lt;font color=\&quot;#000000\&quot;&gt;&lt;b&gt;Vermelho&#58; XXXX - Laranja&#58; XXXX - Verde&#58; outros&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&quot;&#41;;
    html.append&#40;&quot;&lt;/table&gt;&quot;&#41;;
    retorno = html.toString&#40;&#41;;
   
    retorno = html.toString&#40;&#41;;
 
          
   return retorno;
    
    
    &#125;    
    
&#125;
Só queria saber como retornar uma exception se minha query estiver errada. Leve em consideração que o select é feito em uma view chamada "v_estoque_atual" e que funciona se eu usar o mesmo select direto no banco?!?!?!?
Agradeço a ajuda!
Topicos relacionados
