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! Tomcat 5.0.25
Date Wed, 30 Jun 2004 04:16:38 GMT
Still the same error occured after replacing my service.bat with your
service.bat... (declares tools.jar inside) =|

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

When i run startup.bat... it worked fine again... the following are the
logged
scripts in MS DOS when i run startup.bat...

Jun 30, 2004 11:59:11 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Jun 30, 2004 11:59:11 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 7240 ms
Jun 30, 2004 11:59:12 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 30, 2004 11:59:12 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.0.25
Jun 30, 2004 11:59:12 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Jun 30, 2004 11:59:17 AM org.apache.catalina.core.StandardHost
getDeployer
INFO: Create Host deployer for direct deployment ( non-jmx )
Jun 30, 2004 11:59:17 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:D:\Tomcat_5.0\conf\Catalina
\localhost\admin.xml
Jun 30, 2004 11:59:19 AM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings',
returnNull=tru
e
Jun 30, 2004 11:59:19 AM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.action.ActionResources',
returnNul
l=true
Jun 30, 2004 11:59:21 AM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing,
config='org.apache.webapp.admin.ApplicationResources', retur
nNull=true
Jun 30, 2004 11:59:30 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:D:\Tomcat_5.0\conf\Catalina
\localhost\balancer.xml
Jun 30, 2004 11:59:31 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:D:\Tomcat_5.0\conf\Catalina
\localhost\manager.xml
Jun 30, 2004 11:59:31 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /jsp-examples from URL
file:D:\
Tomcat_5.0\webapps\jsp-examples
Jun 30, 2004 11:59:33 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path  from URL
file:D:\Tomcat_5.0\we
bapps\ROOT
Jun 30, 2004 11:59:34 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /servlets-examples from
URL fil
e:D:\Tomcat_5.0\webapps\servlets-examples
Jun 30, 2004 11:59:35 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /tomcat-docs from URL
file:D:\T
omcat_5.0\webapps\tomcat-docs
Jun 30, 2004 11:59:35 AM org.apache.catalina.core.StandardHostDeployer
install
INFO: Installing web application at context path /webdav from URL
file:D:\Tomcat
_5.0\webapps\webdav
Jun 30, 2004 11:59:36 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Jun 30, 2004 11:59:38 AM org.apache.jk.common.ChannelSocket init
INFO: JK2: ajp13 listening on /0.0.0.0:8009
Jun 30, 2004 11:59:38 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/280
config=D:\Tomcat_5.0\conf\jk2.properties
Jun 30, 2004 11:59:38 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 26689 ms


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


Thanks for the updated service.bat Sir Jake!
I'll test it at once... 

Regarding my database... I'm just using MS Access 2000...
I don't know what driver to use or how to install or configure it that's
why I use sun.jdbc.odbc.JdbcOdbcDriver driver. 
What do you think is the proper driver for MS Access 2000?
and how to install it...?

Thanks!
I'll test your updated service.bat and update you of my progress...

-----Original Message-----
From: Jacob Kjome [mailto:hoju@visi.com] 
Sent: Wednesday, June 30, 2004 10:52 AM
To: Tomcat Users List
Subject: Re: Please Help! Tomcat 5.0.25


At 09:37 AM 6/30/2004 +0800, you wrote:
>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

I see you are using the sun.jdbc.odbc.JdbcOdbcDriver driver.  This is a
bad 
idea.  What Database are you connecting to?  You should use the driver
made 
for that database.

However, I think the error is coming from not having tools.jar in the 
classpath.  You'll have to add this to service.bat.  You might also
notice 
that JSP's don't compile for the same reason.  I have asked the Tomcat 
developers to add tools.jar to classpath in service.bat, but it never
seems 
to get done.  I have created my own copy of service.bat that works
better 
for me and brings it more in line with starting from the startup.bat 
file.  I'll attach it.


Jake


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

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