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]
