I got the same error message as yours. Still trying to figure out
myself.....
--Kawthar
>>> [EMAIL PROTECTED] 17/03/2004 05:46:43 AM >>>
It appears the attachment is stripped off.. Makes sense.. Here is the
file.
[wolfgang]# cat context.xml
<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 sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>javauser</value>
</parameter>
<parameter>
<name>password</name>
<value>javadude</value>
</parameter>
<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that
the
mm.mysql JDBC Driver will automatically reconnect if mysqld
closed
the
connection. mysqld by default closes idle connections after
8
hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/javatest?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
[wolfgang]#
-----Original Message-----
From: Steve Gums [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 2:38 PM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
The .cap file can be open with notepad or whatever.
I have it in the META-INF directory. If I copy the contents of this
into
the server.xml file it starts to work.
Gotta be something simple that I am doing wrong here.
Steve
-----Original Message-----
From: Adam Hardy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 2:07 PM
To: Tomcat Users List
Subject: Re: JDBC problems with MySQL
Steve,
post the Resource & ResourceParams tags from your context for the
webapp. State whether it's in a context.xml file, server.xml or
whatever.
Perhaps we can spot something.
Adam
ps this email has got some weird font - my mail reader is up the creek
at the mo'. sorry
On 03/16/2004 09:47 PM Steve Gums wrote:
> Just an update.
> I included a file, that works great on my webapp that is already
running
on
> an old system, and you can see the change I made, which allows the
app to
> run. Not sure if this helps anyone.
>
> package com.voast.vkey.utils;
>
> import java.io.*;
> import java.sql.*;
> import javax.sql.*;
> import javax.naming.*;
>
> public class DBUtils {
>
> public static Connection getConnection () throws Exception {
>
> Connection con = null;
> /* Trying to figure this error out. --Temp comment--
> try {
> Context ctx = new InitialContext();
> if ( ctx == null ) {
> throw new Exception ("No Context");
> }
> DataSource ds;
> ds = (DataSource)ctx.lookup("java:comp/env/jdbc/VKEYDB");
> if ( ds != null ) {
> con = ds.getConnection ();
> }//end ds != null
> }//try
> catch ( Exception e ) {
> LoggerUtil.globalLog ("ERROR","exception occured: " +
> e.toString() );
> throw (e);
> }//catch
> */
> try {
> Class.forName("com.mysql.jdbc.Driver").newInstance();
> con =
DriverManager.getConnection("jdbc:mysql://localhost/vkey",
> "<USER>","<PASSWORD>");
> }//try
> catch (Exception e) {
> LoggerUtil.globalLog ("DEBUG","exception occured: " +
> e.toString() );
> throw (e);
> }//catch
>
> return con;
>
> }//GetConnection
>
> }//DBUtils
>
> -----Original Message-----
> From: Steve Gums [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 10:57 AM
> To: [EMAIL PROTECTED]
> Subject: JDBC problems with MySQL
>
> Users
>
> I know there has been a bazillion messages about this.
I
> searched the archives and couldn't find anything to solve my
extremely
> annoying issue. It has to be something really simple but I just
can't
find
> it.
>
>
>
> My System:
>
> Solaris 9
>
> Tomcat 5.0.19
>
> MySQL 4.0.18
>
> Connector J 3.0.11
>
>
>
> I have the connector J jar in the /usr/local/tomcat/common/lib dir.
>
> I have basically copied the HOW-TO located at.
>
>
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how
> to.html
>
>
>
> and my result is this.
>
>
> Results
>
>
> Foo Not Connected
> Bar -1
>
>
>
> I have tried everything I can think of. I verified the database and
the
> user/password combo. Works good. I even created a simple Java app
that
> connects and performs queries, which worked. That would indicate
everything
> is cool with the Connector J. I have verified that the jdbc/TestDB
is in
> the context and it is. As best I can tell ds (DataSource) is coming
back
> not null, but the call to getConnection is failing. I created a
little
more
> verbose web app and get the following message.
>
> org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
of
> class '' for connect URL 'null', cause: No suitable driver
>
>
>
> This has to be something simple, because this works fine on my old
machine.
> I know I am forgetting some small step that I did the first time and
failed
> to do again. Trust me I have checked the configs about a million
times,
and
> can't find any differences. Any help would be appreciated.
>
>
>
> Sorry to be so vague here, but this is really simple. I don't know
what
else
> to include for info.
>
>
>
> Steve Gums
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
struts 1.1 + tomcat 5.0.16 + java 1.4.2
Linux 2.4.20 Debian
---------------------------------------------------------------------
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]
Confidential information may be contained in this e-mail and any files transmitted
with it ('Message'). If you are not the addressee indicated in this Message (or
responsible for delivery of this Message to such person), you are hereby notified that
any dissemination, distribution, printing or copying of this Message or any part
thereof is strictly prohibited. In such a case, you should delete this Message
immediately and advise the sender by return e-mail. Opinions, conclusions and other
information in this Message that do not relate to the official business of Maxis shall
be understood as neither given nor endorsed by Maxis.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
