sorry if it's off topic,
I have downloaded from oracle.com the jdbc driver for Oracle 8.1.5 and i
have upload the zipped files (classes111.zip and nls_charset.zip) on
<jrun_root>\lib that is on classpath; I'm trying to connect using JDBC/ODBC
bridge.
My Question is:
- Where's the common Jar Files like mysql jdbc driver ?
The JSP code is here (go down), and it's ok on Tomcat using Mysql driver;
Oracle documentation is confuse about How to access Oracle Database using
JDBC;
Any Idea?
Thanks in advance;
<%@ page import="java.sql.*" %>
<%
String connectionURL = "jdbc:odbc:aceite";
Connection connection = null;
Statement statement = null;
ResultSet rs=null;
%>
<html><body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection =
DriverManager.getConnection(connectionURL,"aceite","pwdsomaace");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM tsm_client");
while (rs.next())
{
out.println(rs.getString("cd_clie")+"<br>");
}
rs.close();
%>
</body>
</html>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
