tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "alessio marinelli" <alessio_marine...@tin.it>
Subject Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
Date Thu, 12 Mar 1998 13:49:43 GMT
when you send a mail tomcat-user@jakarta.apache.org this mail arrive at me
----- Original Message -----
From: <KKolle@gkservices.com>
To: <tomcat-user@jakarta.apache.org>
Sent: Wednesday, March 12, 2003 2:43 PM
Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'


>
> 'please control whern send a mail'
> I'm not sure what you mean by this statement?
>
>
>
>
>                     "alessio
>                     marinelli"             To:     "Tomcat Users List"
<tomcat-user@jakarta.apache.org>
>                     <alessio_marinel       cc:
>                     li@tin.it>             Subject:     Re: AW:
java.sql.SQLException: Cannot load JDBC driver class
>                                             'null'
>                     03/12/1998 07:42
>                     AM
>                     Please respond
>                     to "Tomcat Users
>                     List"
>
>
>
>
>
>
> please control whern send a mail
> ----- Original Message -----
> From: <KKolle@gkservices.com>
> To: <tomcat-user@jakarta.apache.org>
> Sent: Wednesday, March 12, 2003 2:37 PM
> Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class
'null'
>
>
> >
> > 1. starting from <tomcat-home>\bin, I type in the command -  startup.
> > 2. starting from <tomcat-home>\bin, I type in the command -  shutdown.
> >
> > I do this after every change I make to the tomcat configuration.
> > After I issue the command 'startup,' then I see the classpath output in
> that
> > same DOS window.
> >
> > Does my server.xml and web.xml setting look correct to all?
> >
> >
> >
> >
> >
> >                     "Tomcat-RND"
> >                     <tomcatrnd@hot       To:     "Tomcat Users List"
> <tomcat-user@jakarta.apache.org>
> >                     mail.com>            cc:
> >                                          Subject:     Re: AW:
> java.sql.SQLException: Cannot load JDBC driver class
> >                     03/12/2003            'null'
> >                     07:22 AM
> >                     Please respond
> >                     to "Tomcat
> >                     Users List"
> >
> >
> >
> >
> >
> >
> > Hi,
> > Are you looking in a load-on-startup servlet????
> >
> > Pratt.
> >
> > ----- Original Message -----
> > From: <KKolle@gkservices.com>
> > To: <tomcat-user@jakarta.apache.org>
> > Sent: Wednesday, March 12, 2003 6:50 PM
> > Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class
> 'null'
> >
> >
> > >
> > > No I did not, but now I do and I still receive the same error.
> > > I have printed out my classpath on the tomcat startup DOS window.
> > > This is:
> > > **** setting the jdbc jar to classpath *****
> > > ***** classpath is:
> > C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja
> > >
> karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar;
> > ******
> > >
> > > Currently, I have the jdbc jar file under common\lib, server\lib and
> > > webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of
> these
> > > locations.
> > >
> > > btw, I'm a first-timer for connecting Tomcat to a database.
> > >
> > > Thanks
> > >
> > >
> > >
> > >
> > >                     "Clarence
> > >                     Dahlin"                To:     "Tomcat Users List"
> > <tomcat-user@jakarta.apache.org>
> > >                     <clarence.dahlin       cc:
> > >                     @pitch.se>             Subject:     RE: AW:
> > java.sql.SQLException: Cannot load JDBC driver class
> > >                                             'null'
> > >                     03/12/2003 06:55
> > >                     AM
> > >                     Please respond
> > >                     to "Tomcat Users
> > >                     List"
> > >
> > >
> > >
> > >
> > >
> > >
> > > Did you define the driver in you classpath?
> > >
> > > / Clarence Dahlin
> > >
> > > -----Original Message-----
> > > From: KKolle@gkservices.com [mailto:KKolle@gkservices.com]
> > > Sent: den 12 mars 2003 13:49
> > > To: tomcat-user@jakarta.apache.org
> > > Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class
> > > 'null'
> > >
> > >
> > >
> > > I put it under server/lib, but no such luck.....still the same error
> > message.
> > > hmmm
> > >
> > >
> > >
> > >
> > >                     "Uddhav Shirname"
> > >
> > >                     <uddhav_shirname@persist       To:     "Tomcat
Users
> > List"
> > > <tomcat-user@jakarta.apache.org>
> > >                     ent.co.in>                     cc:
> > >
> > >                                                    Subject:     Re:
AW:
> > > java.sql.SQLException: Cannot load JDBC driver class
> > >                     03/12/2003 06:43 AM             'null'
> > >
> > >                     Please respond to
> > >
> > >                     "Tomcat Users List"
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > I am not absolutely sure if this is the problem, but I have placed the
> > > database related jars under server/lib. It works for me.
> > >
> > > -- Uddhav
> > >
> > > ----- Original Message -----
> > > From: <KKolle@gkservices.com>
> > > To: <tomcat-user@jakarta.apache.org>
> > > Sent: Wednesday, March 12, 2003 6:04 PM
> > > Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class
> > 'null'
> > >
> > >
> > > >
> > > > Gerlinde,
> > > >
> > > > Thanks for the response!
> > > > I placed my jdbc jar file under common/lib, but I still get the same
> > error
> > > > message.
> > > > If you or anyone else has any other ideas, that would be greatly
> > > appreciated.
> > > >
> > > >
> > > >
> > > >
> > > >                     "Gerlinde Fischer"
> > > >                     <gerlinde.fischer@wiai.uni-b       To:
"Tomcat
> > > Users List" <tomcat-user@jakarta.apache.org>
> > > >                     amberg.de>                         cc:
> > > >                                                        Subject:
> AW:
> > > java.sql.SQLException: Cannot load JDBC driver class
> > > >                     03/12/2003 05:47 AM                 'null'
> > > >                     Please respond to "Tomcat
> > > >                     Users List"
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hi
> > > >
> > > > where ist your Database Connection? In the server.xml in the
> > > > context for your test application.
> > > >
> > > > The jdbc.driver must be placed into the directory
> > > > common/lib.
> > > >
> > > > I hope this will help.
> > > >
> > > > Regards Gerlinde
> > > >
> > > >
> > > > > -----Ursprungliche Nachricht-----
> > > > > Von: KKolle@gkservices.com [mailto:KKolle@gkservices.com]
> > > > > Gesendet: Dienstag, 11. Marz 2003 22:58
> > > > > An: tomcat-user@jakarta.apache.org
> > > > > Betreff: java.sql.SQLException: Cannot load JDBC driver class
'null'
> > > > >
> > > > >
> > > > > Tomcat version - 4.1.12
> > > > > MySQL version - 3.23.55-nt
> > > > > OS - WinNT
> > > > > JDK - 1.4.1_01
> > > > >
> > > > > I have researched this problem on the internet and in the
> > > > > documentation for
> > > > > Tomcat, and I still haven't resolved this issue. So, I'm looking
> > > > > for help from
> > > > > someone from this list.
> > > > >
> > > > > Here is my URL that I invoke:
http://localhost:8080/dbtest/test.jsp
> > > > > Here is the error I receive:
> > > > >
> > > > > java.sql.SQLException: Cannot load JDBC driver class 'null' at
> > > > >
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
> > > > > rce.java:529)
> > > > >
> > > > > Referencing this URL -
> > > > > http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex
> > > > > amples-howto.html:
> > > > > 1. I have a database and table with 1 row of data
> > > > > 2. Here is the chunk of code that I inserted into my
> > > > > $CATALINA_HOME/conf/server.xml.
> > > > > <!-- Database configuration for MySQL -->
> > > > >           <Context path="/DBTest" docBase="DBTest"
> > > > >         debug="5" reloadable="true" crossContext="true">
> > > > >
> > > > >                <Logger
> > className="org.apache.catalina.logger.FileLogger"
> > > > >                           prefix="localhost_DBTest_log."
> suffix=".txt"
> > > > >                           timestamp="true"/>
> > > > >
> > > > >                <Resource name="jdbc/TestDB"
> > > > >                             auth="Container"
> > > > >                             type="javax.sql.DataSource"/>
> > > > >
> > > > >                <ResourceParams name="jdbc/TestDB">
> > > > >                <parameter>
> > > > >                  <name>factory</name>
> > > > >
> > > > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> > > > >                </parameter>
> > > > >
> > > > >                <!-- Maximum number of dB connections in pool.>
Make>
> sureyou> > >                      configure your mysqld
max_connectionslarge>
> enoughto>> > handle>                      all of your db connections.
Setto 0>
> for no> limit.> >                      -->
> > > > >                <parameter>
> > > > >                  <name>maxActive</name>
> > > > >                  <value>100</value>
> > > > >                </parameter>
> > > > >
> > > > >                <!-- Maximum number of idle dB connections
to>retainin>
> > pool.> >                      Set to 0 for no        -->
> > > > >                <parameter>
> > > > >                  <name>maxIdle</name>
> > > > >                  <value>30</value>
> > > > >                </parameter>
> > > > >
> > > > >                <!-- Maximum time to wait for a dB
connectionto>become>>
> > available>                      in ms, in this example 10 seconds.
An>>>>
> Exception is thrown> if>                      this timeout
isexceeded.Set>to>>
> -1 to wait> indefinitely.>                      -->
> > > > >                <parameter>
> > > > >                  <name>maxWait</name>
> > > > >                  <value>10000</value>
> > > > >                </parameter>
> > > > >
> > > > >                <!-- MySQL dB username and
asswordorBonnections  -->
> > > > >                <parameter>
> > > > >                 <name>username</name>
> > > > >                 <value>bugtracker</value>
> > > > >                </parameter>
> > > > >                <parameter>
> > > > >                 <name>password</name>
> > > > >                 <value>footin</value>
> > > > >                </parameter>
> > > > >
> > > > >                <!-- Class name for mm.mysql JDBC driver -->
> > > > >                <parameter>
> > > > >                   <name>driverClassName</name>
> > > > >                   <value>org.gjt.mm.mysql.Driver</value>
> > > > >                </parameter>
> > > > >
> > > > >                <!-- The JDBC connection url for
connectingto>yourMySQL>
> > dB.> >                      The autoReconnect=true argument to
theurl>makes>
> > sure> that> the>                      mm.mysql JDBC
Driverwillautomatically>>
> > > reconnect if mysqld> closed the>connection.mysqldby>>> default
closes
> idle> connections> after 8 hours.>                      -->
> > > > >                <parameter>
> > > > >                  <name>url</name>
> > > > >                 <!-->
> > > >
> >
<value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>-->
> > > > >
> <value>jdbc:mysql://localhost:3306/bugtracker</value>
> > > > >                </parameter>
> > > > >                </ResourceParams>
> > > > >                </Context>
> > > > > 3. Here is my web.xml under
> > > $CATALINA_HOME/webapps/dbtest/web-inf/web.xml:
> > > > >      <?xml version="1.0" encoding="ISO-8859-1"?>
> > > > >     <!DOCTYPE web-app PUBLIC
> > > > >     "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
> > > > >     "http://java.sun.com/dtd/web-app_2_3.dtd">
> > > > > <web-app>
> > > > >   <description>MySQL Test App</description>
> > > > >   <resource-ref>
> > > > >       <description>DB Connection</description>
> > > > >       <res-ref-name>jdbc/TestDB</res-ref-name>
> > > > >       <res-type>javax.sql.DataSource</res-type>
> > > > >       <res-auth>Container</res-auth>
> > > > >   </resource-ref>
> > > > > </web-app>
> > > > >
> > > > > 4. Added my DB Driver under
> > > > > $CATALINA_HOME/webapps/dbtest/lib/org/git/mm/mysql/Driver.class.
> > > > > I also tried
> > > > > just putting the jar file under the /lib.
> > > > >
> > > > > 5. Created a JSP and class just like in the example above. I just
> > > > > changed my
> > > > > select statement inside the class, that's all.
> > > > >
> > > > > 6. I have verified that my database is indeed running.
> > > > >
> > > > > 7. In my.ini (for MySQL), the port setting is NOT commented. The
> > > > > bind-address IS
> > > > > commented out.
> > > > >
> > > > > Thanks for any help!
> > > > > Kevin
> > > > >
> > > > >
> > > >
> > ---------------------------------------------------------------------
> > > > > 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
> >
> >
>
>
>
> ---------------------------------------------------------------------
> 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