Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  

PreviousPrevious NextNext


~Arnold Chujumilitakoi 2.Nov.03 09:18 AM a Web browser
Domino Server 6.0 Windows 2000


Server message:
Agent printing:java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver

classpath:
C:\Program Files\Sybase\Jaguar CTS 3.5\html\classes;C:\Program Files\Sybase\Jaguar CTS 3.5\java\classes;C:\Program Files\Sybase\Shared\Sun\jdk118\lib\classes.zip;C:\Program Files\Sybase\Shared\PowerBuilder\classes.zip;.;C:\Program Files\Sybase\Shared\Sun\jdk118\lib\classes.zip;C:\App\J2SDK141\lib\servlet.jar;C:\Lotus\Domino\Notes.jar;C:\Lotus\Domino\Data\domino\java\NCSO.jar;C:\Lotus\Domino\Data\domino\java\classes.jar



My Servlet:
Query_Oracle.java
import java.sql.*;
import java.util.*;
import java.io.*;
import java.text.*;
import javax.servlet.*;
import javax.servlet.http.*;
import lotus.domino.*;
import oracle.jdbc.driver.*;
public class Query_Oracle extends HttpServlet
{
public void doGet(HttpServletRequest Request, HttpServletResponse Response)
throws ServletException, IOException
{
Response.setContentType("text/html; charset=gb2312");
PrintWriter toBrowser=Response.getWriter();
toBrowser.println("<html");
toBrowser.println("<head>");
toBrowser.println("<title>查询Oracle数据库</title>");
toBrowser.println("</head>");
toBrowser.println("<body>");
toBrowser.println("<a href=\"#\">查询Oracle数据库</a>");

String odbcQuery;
Connection odbcConn;
Statement odbcStmt;
ResultSet odbcRs;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
System.out.println(e);
}
try
{
odbcConn=DriverManager.getConnection("jdbc:oracle:thin:@(description=(address=(host=10.70.151.10)(protocol=tcp)(port=1521))(connect_data=(sid=orcl)))","River","River");
odbcStmt=odbcConn.createStatement();

odbcQuery="select * from News where rownum<3 order by ID desc";
odbcRs=odbcStmt.executeQuery(odbcQuery);
while(odbcRs.next())
{
toBrowser.println((String)odbcRs.getString("ID")+":"+(String)odbcRs.getString("Subject"));
}
odbcRs.close();
odbcStmt.close();
odbcConn.close();
}
catch(SQLException e)
{}

toBrowser.println("</body></html>");
}
}






Help me to use servlet for connect ... (~Arnold Chujumi... 2.Nov.03)
. . RE: Help me to use servlet for conn... (~James Opnuvitc... 2.Nov.03)





  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS