juanferman
Programmer
Hi guy.
Anybody know how to link jsp with oracle??
thanks a lot
===================
:
Juan F. Sarria
Anybody know how to link jsp with oracle??
thanks a lot
===================
:
Juan F. Sarria
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
anybody know how to link jsp with oracle??
- Thread starter juanferman
- Start date
- Status
You can make a DB connection thru JDBC.
Class.forName("oracle.jdbc.driver.OracleDriver"
;
connection=DriverManager.getConnection(myUrl,myUserid,myPassword);
i.e. if your DB name is "abc", your port number is 1521, and your host name is "xyz" then myUrl="jdbc
racle:thin
abc:1521:xyz"
Class.forName("oracle.jdbc.driver.OracleDriver"
;connection=DriverManager.getConnection(myUrl,myUserid,myPassword);
i.e. if your DB name is "abc", your port number is 1521, and your host name is "xyz" then myUrl="jdbc
racle:thinabc:1521:xyz"
purpledawn
Programmer
The JDBC driver can be downloaded from Oracle's website.
jbruggeman
Programmer
I use this class:
(replace all in between <> with your appropriate iformation)
public class DbConn {
private static DbConn database = new DbConn();
// for PostgreSQL
// private String jdbc = "org.postgresql.Driver";
// private String URL="jdbc
ostgresql:<databasename>";
// private String login="<postgres login name>";
// private String passwd="<postgres password>";
// for Oracle
private String jdbc = "oracle.jdbc.driver.OracleDriver";
private String URL="jdbcracle:thin<servername>:1521:<oracle sid>";
private String login="<your oracle login>";
private String passwd="<your oracle password>";
public static Connection con;
private DbConn() {
try {
Class.forName(jdbc);
con = DriverManager.getConnection(URL, login, passwd);
} catch (SQLException e) {
System.out.println("SQL exception bij creatie DbConn" + e);
} catch (ClassNotFoundException e) {
System.out.println("class not found bij creatie DbConn" + e);
}
}
public static DbConn getDbConn() {
return database;
}
}
And download the oracle driver !!!
(replace all in between <> with your appropriate iformation)
public class DbConn {
private static DbConn database = new DbConn();
// for PostgreSQL
// private String jdbc = "org.postgresql.Driver";
// private String URL="jdbc
ostgresql:<databasename>";// private String login="<postgres login name>";
// private String passwd="<postgres password>";
// for Oracle
private String jdbc = "oracle.jdbc.driver.OracleDriver";
private String URL="jdbc
racle:thin<servername>:1521:<oracle sid>";private String login="<your oracle login>";
private String passwd="<your oracle password>";
public static Connection con;
private DbConn() {
try {
Class.forName(jdbc);
con = DriverManager.getConnection(URL, login, passwd);
} catch (SQLException e) {
System.out.println("SQL exception bij creatie DbConn" + e);
} catch (ClassNotFoundException e) {
System.out.println("class not found bij creatie DbConn" + e);
}
}
public static DbConn getDbConn() {
return database;
}
}
And download the oracle driver !!!
- Status
Similar threads
- Locked
- Question
- Locked
- Question