Problemas ao Ler dados do Oracle

Programação Java
#1

Olá Amigos, estou começando no mundo Java, e preciso de uma ajuda !!

Depois de fazer a conexão com o bando Oracle e criar a query,
a aplicação compila sem erros, porem ao fazer uma pesquisa na base, o compilador me apresenta o seguinte erro :

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

utilizo o JBuilder2006…

Se puderem me dar uma força ! Abraço

package teste_cadastro_paciente;

import java.awt.BorderLayout;

import javax.swing.;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.GridBagLayout;
import java.awt.;
import java.awt.Rectangle;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.;
import javax.swing.JTextField;
import javax.swing.JLabel;
import com.borland.dx.sql.dataset.;
import java.sql.;
import java.util.;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.dataset.NavigationEvent;
import com.borland.dx.dataset.NavigationListener;

/**

  • <p>Title: </p>

  • <p>Description: </p>

  • <p>Copyright: Copyright © 2007</p>

  • <p>Company: </p>

  • @author not attributable

  • @version 1.0
    */
    public class Consulta_Paciente extends JFrame {
    XYLayout xYLayout1 = new XYLayout();
    JButton btnPrimeiro = new JButton();
    JButton btnAnterior = new JButton();
    JButton btnProximo = new JButton();
    JButton btnUltimo = new JButton();
    JButton btnSalvar = new JButton();
    JButton btnDeletar = new JButton();
    JButton btnAlterar = new JButton();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel1 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel2 = new JLabel();
    Database database1 = new Database();
    QueryDataSet qryPaciente = new QueryDataSet();
    JButton btnLimpa = new JButton();
    JButton btnPesquisa = new JButton();
    public Consulta_Paciente() {
    try {
    jbInit();
    } catch (Exception exception) {
    exception.printStackTrace();
    }
    }

    private void jbInit() throws Exception {
    getContentPane().setLayout(xYLayout1);
    btnPrimeiro.setText("<<");
    btnProximo.setText(">");
    btnUltimo.setText(">>");
    this.setTitle(“Consulta Paciente”);
    btnSalvar.setText(“Salvar”);
    btnDeletar.setText(“Excluir”);
    btnAlterar.setText(“Alterar”);
    jLabel1.setText(“Cod”);
    jLabel2.setText(“Nome”);
    database1.setConnection(new ConnectionDescriptor(
    “jdbc:oracle:thin:@198.17.76.3:1521:hscp”, “dbamv”, “2930down”, false,
    “oracle.jdbc.driver.OracleDriver”));
    btnLimpa.setText(“Limpa”);
    btnLimpa.addActionListener(new Consulta_Paciente_btnLimpa_actionAdapter(this));
    btnPesquisa.setText(“Pesquisa”);
    btnPesquisa.addActionListener(new
    Consulta_Paciente_btnPesquisa_actionAdapter(this));
    qryPaciente.addNavigationListener(new
    Consulta_Paciente_qryPaciente_navigationAdapter(this));
    this.getContentPane().add(btnPrimeiro, new XYConstraints(5, 4, -1, -1));
    this.getContentPane().add(btnAnterior, new XYConstraints(61, 4, -1, -1));
    this.getContentPane().add(btnProximo, new XYConstraints(109, 3, -1, -1));
    this.getContentPane().add(btnUltimo, new XYConstraints(156, 2, -1, -1));
    this.getContentPane().add(btnSalvar, new XYConstraints(212, 3, -1, -1));
    this.getContentPane().add(jTextField2,
    new XYConstraints(176, 115, 179, 24));
    this.getContentPane().add(jLabel2, new XYConstraints(117, 116, 56, 27));
    this.getContentPane().add(jLabel1, new XYConstraints(117, 59, 51, 24));
    this.getContentPane().add(jTextField1,
    new XYConstraints(176, 58, 179, 24));
    this.getContentPane().add(btnDeletar, new XYConstraints(281, 3, -1, -1));
    this.getContentPane().add(btnAlterar, new XYConstraints(351, 3, -1, -1));
    this.getContentPane().add(btnLimpa, new XYConstraints(5, 32, -1, -1));
    this.getContentPane().add(btnPesquisa, new XYConstraints(5, 61, -1, -1));
    btnAnterior.setText("<");
    }

    private void fazConsulta
    (String criterio)
    {
    String comando = "SELECT CD_ATI_MED,DS_ATI_MED FROM ATI_MED ";

     if (!(criterio == null||criterio.equals("")))
     comando += " WHERE CD_ATI_MED = " + criterio;

 qryPaciente.close();
 qryPaciente.setQuery(new QueryDescriptor (database1, comando));
 qryPaciente.open();

 if (qryPaciente.getRowCount() == 0)
     JOptionPane.showMessageDialog(null, "Registro não encontrado");

     else
         qryPaciente.first();

    }

     private void limpaCampos()
 {
         jTextField1.setText("");
         jTextField2.setText("");
 }

 private void moveCampos()
 {
     limpaCampos();
     jTextField1.setText(qryPaciente.getBigDecimal("CD_ATI_MED").toString());
     jTextField2.setText(qryPaciente.getString("DS_ATI_MED"));

 }

    public void btnLimpa_actionPerformed(ActionEvent actionEvent) {
    limpaCampos();
    }

    public void btnPesquisa_actionPerformed(ActionEvent actionEvent) {
    String valor = null;

    if (JOptionPane.showConfirmDialog (null, "Deseja consultar todos os registros?","Sistema",
    JOptionPane.YES_NO_OPTION) == JOptionPane.NO_OPTION)
{

    valor = JOptionPane.showInputDialog("Digite o código do paciente");

    if (valor == null||valor.equals(0))
        return;
}
fazConsulta(valor);

    }

    public void qryPaciente_navigated(NavigationEvent navigationEvent) {

     moveCampos();
 btnPrimeiro.setEnabled(!qryPaciente.atFirst());
 btnAnterior.setEnabled(!qryPaciente.atLast());
 btnUltimo.setEnabled(!qryPaciente.atLast());
 btnProximo.setEnabled(!qryPaciente.atLast());

    }

    public void jButton1_actionPerformed(ActionEvent e) {
    String valor = null;
    fazConsulta(valor);
    }

}

class Consulta_Paciente_qryPaciente_navigationAdapter implements
NavigationListener {
private Consulta_Paciente adaptee;
Consulta_Paciente_qryPaciente_navigationAdapter(Consulta_Paciente adaptee) {
this.adaptee = adaptee;
}

public void navigated(NavigationEvent navigationEvent) {
    adaptee.qryPaciente_navigated(navigationEvent);
}

}

class Consulta_Paciente_btnPesquisa_actionAdapter implements ActionListener {
private Consulta_Paciente adaptee;
Consulta_Paciente_btnPesquisa_actionAdapter(Consulta_Paciente adaptee) {
this.adaptee = adaptee;
}

public void actionPerformed(ActionEvent actionEvent) {
    adaptee.btnPesquisa_actionPerformed(actionEvent);
}

}

class Consulta_Paciente_btnLimpa_actionAdapter implements ActionListener {
private Consulta_Paciente adaptee;
Consulta_Paciente_btnLimpa_actionAdapter(Consulta_Paciente adaptee) {
this.adaptee = adaptee;
}

public void actionPerformed(ActionEvent actionEvent) {
    adaptee.btnLimpa_actionPerformed(actionEvent);
}

}

#2