原来做的一个系统,使用java 通过thin模式连接了oracle数据库;
现在重装系统后,不行了。装好jb2006 和 oracle10g后
设置了classpath变量如下:
E:\oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar;E:\oracle\product\10.2.0\db_1\jdbc\lib\nls_charset12.jar;在sql plus里使用scott,tiger访问orcl数据库,成功!
几个关键文件得代码:
package dbconn;
import java.sql.*;public class DbConn {
    private static Connection conn = null;    public static Connection getConn() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(
                    "jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");        } catch (ClassNotFoundException ex) {
            System.out.print("没有找到类");
        } catch (SQLException ex) {
            System.out.print("数据库连接异常");
        }        return conn;
    }
}FenyeBean.java(见回复一)
错误提示,间回复二

解决方案 »

  1.   

    太长,全部粘不下package bean.base;import java.sql.*;
    import dbconn.DbConn;
    public class FenyeBean {
        Connection conn = null;
        Statement stmt = null;
        ResultSet CountTopicrs = null; //初始化总记录数Rs变量
        ResultSet Pagirs = null; //初始化分页时每页的记录集数Rs变量    private int intCountTopic = 0; //主题总数,即select选出的、库中所有记录总数
        public int intPageSize; //每页显示主题数,即每页显示的记录总数
        public int intPageCount; //总页数
        public int intPage = 0; //当前页数
        private String Countsql = null, Pagisql = null, str = null, str_where = null;
        private String str_parameter = "";
    //public static int pages_n=1; //传分页参数值    private String nowPage; //初始化当前页intPage变量,以准确便获取当前页,即获取当前页的具体页号。
        private String HttpFile; //当前的地址栏的文件,即具体jsp文件。//连接数据库,构造方法自动进行
        public FenyeBean() {
            try {
                this.conn = DbConn.getConn();
                this.stmt = conn.createStatement();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
       。。
       
    } //end.
      

  2.   

    2008-9-12 13:39:29 org.apache.catalina.core.StandardContext filterStart
    严重: Exception starting filter BalancerFilter
    java.lang.NoClassDefFoundError: org/apache/tomcat/util/digester/Digester
    at org.apache.webapp.balancer.RulesParser.createDigester(RulesParser.java:65)
    at org.apache.webapp.balancer.RulesParser.<init>(RulesParser.java:43)
    at org.apache.webapp.balancer.BalancerFilter.init(BalancerFilter.java:79)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)
    at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:308)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:79)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3540)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4110)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:894)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:857)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
    at org.apache.catalina.core.StandardService.start(StandardService.java:450)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
      

  3.   

    2008-9-12 13:39:29 org.apache.catalina.core.StandardContext start
    严重: Error filterStart
    2008-9-12 13:39:29 org.apache.catalina.core.StandardContext start
    严重: Context [/balancer] startup failed due to previous errors
    2008-9-12 13:39:29 org.apache.coyote.http11.Http11Protocol start
    信息: Starting Coyote HTTP/1.1 on http-8080
    2008-9-12 13:39:29 org.apache.catalina.startup.Catalina start
    信息: Server startup in 1593 ms
    数据库连接异常java.lang.NullPointerException
    at bean.base.FenyeBean.<init>(FenyeBean.java:28)
    at org.apache.jsp.base.postsearch_jsp._jspService(org.apache.jsp.base.postsearch_jsp:52)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
    java.lang.NullPointerException
    at bean.base.FenyeBean.querySql(FenyeBean.java:139)
    at bean.base.FenyeBean.setQuerysql(FenyeBean.java:59)
    at org.apache.jsp.base.postsearch_jsp._jspService(org.apache.jsp.base.postsearch_jsp:106)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
    java.lang.NullPointerException
    at bean.base.FenyeBean.closeConn(FenyeBean.java:278)
    at org.apache.jsp.base.postsearch_jsp._jspService(org.apache.jsp.base.postsearch_jsp:130)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)