O pepino é o seguinte:
Criei um programa para acessar uma base Oracle, tipo um “Olá Mundo” só para testar a conexão, o código esta abaixo:
[list]
/*
- To change this template, choose Tools | Templates
- and open the template in the editor.
*/
package testedb2;
import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;
/**
*
-
@author malfatti
*/
public class Main {/**
-
@param args the command line arguments
*/
public static void main(String[] args) {
String Query = “Select sysdate from dual”;
OracleDataSource ODS = null;
Connection conexao = null;
Statement stmt = null;
ResultSet rset = null;System.out.println(“Programa Iniciado!”);
try {
ODS = new OracleDataSource();
} catch (SQLException ex) {
System.out.println(“Problema Carregando Driver Oracle!”);
}
try {
ODS.setDatabaseName(“orcl”);
ODS.setDriverType(“thin”);
ODS.setServiceName(“orcl”);
ODS.setServerName(“server1”);
ODS.setPortNumber(1521);
ODS.setUser(“scott”);
ODS.setPassword(“tiger”);
conexao = ODS.getConnection();
} catch (SQLException ex) {
System.out.println("Problema Conectando com o Oracle: " + ex.getMessage());
System.exit(0);
} finally {
System.out.println(“Conectado com o Oracle!”);
}
try {
stmt = conexao.createStatement();
} catch (SQLException ex) {
System.out.println(“Problema Criando Statement Oracle!”);
System.exit(0);
}
System.out.println(“Executando Query!”);
try {
rset = stmt.executeQuery(Query);
} catch (SQLException ex) {
System.out.println(“Problema Executando Query!”);
System.exit(0);
}
System.out.println(“Query Executada!”);
try {
while (rset.next()) {
System.out.println(rset.getString(1));
QtdLinhas++;
}
} catch (SQLException ex) {
System.out.println("Problema Fetching valores da Query: " + ex.getMessage());
System.exit(0);
}
try {
conexao.close();
ODS.close();
} catch (SQLException ex) {
System.out.println(“Problema Fechando Conexão!”);
System.exit(0);
}
System.out.println(“Programa Concluido!”);
}
}
[/list]
-
Então eu criei outro programa, usando o Swing e objetos gráficos. O código está abaixo:
[list]
/*
- TesteDB3View.java
*/
package testedb3;
import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;
import org.jdesktop.application.Action;
import org.jdesktop.application.SingleFrameApplication;
import org.jdesktop.application.FrameView;
/**
-
The application’s main frame.
*/
public class TesteDB3View extends FrameView {public TesteDB3View(SingleFrameApplication app) {
super(app);initComponents();
}
@Action
/** This method is called from within the constructor to
-
initialize the form.
-
WARNING: Do NOT modify this code. The content of this method is
-
always regenerated by the Form Editor.
*/
@SuppressWarnings(“unchecked”)
//
private void initComponents() {mainPanel = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();mainPanel.setName(“mainPanel”); // NOI18N
jScrollPane1.setName(“jScrollPane1”); // NOI18N
jScrollPane1.setViewportView(Texto);
org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance(testedb3.TesteDB3App.class).getContext().getResourceMap(TesteDB3View.class);
jButton1.setText(resourceMap.getString(“jButton1.text”)); // NOI18N
jButton1.setName(“jButton1”); // NOI18N
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});javax.swing.ActionMap actionMap = org.jdesktop.application.Application.getInstance(testedb3.TesteDB3App.class).getContext().getActionMap(TesteDB3View.class, this);
jButton2.setAction(actionMap.get(“quit”)); // NOI18N
jButton2.setText(resourceMap.getString(“jButton2.text”)); // NOI18N
jButton2.setToolTipText(resourceMap.getString(“jButton2.toolTipText”)); // NOI18N
jButton2.setName(“jButton2”); // NOI18Njavax.swing.GroupLayout mainPanelLayout = new javax.swing.GroupLayout(mainPanel);
mainPanel.setLayout(mainPanelLayout);
mainPanelLayout.setHorizontalGroup(
mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(mainPanelLayout.createSequentialGroup()
.addContainerGap()
.addGroup(mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 380, Short.MAX_VALUE)
.addGroup(mainPanelLayout.createSequentialGroup()
.addComponent(jButton1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 254, Short.MAX_VALUE)
.addComponent(jButton2)))
.addContainerGap())
);
mainPanelLayout.setVerticalGroup(
mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(mainPanelLayout.createSequentialGroup()
.addContainerGap()
.addGroup(mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jButton2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 249, Short.MAX_VALUE)
.addContainerGap())
);setComponent(mainPanel);
}//
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String Query = “Select sysdate from dual”;
OracleDataSource ODS = null;
Connection conexao = null;
Statement stmt = null;
ResultSet rset = null;JOptionPane.showMessageDialog(null, "Programa Iniciado!", "Programa Iniciado!", JOptionPane.INFORMATION_MESSAGE); try { ODS = new OracleDataSource(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, "Problema Carregando Driver Oracle!", "Erro!", JOptionPane.ERROR_MESSAGE); } try { ODS.setDatabaseName("orcl"); ODS.setDriverType("thin"); ODS.setServiceName("orcl"); ODS.setServerName("server1"); ODS.setPortNumber(1521); ODS.setUser("scott"); ODS.setPassword("tiger"); conexao = ODS.getConnection(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, "Problema Conectando com o Oracle: " + ex.getMessage(), "Erro!", JOptionPane.ERROR_MESSAGE); System.exit(0); } finally { JOptionPane.showMessageDialog(null, "Conectado com o Oracle!", "Conectado com o Oracle!", JOptionPane.INFORMATION_MESSAGE); } try { stmt = conexao.createStatement(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, "Problema Criando Statement Oracle!", "Erro!", JOptionPane.ERROR_MESSAGE); System.exit(0); } JOptionPane.showMessageDialog(null, "Executando Query!", "Executando Query!", JOptionPane.INFORMATION_MESSAGE); try { rset = stmt.executeQuery(Query); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, "Problema Executando Query!", "Erro!", JOptionPane.ERROR_MESSAGE); System.exit(0); } JOptionPane.showMessageDialog(null, "Query Executada!", "Query Executada!", JOptionPane.INFORMATION_MESSAGE); try { while (rset.next()) { JOptionPane.showMessageDialog(null, rset.getString(1), "Resultados!", JOptionPane.INFORMATION_MESSAGE); } } catch (SQLException ex) { JOptionPane.showMessageDialog(null, "Problema Obtendo valores da Query: " + ex.getMessage(), "Erro!", JOptionPane.ERROR_MESSAGE); System.exit(0); } try { conexao.close(); ODS.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, "Problema Fechando Conexão!", "Erro!", JOptionPane.ERROR_MESSAGE); System.exit(0); } JOptionPane.showMessageDialog(null, "Programa Concluido!", "Programa Concluido!", JOptionPane.INFORMATION_MESSAGE);
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JPanel mainPanel;
// End of variables declaration
}
[/list] -
Na verdade somente fic um copiar e colar e troquei os System.out.println por JOptionPane.showMessageDialog para ficar mais “Windows”.
E aqui esta o problema: O primeiro programa funciona legal, inclusive testei com uma query mais parruda e tudo funcionou legal, os dados foram mostrados como deveriam. Mas o segundo não, ele cria o OracleDatSource e depois, quando vai executar o getConnection, ele fica uma semana pensando e depois da o erro “the network adapter could not establish the connection”.
Se alguém souber como resolver esta encrenca, desde já agradeço.
Marcos Malfatti.