tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacob Kjome <h...@visi.com>
Subject RE: Please Help! Tomcat 5.0.25
Date Wed, 30 Jun 2004 04:54:12 GMT
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: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


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