You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Aris Javier <aj...@eazix.com> on 2004/06/30 03:37:30 UTC

Please Help! Tomcat 5.0.25

Hello!

I installed Tomcat 5.0.25
i noticed that tomcat won't start unless i first make "service install"
command?
under catalina_home/bin/service.bat

also, after running tomcat service... my previous error 
(org.apache.commons.dbcp.DbcpException: java.sql.SQLException: General)
was converted to

org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory, cause: General error

but when i run startup.bat, no error occured... 

what's the difference then? running tomcat as a service and running
tomcat using startup.bat...???
i need to run my application as a service.. so that it will keep on
running eventhough i'm not logged-in...



-----Original Message-----
From: Aris Javier 
Sent: Wednesday, June 30, 2004 8:22 AM
To: Tomcat Users List
Subject: RE: Please Help!


My current tomcat version is tomcat5.0.7 
also, i dont see service.bat under catalina_home/bin folder...

do i have to download latest tomcat version?

-----Original Message-----
From: Jacob Kjome [mailto:hoju@visi.com] 
Sent: Tuesday, June 29, 2004 11:46 PM
To: Tomcat Users List
Subject: RE: Please Help!


You specify Tomcat5.0.  If that's true, you are using a pre-release
version of Tomcat5.  Update to the latest official version (or
Tomcat-5.0.27beta) and retest.  Make sure your driver is in common/lib
as well.  Note that CATALINA_HOME/bin/service.bat can be used to
install/remove the service.  Make sure to set your CATALINA_HOME
variable before you run service.bat.

Jake

Quoting Aris Javier <aj...@eazix.com>:

> 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

---------------------------------------------------------------------
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