Q How do I connect a servlet jdbc to oracle

From: Matt <mattzag_at_csi.com>
Date: Sun, 01 Aug 1999 22:54:16 +0100
Message-ID: <37A4C208.1EB5865B@csi.com>

Question

I have jdbc running and it can connect to my oracle database, however I need to connect it to a servlet (http://<domain>/sql.html

How do I do this ?

Many thanks

Matt

I have a jdbc.properties file that contains..

driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle://localhost:8080/test

---

snippet of my jdbcservlet code...

    public void init(ServletConfig config)     throws ServletException
    {

        super.init(config);
        try {
            bundle = ResourceBundle.getBundle("jdbc");
            String sDriver = bundle.getString("driver");
            String sURL = bundle.getString("url");
            driver = (Driver) Class.forName(sDriver).newInstance();
            DriverManager.registerDriver(driver);
            con = DriverManager.getConnection(sURL);
            checkForWarning(con.getWarnings());
            meta = con.getMetaData();
        } catch (Exception e) {
            throw new ServletException(e.toString());
        }

    }

---

Received on Sun Aug 01 1999 - 16:54:16 CDT