-
>From: Mike Curwen [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, February 11, 2004 6:22 PM
>To: 'Tomcat Users List'
>Subject: RE: Re: Re: Re: Re: Re: Re: Re: Re: Re: Another Try at MySQL
>Connection Pooling
>
>
> Stupidest auto-responder *EVER*
>
>
>
This is what works for me - (see NOTES at end - if anyone can shed any light
on Limiting Pool size)
#1in your Server.xml
factory
com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory
port
3306
Stupidest auto-responder *EVER*
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 11, 2004 5:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Another Try
> at MySQL
Merrill,
I think everyone's waiting to see you kick yourself when you discover
what the problem is... ;)
No seriously, there are 2 things that I would try - (1) debug the
context - I think it returns an enum of entries available from some
method, and (2) go back to the most basic test servlet /
you a copy of my files. Two differences: I am on
linux and 4.1.29.
- Original Message -
From: "Merrill Cornish" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 5:34 PM
Subject: RE: Another Try at MySQL Conne
Well, it's not that I'm an expert... I actually have had that problem
once or twice, and most of the time the problem was in the context.xml
I've always specified my webapps' in a separated file (which I
believe you're also doing), but when I messed up with server.xml I had
some namingExceptions
Jay,
>>> once in my .WAR, and once as a result of my Ant deploy task
I have yet to move to that plane of confusion. I'm not using a META-INF directory
or a .WAR file since I'm still trying to figure out WHAT to deploy. I am manually
editing
* the conf/server.xml file (to change the def
Doug,
The application directory under webapps is named "timesheet", therefore, the context
fragment in conf/Catalina/localhost is "timesheet.xml" to match the context name. The
beginning of the element in timesheet.xml is
to match the directory name under webapps. So, I think as far as
ying to run as a service.
Jay
-Original Message-
From: Parsons Technical Services [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 3:56 PM
To: Tomcat Users List
Subject: Re: Another Try at MySQL Connection Pooling
Merrill,
Humor me for a moment. This might be due to you trying different
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
auto-reply sucks for mailing lists...
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 11, 2004 4:11 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Re: Re: Re: Re: Re: Re: Another Try at MySQL Connection
> Pooling
>
>
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Ya hemos recibido su solicitud de correo en breve le enviaremos su nombre de usuario y
contreseña.
Gracias por confiar en nosotros
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
the same. Let's just say
I'm shiny on top
and little things like this didn't help.
Doug Parsons
www.parsonstechnical.com
- Original Message -
From: "Adam Hardy" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesda
On 02/11/2004 10:15 PM Merrill Cornish wrote:
Adam,
The following line occurs in stdout.log:
INFO: Processing Context configuration file URL file:C:\Program Files\Apache Group\Tomcat 5.0.18\conf\Catalina\localhost\timesheet.xml
so it appears to be getting the correct context fragment.
What if th
Adam,
The following line occurs in stdout.log:
INFO: Processing Context configuration file URL file:C:\Program Files\Apache
Group\Tomcat 5.0.18\conf\Catalina\localhost\timesheet.xml
so it appears to be getting the correct context fragment.
Merrill
Doug,
>>> "Timesheet" vs. "timesheet"
Good catch, but it didn't make any difference.
I originally had three entries for names "Timesheet", (the way I thought
of it), "timesheet" (for those who don't want to use the shift key), and "ts" (for
those diehard Unix freaks who believe anythi
hen this could be an issue.
Probably not, but worth mentioning, just in case.
Jay
-Original Message-
From: Merrill Cornish [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 2:04 PM
To: Tomcat Users List
Subject: RE: Another Try at MySQL Connection Pooling
Jay,
Context
AIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 2:27 PM
Subject: RE: Another Try at MySQL Connection Pooling
> Ken,
>
> I didn't intend to include the password in ANY of my posts, but I guess
some slipped though. In t
PM
To: Tomcat Users List
Subject: RE: Another Try at MySQL Connection Pooling
Jay,
Context initialContext = new InitialContext();
Context envContext = (Context) initialContext.lookup("java:comp/env");
this.dataSource = (DataSource) envContext.lookup("jdbc/TimesheetsDB
");
Ken,
I didn't intend to include the password in ANY of my posts, but I guess some slipped
though. In the version that running, the password is there. And, even if I had
fumble fingered the password, THAT would have simply gotten a convention MySQL error
rather than a NameNotFoundException for
o: "Tomcat Users List" <[EMAIL PROTECTED]>
Cc: "Merrill Cornish" <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 2:33 PM
Subject: Re: Another Try at MySQL Connection Pooling
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Parsons Technical
Doug,
I noticed the class name discrepancy myself between the name I had used for
DriverManager and the one the DataSource example had. However, when I peeked inside
the Connector/J jar file, I found both .class files, altough they are of different
sizes.
I tried it with your alternative, but
Jay,
Context initialContext = new InitialContext();
Context envContext = (Context) initialContext.lookup("java:comp/env");
this.dataSource = (DataSource) envContext.lookup("jdbc/TimesheetsDB ");
Ah ha! I was missing the second step. When I added the second step, it still fails,
but the c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Parsons Technical Services wrote:
> Merrill,
>
> I may end up eating a little sole, but I have had shoe before.
>
> Your name for the jdbc is wrong. It should be:
>
>
>
>driverClassName
>com.mysql.jdbc.Driver
>
>
> Yeah, I k
for "jdbc/TimesheetsDB" it should be fine.
Let us know
Doug Parsons
www.parsonstechnical.com
- Original Message -
From: "Merrill Cornish" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004
DataSource) envContext.lookup("jdbc/TimesheetsDB ");
Just a thought, in case you've got one of the strings wrong.
Jay
-Original Message-
From: Merrill Cornish [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 11:43 AM
To: Tomcat Users List
Subject: Re: Anothe
Merrill,
Much of what you're doing is just beyond me but I can't help but noticing
this in your first post.
password
xxx
Since you've included a password value in all the other places I'm wondering
if the lack of it here could be part of the problem.
Sorry if I'm way
David,
I THINK I've figure out that MySQL's Connector/J jar worked in jre/lib/ex when I was
using DriverManager because only MySQL needed to see it, and it knew to look in
jre/lib/ex. However, with DataSource, I'm assuming it's Tomcat who needs to see it,
so it needs to be in Tomcat's common/l
I think I read the using named pipes is faster, but that's not going to be a problem
here. If I can't get named pipes to work, then I'll try using TCP/IP restricted to
localhost.
Actually, this whole DataSource experiment has a questionable return on investment. I
already have it working just
I'll add another 2 to the pool :)
-Original Message-
From: Philipp Taprogge [mailto:[EMAIL PROTECTED]
Sent: 11 February 2004 16:24
To: Tomcat Users List
Subject: Re: Another Try at MySQL Connection Pooling
Hi!
Mark Matthews wrote:
> On most versions of Windows, using JDBC a
Hi!
Mark Matthews wrote:
On most versions of Windows, using JDBC and MySQL with named pipes will
give you a 50-60% performance improvement.
Which IMO is by no way an intidator of Win's greatness in named pipes
but rather of it's bad TCP implementation. Instead of relying on named
pipes one shoul
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yiannis Mavroukakis wrote:
> As far as the listening bit is concerned why not just limit mySQL to
listen
> on localhost then?
> Do you get better performance out of named pipes?
On most versions of Windows, using JDBC and MySQL with named pipes will
at MySQL Connection Pooling
Jay,
Thanks for your comments.
I think the problem may be that I don't have the MySQL Connector/J jar in
the common/lib. When using DriverManager, it worked fine in jre/lib/ext,
which is one of the places the MySQL documentation recommended. I need to
try again
Jay,
Thanks for your comments.
I think the problem may be that I don't have the MySQL Connector/J jar in the
common/lib. When using DriverManager, it worked fine in jre/lib/ext, which is one of
the places the MySQL documentation recommended. I need to try again with it in the
new location.
Oops. Haven't had my coffee yet. I read MySQL but thought SQL Server.
Obviously my DB is different than yours, so that may explain our
differences.
But either way, my previous post might still help.
Jay
-Original Message-
From: Merrill Cornish [mailto:[EMAIL PROTECTED]
Sent: Tuesday
ou're
interested, email me offline and I'd be happy to forward it to you as
well.
Let us know how it progresses.
Jay
-Original Message-
From: David Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 8:03 AM
To: Tomcat Users List
Subject: Re: Another Try at MyS
I'm using this setup on a linux box and the only thing I can see
different is your URL. I'm not familiar with the named pipes method
of accessing MySQL from Tomcat. My URL is of this format:
jdbc:mysql://[server name]:3306/[database name]?autoReconnect=true
Also, did you place the mysql-connn
45 matches
Mail list logo