趁休息时间给你详细说一下吧:
一、在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();
}
一、在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();
}
解决方案 »
- 把数组存到数据库中
- 雯字 乱码
- hibernate中sessionfactory 无法创建!!!
- 请大家个点建议
- 关于请求问题
- 获取容器的服务器错误页面servlet中如何获取http响应码
- 启动tomcat异常问题
- 求救!有关spring+hibernate父子关系的级联删除问题
- Flash+webservice传递对象数组一直不能实现--高手教我!急急急急急!
- 使用spring的unit test,找不到配置文件
- 请 CoolAbu(阿卜-Never Stop(★★★★)) 来领分! 多谢指点~
- 问个问题,我在websphere上部署了数据库,用JAVA程序LOOKUP,得到了个对象,但装型时失败。
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)后面还有
这是什么问题啊???
StandardHost[localhost]: MAPPING configuration error for request URI /