tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aris Javier" <ajav...@eazix.com>
Subject RE: Please Help!
Date Tue, 29 Jun 2004 09:12:19 GMT
Thanks!

My system works fine when i run tomcat5.0 in console...
but when i run tomcat5.0 in service, this error occurs...

org.apache.commons.dbcp.DbcpException: java.sql.SQLException: General
error

I already declared my enviroment variables.. 
i declared bootstrap.jar and tools.jar in classpath...

anyway, here's my system info...

OS: Windows 2000
Database: MS Access 2000
System DSN: EZX_DS
Technology: Java Servlet/JSP MVC
Tomcat Folder: D:\Tomcat_5.0

Server.xml context...
        <Context path="/tees" docBase="tees" debug="5" reloadable="true"
crossContext="true">
              <Logger className="org.apache.catalina.logger.FileLogger"
                   prefix="localhost_tees_log." suffix=".txt"
                   timestamp="true"/>
              <Resource name="jdbc/EZX_DS"
                   auth="Container"
                   type="javax.sql.DataSource"/>
              <ResourceParams name="jdbc/EZX_DS">
                  <parameter>
                      <name>factory</name>
 
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                  </parameter>
                  <parameter>
                      <name>maxActive</name>
                      <value>100</value>
                  </parameter>
                  <parameter>
                      <name>maxIdle</name>
                      <value>30</value>
                  </parameter>
                  <parameter>
                      <name>maxWait</name>
                      <value>10000</value>
                  </parameter>
                  <parameter>
                       <name>driverClassName</name>
                       <value>sun.jdbc.odbc.JdbcOdbcDriver</value>
                  </parameter>
                  <parameter>
                      <name>url</name>
                      <value>jdbc:odbc:EZX_DS</value>
                   </parameter>
              </ResourceParams>
        </Context>

Web.xml contains...
<web-app>
  <display-name>EAZIX TEES Tomcat to Access</display-name>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/EZX_DS</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>
  <context-param>
     <param-name>configFile</param-name>
 
<param-value>d:\\eazixprojects\\tees\\xml\\mapping.xml</param-value>
  </context-param>
  <servlet>
    <servlet-name>EazixServlet</servlet-name>
    <servlet-class>tees.main.util.EazixServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>EazixServlet</servlet-name>
    <url-pattern>*.ezx</url-pattern>
  </servlet-mapping>

<servlet>
    <servlet-name>CewolfServlet</servlet-name>
    <servlet-class>de.laures.cewolf.CewolfRenderer</servlet-class>
	<!-- sets overlib.js location relative to webapp -->
    <init-param>
        <param-name>overliburl</param-name>
 
<param-value>D:\\eazixprojects\\tees\\js\\etc\\overlib.js</param-value>
    </init-param>
	<!-- turn on or off debugging logging -->
    <init-param>
        <param-name>debug</param-name>
        <param-value>true</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
</servlet>
  <servlet-mapping>
    <servlet-name>CewolfServlet</servlet-name>
    <url-pattern>/cewolf/*</url-pattern>
  </servlet-mapping>
 <welcome-file-list>
  <welcome-file>welcome.jsp</welcome-file>
 </welcome-file-list>
  <error-page>
    <location>msewFailed.jsp</location>
  </error-page>
</web-app>

-----Original Message-----
From: Kunthar [mailto:kunthar@gmx.net] 
Sent: Tuesday, June 29, 2004 3:41 PM
To: Tomcat Users List
Subject: Re: Please Help!


Hello,

Please give us more detail.
Your OS and database to connect to,
Send your server.xml and web.xml definitions.
Then we can have clear idea...

Take care....
Gokhan




Aris Javier wrote:

>Please Help!
>
>This error kept on bugging me everytime i run tomcat5 as service... My 
>environment variables are already declared as well as my system dsn...
>but still...
>
>org.apache.commons.dbcp.DbcpException: java.sql.SQLException: General 
>error
>
>
>Please Help!
>
>Thanks!
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>  
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message