请帮我看下Tomcat连Oracle数据库错误.

dave888(dave888)
我的计算机上没有安装Oracle 我是访问数据库服务器
而Oracle的数据库服务器ip:172.16.1.9 端口:1521 sid:orcl
请问有什么不对吗?
你看下:http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html(Oracle8i)
Here we define a Datasource called myoracle using the thin driver to connect as user scott, password tiger to the schema called myschema in the sid called mysid. (Note: with the thin driver this sid is not the same as the tnsname)
中的
Datasource called myoracle
schema called myschema
分别是什么意思?知道的告诉我那帮帮忙!!!

mysql 的配置
需将
commons-dbcp.jar
commons-pool.jar <可到tomcat 的网站下载或用google 搜索，是tomcat的dbcp连接池组件，模认未安装>
copy到 tomcat_home/ common/lib        <Context path="/testapp" docBase="testapp" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/testappDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/testappDB">
<parameter>
       <name>factory</name>
       <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>25</value>
</parameter>
     <parameter>
       <name>maxIdle</name>
       <value>4</value>
     </parameter>
     <parameter>
       <name>maxWait</name>
       <value>10000</value>
     </parameter>
     
<parameter>
              <name>removeAbandoned</name>
              <value>true</value>
            </parameter>
             <parameter>
              <name>removeAbandonedTimeout</name>
              <value>60</value>
            </parameter>
            
     <parameter>
      <name>username</name>
      <value>root</value>
     </parameter>
     <parameter>
      <name>password</name>
      <value></value>
     </parameter>
     <parameter>
        <name>driverClassName</name>
        <value>org.gjt.mm.mysql.Driver</value>
     </parameter>
     <parameter>
       <name>url</name>
       <value>jdbc:mysql://192.168.0.2/testdb</value>
     </parameter>
   </ResourceParams>
</Context>

to: all
请大家帮我看下http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html配置的其中有个参数的意思
Data Sources:myoracle
Schema:myschema
我是按照http://www.zdnet.com.cn/developer/code/story/0,2000081534,39134180-3,00.htm配置的并且也是用他的测试代码testdb.jsp测试,但出现错误如下:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 3 in the jsp file: /testdb.jspGenerated servlet error:
    [javac] Compiling 1 source fileD:\Program\Apache Group\Tomcat4.1\work\Standalone\localhost\_\testdb_jsp.java:64: unclosed string literal
          String strSql = " insert into test(id,name) values('00001','holen')
                          ^An error occurred at line: 3 in the jsp file: /testdb.jspGenerated servlet error:
D:\Program\Apache Group\Tomcat4.1\work\Standalone\localhost\_\testdb_jsp.java:65: unclosed string literal
          ";
          ^An error occurred at line: 3 in the jsp file: /testdb.jspGenerated servlet error:
D:\Program\Apache Group\Tomcat4.1\work\Standalone\localhost\_\testdb_jsp.java:83: unclosed string literal
                throw new SQLException("cannot
                                       ^An error occurred at line: 3 in the jsp file: /testdb.jspGenerated servlet error:
D:\Program\Apache Group\Tomcat4.1\work\Standalone\localhost\_\testdb_jsp.java:84: unclosed string literal
          get Connection pool.");
                              ^An error occurred at line: 3 in the jsp file: /testdb.jspGenerated servlet error:
D:\Program\Apache Group\Tomcat4.1\work\Standalone\localhost\_\testdb_jsp.java:84: ')' expected
          get Connection pool.");
                                 ^
5 errors
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:130)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:293)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:353)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:370)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:473)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:190)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)这东西搞那我几天那请帮帮忙呀

语法错误
String strSql = " insert into test(id,name) values('00001','holen')
^
后面少"

谢谢楼上的回复,不过你没看清楚.我想这段代码没错,问题可能是出在配置上.
.....
String strSql = " insert into test(id,name) values('00001','holen') ";
.....有这一方面经验的高手请多多赐教呀!

你的异常和你的配置没关系，应该是JAVA CODE的问题，提示JSP没有编译过去。看一下
按照你的配置，你只有ROOT这个应用可以使用这个DataSource资源，因为你是配在ROOT应用下的，如果你要让你自己的WEBAPP可以使用这个DataSource的话，你必须把他配在你的WEBAPP下面，如：
<Context path="YOUR-WEBAPP" docBase="YOUR-WEBAPP" debug="0">
<Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
当然，除非你的YOUR-WEBAPP就是在root下面。
在Tomcat 下配置DataSource应该没问题的，我试过，看看你的数据库驱动，配置文件的信息等，细心一点，没问题的！

哦.忘了说我是把测试代码放在D:\Program\Apache Group\Tomcat4.1\webapps\ROOT目录下,我想虽然我这个配置只有ROOT这个应用可以使用这个DataSource资源,但我是把这个应用放在那ROOT下.
应该这样可以.
楼上那为高手我知道你是什么意思,你这样配置
<Context path="YOUR-WEBAPP" docBase="YOUR-WEBAPP" debug="0">
<Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
是想让自己的虚拟目录也可以用这个应用.是吧?
还有我还有没有什么其他的方法测试呢?比如说在JBuilder下做个什么要连数据库的应用的.
请高手帮忙!十分感谢!!!

调试易

请帮我看下Tomcat连Oracle数据库错误.

解决方案 »