Re: Q How do I connect a servlet jdbc to oracle

Done it...

driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:<user_id/password>@<host>:1521:<sid>

Matt wrote:
>
> 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 Tue Aug 03 1999 - 17:34:00 CDT