Oracle Login Procedure in 346 RC and 152 A/C RC
-
After login (in 346 RC, userid = "student", with no password)
-
go to Start, Programs, Oracle10g Application Server - Oracle 10g DS,
Application Development
There is a SQL Plus icon on the 346 RC desktops, but not on the 152C RC desktops.
- Login as your "SXX" account, with the initial password "tiger".
You should change the password using the "PASSWORD" command at the
SQL prompt.
Host string is "cseora10". You will then connect to the
Oracle SID starter database.
-
The lab schedule for 346 RC is available at:
http://charlie.cs.wright.edu
Oracle Reference
-
Rajshekhar Sunderraman, ORACLE Programming: A Primer,
Addison-Wesley.
JDBC
The java source must contain the DB host string name, such as cseora10, to
work properly:
import java.sql.*;
import java.io.*;
class simple{
public static void main (String[] args)
throws SQLException, IOException{
try{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
System.out.println("Could not load the drive");
}
String user, pass;
//user=readEntry("userid : ");
//pass=readEntry("password: ");
Connection conn=DriverManager.getConnection(
"jdbc:odbc:cseora10", "userid", "password");