趁休息时间给你详细说一下吧:
一、在tools - > config servers 中 配置Tomcat :
Home directory 为: D:/JBuilder9/thirdparty/jakarta-tomcat-4.1.24-LE-jdk14
main classes 为:org.apache.catalina.startup.Bootstrap二、在projects - > project properties中 的server 中选择 tomcat三、以MSSQL为例:
在server.xml中加:
        <Context path="" docBase="www"
        debug="5" reloadable="true" crossContext="true">

  <Logger className="org.apache.catalina.logger.FileLogger"
     prefix="localhost_www_log." suffix=".txt"
     timestamp="true"/>

  <Resource name="jdbc/MSSQL7.0DB"
       auth="Container" 
       type="javax.sql.DataSource"/>

  <ResourceParams name="jdbc/MSSQL7.0DB">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>300000</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>1000</value>
    </parameter>
    <parameter>
     <name>username</name>
     <value>sa</value>
    </parameter>
    <parameter>
     <name>password</name>
     <value>981050</value>
    </parameter>

    <parameter>
       <name>driverClassName</name>
       <value>com.jnetdirect.jsql.JSQLDriver</value>
    </parameter>

    <parameter>
      <name>url</name>
      <value>jdbc:JSQLConnect://172.16.10.99:1433/database=takam</value>
    </parameter>
    <parameter>
      <name>removeAbandoned</name>
      <value>true</value>
    </parameter>
    <parameter>
      <name>removeAbandonedTimeout</name>
      <value>60</value>
   </parameter>
   <parameter>
     <name>logAbandoned</name>
     <value>true</value>
           </parameter>
  </ResourceParams>
</Context>四、
用如下方法进行调用:
 Connection con =null;
    Statement  stmt=null;
    ResultSet  rs  =null;
javax.sql.DataSource ds = (javax.sql.DataSource)new javax.naming.InitialContext().lookup("java:comp/env/jdbc/MSSQL7.0DB");
        if (ds != null)    con = ds.getConnection();
        if (con != null)   stmt=con.createStatement(                ResultSet.TYPE_SCROLL_SENSITIVE,     ResultSet.CONCUR_READ_ONLY
               );String sql="select * from customer";
try{
  rs=stmt.executeQuery(sql);
}catch(Exception ex){
  ex.PrintStackTrace();
}

解决方案 »

  1.   

    我配置完运行时报了一大串错:
    C:\JBuilder9\jdk1.4\bin\javaw -classpath "C:\JBuilder9\thirdparty\jakarta-tomcat-4.1.24-LE-jdk14\bin\bootstrap.jar;C:\JBuilder9\jdk1.4\lib\tools.jar"  -Dcatalina.home="C:/JBuilder9/thirdparty/jakarta-tomcat-4.1.24-LE-jdk14"  -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=Ryan_bosHP:23724,suspend=y org.apache.catalina.startup.Bootstrap -config C:\work\boscc\Tomcat\conf\server8080.xml start 
    2004-4-12 15:05:05 org.apache.coyote.http11.Http11Protocol init信息: Initializing Coyote HTTP/1.1 on port 8080Starting service Tomcat-StandaloneApache Tomcat/4.1.24-LE-jdk14HostConfig[localhost]: Deploying configuration descriptor jb--default.xmlWebappLoader[/default]: Deploying class repositories to work directory C:\work\boscc\Tomcat\workWebappLoader[/default]: Reloading checks are enabled for this ContextStandardManager[/default]: Seeding random number generator class java.security.SecureRandomStandardManager[/default]: Seeding of random number generator has been completedStandardWrapper[/default:default]: Loading container servlet defaultStandardWrapper[/default:invoker]: Loading container servlet invokerHostConfig[localhost]: Deploying configuration descriptor jb-boscc.xml2004-4-12 15:05:06 org.apache.commons.digester.Digester fatalError严重: Parse Fatal Error at line 1 column -1: 缺少文件根组件。org.xml.sax.SAXParseException: 缺少文件根组件。 at org.apache.crimson.parser.Parser2.fatal(Parser2.java:3182) at org.apache.crimson.parser.Parser2.fatal(Parser2.java:3170) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:501) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.apache.commons.digester.Digester.parse(Digester.java:1562) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:385) at org.apache.catalina.core.StandardHost.install(StandardHost.java:803) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:442) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:399) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:738) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.Catalina.start(Catalina.java:512) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)StandardHost[localhost]: Error deploying application at context path null: org.xml.sax.SAXParseException: 缺少文件根组件。org.xml.sax.SAXParseException: 缺少文件根组件。 at org.apache.crimson.parser.Parser2.fatal(Parser2.java:3182) at org.apache.crimson.parser.Parser2.fatal(Parser2.java:3170) at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:501) at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) at org.apache.commons.digester.Digester.parse(Digester.java:1562) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:385) at org.apache.catalina.core.StandardHost.install(StandardHost.java:803) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:442) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:399) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:738) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.Catalina.start(Catalina.java:512) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)HostConfig[localhost]: Error deploying configuration descriptor jb-boscc.xmljava.io.IOException: org.xml.sax.SAXParseException: 缺少文件根组件。java.io.IOException: org.xml.sax.SAXParseException: 缺少文件根组件。 at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:391) at org.apache.catalina.core.StandardHost.install(StandardHost.java:803) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:442) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:399) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:738) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.Catalina.start(Catalina.java:512) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) 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:324)后面还有
    这是什么问题啊???
      

  2.   

    我本来以为是这些包没加入,我从tools-->configue libraries-->class中引入了这些包,可是还是不行,一样的错误。到底缺少文件跟组件是个什么错误呢?难道是配错了?
      

  3.   

    对了,后面还有很多
    StandardHost[localhost]: MAPPING configuration error for request URI /