Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC OCI works without listener?
Yes, it is possible. Simply make sure the ORACLE_SID environment variable is
set to the SID you want to login to. When constructing the URL connection,
simply leave the "connect string" blank. (The part after the @ symbol). Here
is a simply program to demonstrate:
class JdbcTestOCI {
public static void main (String args[]) throws SQLException {
DriverManager.registerDriver(
new oracle.jdbc.driver.OracleDriver());
String anURL = "jdbc:oracle:oci8:@";
Connection conn =
DriverManager.getConnection(anURL, "scott", "tiger");
Statement stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery("SELECT emp_id, name FROM emp");
while (rset.next()) {
System.out.println("Emp ID : " + rset.getInt(1) ); System.out.println("Emp Name : " + rset.getString(2) + "\n");}
rset.close(); stmt.close(); conn.close();
Emp ID : 1
Emp Name : Name at : 1989
Emp ID : 2
Emp Name : Name at : 1734
Emp ID : 3
Emp Name : Name at : 1717
Emp ID : 4
Emp Name : Name at : 1802
Emp ID : 5
Emp Name : Name at : 1989
Regards,
-- jeff
"JZ" <ibm_97_at_yahoo.com> wrote in message
news:10bc841c.0310061421.4770fbda_at_posting.google.com...
> Oracle 9.2
>
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Received on Mon Oct 06 2003 - 18:56:15 CDT