RE: Please Help! Tomcat 5.0.25
yes i did... =| after service install... tomcat5 service will be created... then i go to administrative tools - services to run tomcat service... this is the right method? one more thing... why is it that when i run startup.bat, a lot of stuffs have been loaded up...? as compared to when i use tomcat as service? i think that startup.bat is loading something that service don't load? -Original Message- From: Jacob Kjome [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 12:54 PM To: Tomcat Users List Subject: RE: Please Help! Tomcat 5.0.25 I'm at a loss at this point. I'm not sure if there is a specific JDBC driver for Access. I would avoid using Access anyway, but I suppose it might not be by choice. Hopefully someone else will know what is up with using the Sun driver and the Tomcat service. BTW, you did do service remove and then service install, right? 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
Re: Please Help! Tomcat 5.0.25
This may or may not be totally on topic - apologies if it's not... On Wednesday 30 June 2004 12:16 am, Aris Javier 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... I've seen similar errors when running programs as services in a Windows environment. One thing that got me over and over was the data base I was accessing was not local. Because the remote data base needed me to map a drive letter to it, my program running as service failed. Are you by chance attempting to access your data base on a network drive? Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Please Help! Tomcat 5.0.25
When you run a service in WinXX, it does not run with the same rights and settings as the logged in user. If your app needs a mapped drive, then you will have to find a way for your app to map the drive for it's self. This may also be a user rights issue as the service runs without the same credentials as the logged in user. Robert S. Harper 801.265.8800 ex. 255 -Original Message- From: Robert Bateman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 7:39 AM To: Tomcat Users List Subject: Re: Please Help! Tomcat 5.0.25 This may or may not be totally on topic - apologies if it's not... On Wednesday 30 June 2004 12:16 am, Aris Javier 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... I've seen similar errors when running programs as services in a Windows environment. One thing that got me over and over was the data base I was accessing was not local. Because the remote data base needed me to map a drive letter to it, my program running as service failed. Are you by chance attempting to access your data base on a network drive? Bob - 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]
RE: Please Help! Tomcat 5.0.25
No Sir... I'm accessing my database on my pc... MS Access 2000... everything is in my pc... I've tried putting everything under classpath but still this dbcp error occured... But the amazing thing is, no problem occured when i run tomcat not in service... sigh! -Original Message- From: Robert Bateman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 9:39 PM To: Tomcat Users List Subject: Re: Please Help! Tomcat 5.0.25 This may or may not be totally on topic - apologies if it's not... On Wednesday 30 June 2004 12:16 am, Aris Javier 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... I've seen similar errors when running programs as services in a Windows environment. One thing that got me over and over was the data base I was accessing was not local. Because the remote data base needed me to map a drive letter to it, my program running as service failed. Are you by chance attempting to access your data base on a network drive? Bob - 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]
RE: Please Help! Tomcat 5.0.25
No Sir... everything is in my pc... no remote access... Tomcat5.0.25 is in drive D as well as MS Access 2000... I'm also the only user of my pc.. Please Help! -Original Message- From: Robert Harper [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 10:00 PM To: 'Tomcat Users List' Subject: RE: Please Help! Tomcat 5.0.25 When you run a service in WinXX, it does not run with the same rights and settings as the logged in user. If your app needs a mapped drive, then you will have to find a way for your app to map the drive for it's self. This may also be a user rights issue as the service runs without the same credentials as the logged in user. Robert S. Harper 801.265.8800 ex. 255 -Original Message- From: Robert Bateman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 7:39 AM To: Tomcat Users List Subject: Re: Please Help! Tomcat 5.0.25 This may or may not be totally on topic - apologies if it's not... On Wednesday 30 June 2004 12:16 am, Aris Javier 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... I've seen similar errors when running programs as services in a Windows environment. One thing that got me over and over was the data base I was accessing was not local. Because the remote data base needed me to map a drive letter to it, my program running as service failed. Are you by chance attempting to access your data base on a network drive? Bob - 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]
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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value30/value /parameter parameter namemaxWait/name value1/value /parameter parameter namedriverClassName/name valuesun.jdbc.odbc.JdbcOdbcDriver/value /parameter parameter nameurl/name valuejdbc:odbc:EZX_DS/value /parameter /ResourceParams /Context Web.xml contains... web-app display-nameEAZIX TEES Tomcat to Access/display-name resource-ref descriptionDB Connection/description res-ref-namejdbc/EZX_DS/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref context-param param-nameconfigFile/param-name param-valued:\\eazixprojects\\tees\\xml\\mapping.xml/param-value /context-param servlet servlet-nameEazixServlet/servlet-name servlet-classtees.main.util.EazixServlet/servlet-class /servlet servlet-mapping servlet-nameEazixServlet/servlet-name url-pattern*.ezx/url-pattern /servlet-mapping servlet servlet-nameCewolfServlet/servlet-name servlet-classde.laures.cewolf.CewolfRenderer/servlet-class !-- sets overlib.js location relative to webapp -- init-param param-nameoverliburl/param-name
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 namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value30/value /parameter parameter namemaxWait/name value1/value /parameter parameter namedriverClassName/name valuesun.jdbc.odbc.JdbcOdbcDriver/value /parameter parameter nameurl/name valuejdbc:odbc:EZX_DS/value /parameter /ResourceParams /Context Web.xml contains... web-app display-nameEAZIX TEES Tomcat to Access/display-name resource-ref descriptionDB Connection/description res-ref-namejdbc/EZX_DS/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res
RE: Please Help! Tomcat 5.0.25
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
RE: Please Help! Tomcat 5.0.25
I'm at a loss at this point. I'm not sure if there is a specific JDBC driver for Access. I would avoid using Access anyway, but I suppose it might not be by choice. Hopefully someone else will know what is up with using the Sun driver and the Tomcat service. BTW, you did do service remove and then service install, right? 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