MyEclipse6.0中如何配置Oracle 10g数据库

我在MyEclipse6.0的DB Browser中配置Oracle 10g，在DB Browser中可以连上去，但是点SCOTT用户下的Table时，MyEclipse就自动退出了，提示出错。
然后我写了一段代码测试时，代码如下：
<%@ page language="java" import="java.util.*" pageEncoding="gb2312" import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<%    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    String url="jdbc:oracle:oci8:@ORCL";
String uid="scott";
String pwd="tiger";
    Connection con = DriverManager.getConnection(url,uid,pwd);
    Statement stmt=con.createStatement();
    ResultSet rst=stmt.executeQuery("select * from DEPT");
    while(rst.next())
    {
    out.println("<tr>");
    out.println("<td>"+rst.getString("DNAME")+"</td>");
    out.println("</tr>");
    }
    //关闭连接、释放资源
    rst.close();
    stmt.close();
    con.close();
    %>    
</body>
</html>又提示如下错误，请问如何修改啊。HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: no ocijdbc10 in java.library.path
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.index_jsp._jspService(index_jsp.java:79)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
java.lang.Runtime.loadLibrary0(Runtime.java:822)
java.lang.System.loadLibrary(System.java:992)
oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3138)
java.security.AccessController.doPrivileged(Native Method)
oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3134)
oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:220)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:438)
oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:131)
oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:77)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.index_jsp._jspService(index_jsp.java:54)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

解决方案 »

  1.   

    root cause  java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path 驱动包没有
      

  2.   

    String url="jdbc:oracle:oci8:@ORCL"; 
    你用的是ORACEL自带的服务器，还是使用了如“TOMCAT”服务器？如果是后者的话，你这句话似乎掉了服务器端口号
      

  3.   

    未加载 ORACLE 10G驱动JAR包
      

  4.   

    String url="jdbc:oracle:oci8:@ORCL"; 这是oci的驱动包  如果用classes12.jar 驱动包的话，连接字符串是这样的 jdbc:oracle:thin:@192.168.1.218:1521:orcl
      

  5.   

    oci驱动包是不是需要在本地安装oracle的客户端？