if (conn == null) {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@10.30.0.249:1521:scg", "scott", "scott");
output.appendText ("Connected\n");
}
Um abraço!
Rafael.
On Thu, 2003-06-05 at 08:04, roberto amorim wrote:
> Cara o que é isso?
>
> conn = DriverManager.getConnection ("jdbc:oracle:thin:@10.30.0.249:1521:scg", "scott", "scott");
>
> não seria somente isto
> conn = DriverManager.getConnection ("jdbc:oracle:thin:@10.30.0.249:1521", "scott", "scott");
> //@servidor:porta:SID// syntax as <host>:<port>:<sid>
> ou isto
> conn = DriverManager.getConnection ("jdbc:oracle:thin:@scg", "scott", "scott");
> //@servidor:porta:SID// syntax as <host>:<port>:<sid>
>
> espero ter ajudado!
>
>
>
>
> ----- Original Message -----
> From: Jose Antonio - yahoo
> Cc: .Grupo - Java - George ; .Grupo - Java ; .Grupo - Java ; .Grupo - Java ; .Grupo - Java ; .Grupo - Java ; .Grupo - Java
> Sent: Wednesday, June 04, 2003 7:21 AM
> Subject: [enterprise-list] JDBC - Oracle
>
>
> Algum colega poderai me dar um auxilio nesta conexao, e me dizer o q esta errado ??
>
> obrigado
>
> jose antonio
>
> ************************************************************
>
> import java.sql.*;
> import java.awt.*;
> import java.io.*;
> import java.util.*;
>
> public class JdbcApplet extends java.applet.Applet
> {
>
> static final String query = "select 'Hello JDBC: ' || sysdate from dual";
>
> Button execute_button;
>
> TextArea output;
>
> Connection conn;
>
> public void init ()
> {
> this.setLayout (new BorderLayout ());
> Panel p = new Panel ();
> p.setLayout (new FlowLayout (FlowLayout.LEFT));
> execute_button = new Button ("Hello JDBC");
> p.add (execute_button);
> this.add ("North", p);
> output = new TextArea (10, 60);
> this.add ("Center", output);
> }
>
> public boolean action (Event ev, Object arg)
>
> {
>
> if (ev.target == execute_button)
>
> {
>
> try
>
> {
>
> if (conn == null)
>
> {
>
> // pq esta dando ero na linha abaixo ??
>
> DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
>
> conn = DriverManager.getConnection ("jdbc:oracle:thin:@10.30.0.249:1521:scg", "scott", "scott");
> output.appendText ("Connected\n");
> }
>
> Statement stmt = conn.createStatement ();
>
> output.appendText ("Executing query " + query + "\n");
> ResultSet rset = stmt.executeQuery (query);
>
> while (rset.next ())
> output.appendText (rset.getString (1) + "\n");
>
> output.appendText ("done.\n");
> }
> catch (Exception e)
> {
> output.appendText (e.getMessage () + "\n");
> }
> return true;
> }
> else
> return false;
> }
> }
>
>
