anybody know how to link jsp with oracle??

[juanferman]

Hi guy.

Anybody know how to link jsp with oracle??

thanks a lot
===================
: Juan F. Sarria

 

[dove85]

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="jdbcracle:thinabc:1521:xyz"

 

[purpledawn]

The JDBC driver can be downloaded from Oracle's website.

 

[jbruggeman]

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 = &quot;org.postgresql.Driver&quot;;
// private String URL=&quot;jdbcostgresql:<databasename>&quot;;
// private String login=&quot;<postgres login name>&quot;;
// private String passwd=&quot;<postgres password>&quot;;
// for Oracle
private String jdbc = &quot;oracle.jdbc.driver.OracleDriver&quot;;
private String URL=&quot;jdbcracle:thin<servername>:1521:<oracle sid>&quot;;
private String login=&quot;<your oracle login>&quot;;
private String passwd=&quot;<your oracle password>&quot;;

public static Connection con;

private DbConn() {
try {
Class.forName(jdbc);
con = DriverManager.getConnection(URL, login, passwd);
} catch (SQLException e) {
System.out.println(&quot;SQL exception bij creatie DbConn&quot; + e);
} catch (ClassNotFoundException e) {
System.out.println(&quot;class not found bij creatie DbConn&quot; + e);
}
}
public static DbConn getDbConn() {
return database;
}
}

And download the oracle driver !!!