Cara Carla, estou lhe enviando um exemplo de uma simples conex�o que traz
dois campos da tabela EMP!!!!!!
� s� copiar esse exemplo e compilar e rodar, .!!!!!!
Qualquer duvida � s� falar. ok ?
Anderson A. De Bona
[EMAIL PROTECTED]
*****************************
import java.sql.*;
import oracle.jdbc.driver.OracleDriver;
import java.util.Date;
public class teste_oracle {
public static void main(String args[]) {
Connection con;
Statement stmt;
String query = "select ename, hiredate from emp";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con =
DriverManager.getConnection("jdbc:oracle:thin:@192.138.5.20:1521:ORCL", "scott",
"tiger");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
System.out.println("Teste Oracle");
while (rs.next()) {
String s = rs.getString("ENAME");
Date bh = rs.getDate("HIREDATE");
System.out.println(s + " " + bh);
}
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
*********************************
Carla Tiaki Utsunomiya <[EMAIL PROTECTED]> em 04/08/2000 10:55:18
Para: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:
Assunto: Conex�o com Oracle!!
Pessoal, estou tendo problemas ao tentar estabelecer uma conex�o com o bd
Oracle.Estou tentando fazer esta conex�o com um programa simples:
import java.sql.*;
class jdbc_test {
public static void main (String args []) throws SQLException {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =DriverManager.getConnection
("jdbc:oracle:thin:@amazonia:1521:orcl","scott@lacta","tiger");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery("select ename from emp");
while (rset.next ())
System.out.println (rset.getString (1));
}
}
E os erros s�o estes:
Exception in thread "main" java.sql.SQLException: Exce��o de I/O:
Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=135286784)(ERR=12505)(ERROR_STACK=(ERROR
=(
CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java,Compiled
Code)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java,Compiled
Code)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java,Compiled
Code)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java,
CompiledCode)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java,Comp
iled Code)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java,Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java,Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java,
Compiled Code)
at jdbc_test.main(jdbc_test.java, Compiled Code)
Se algu�m puder me ajudar, eu agradeceria muito!
t+,Carla.
* Para n�o receber mais e-mails desta lista envie um e-mail para
[[EMAIL PROTECTED]]
e no corpo do email escreva [unsubscribe <seu-email>] ou acesse
http://apoio.cits.br:8080/guest/RemoteListSummary/javabr
Veja as mensagens antigas em http://www.mail-archive.com/javabr%40cits.br/
* Para n�o receber mais e-mails desta lista envie um e-mail para
[[EMAIL PROTECTED]]
e no corpo do email escreva [unsubscribe <seu-email>] ou acesse
http://apoio.cits.br:8080/guest/RemoteListSummary/javabr
Veja as mensagens antigas em http://www.mail-archive.com/javabr%40cits.br/
