Re: Oracle connection with java
From: godmann <allanwtham_at_yahoo.com>
Date: 17 Sep 2001 21:24:38 -0700
Message-ID: <95cd51c.0109172024.7c30ca2b_at_posting.google.com>
public class Allan extends HttpServlet {
Date: 17 Sep 2001 21:24:38 -0700
Message-ID: <95cd51c.0109172024.7c30ca2b_at_posting.google.com>
Hi there,
Something like this will be fine...
public class Allan extends HttpServlet {
// jdbc:oracle:thin:_at_myhost:1521:orcl static String url = "jdbc:oracle:thin:_at_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:_at_pegagus:1521:awt"; driver = "oracle.jdbc.driver.OracleDriver";
pegagus is your server name, awt should be your database.
Allan W. Tham
DBA
Received on Tue Sep 18 2001 - 06:24:38 CEST