Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle connection with java
Hi there,
Something like this will be fine...
// jdbc:oracle:thin:@myhost:1521:orcl static String url = "jdbc:oracle:thin:@pegagus:1521:mstr"; static String driver = "oracle.jdbc.driver.OracleDriver"; public void init(ServletConfig config) throws ServletException { super.init(config); log("DatabaseServlet.initialize: starting"); try { //loading the driver Class.forName(driver).newInstance(); } catch(Exception e) { e.printStackTrace(); String errmsg = e.getMessage(); System.out.println("Failed: " + errmsg); } }
Note:
url = "jdbc:oracle:thin:@pegagus:1521:awt"; driver = "oracle.jdbc.driver.OracleDriver";
pegagus is your server name, awt should be your database.
Allan W. Tham
DBA
Received on Mon Sep 17 2001 - 23:24:38 CDT