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; }}