Re: Problem connection to an Oracle Database ??

[Rauf Sarwar]

Originally posted by Nelson Broat

Hi, I could use some advice. I'm not sure if this is simply a matter
of improperly displaying results that have been returned, or one of
not properly connecting to the database. What follows is a jsp I
threw together to pull data from a table and display it dynamically
within my I.E. browser.

Did I include all the neccessary Classpaths? When the first classpath
was included with all of the rest on my second IMPORT statement, I
kept receiving "could not compile" error messages. So I put it in
its own IMPORT statement.

Am I issuing the appropriate getConnection method? Thanks for any and
all advice. Appreciate it. Here is the jsp:

<%@ page import="com.epicentric.jdbc.*"%>

<%@ page import="java.util.*,
java.text.*,
java.io.*,
java.net.URL,
com.epicentric.common.*,
java.sql.*"
%>

<%@ include file="/include/common.jsp"%>

<%@taglib uri="epi-tags" prefix="epi_html" %>
<%@taglib uri="module-tags" prefix="mod" %>
<epi_html:controllerURL />
<epi_html:checkTicket />

<%

//instantiate variables
Connection con = null;
Statement stmt = null;
ResultSet rs = null;

try {
//Load the JDBC driver
Class.forName("oracle.jdbc.driver.OracleDriver").n ewInstance();

//Get the connection getConnection("oracle driver", "userID",
"password")
con = DriverManager.getConnection("jdbc:oracle:thin:@dns _name:portnum-
ber:oracle_instancename","userid","password");

stmt = con.createStatement();

//sql statements: create, update, query
rs = stmt.executeQuery("SELECT * FROM DB.DB_RESOURCE WHERE
DB.DB_RESOURCE.CODE = '**'");

while (rs.next())
System.out.println(rs.getString(1));

rs.close();
stmt.close();
con.close();
}
catch(Exception ex) {
System.out.println("Error " + ex.toString());

}
%>

Nelson

Have you included Oracle jdbc driver in your classpath? Depending on
your Oracle version, it would be ORACLE_HOME/jdbc/lib/classesXXX.zip or
classesXXX.jar file.

Regards
/Rauf

--
Posted via http://dbforums.com