Jake
At 12:16 PM 6/30/2004 +0800, you wrote:
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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] >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 <[EMAIL PROTECTED]>: > > > 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:[EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > -------------------------------------------------------------------- > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > -------------------------------------------------------------------- > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]