On 17 Jul 2010, at 03:12, Praveen Sripati wrote:
> Thanks for the reply.
>
> 1. The primary advantage of the cloud is scalability. We can increase
> servers from 1 to 100 within minutes based on the load. So, initially the
> JDBC URL might have 1 IP and it should be updated to have 100 IPs. So
Thanks for the reply.
1. The primary advantage of the cloud is scalability. We can increase
servers from 1 to 100 within minutes based on the load. So, initially the
JDBC URL might have 1 IP and it should be updated to have 100 IPs. So, the
JDBC URL has to updated dynamically with the number of My
On 16 Jul 2010, at 15:56, Praveen Sripati wrote:
> We are in the process of migrating Tomcat and MySQL to Microsoft Azure Cloud
> and facing challenges due to the dynamic nature of the cloud like allocation
> of dynamic ip and ports to the instances of Tomcat & MySQL in Azure. Because
> of this b
Praveen Sripati wrote:
We are in the process of migrating Tomcat and MySQL to Microsoft Azure Cloud
and facing challenges due to the dynamic nature of the cloud like allocation
of dynamic ip and ports to the instances of Tomcat & MySQL in Azure. Because
of this behavior Tomcat needs to
1) Dynami
> From: giocarmine [mailto:giocarm...@gmail.com]
> Subject: Tomcat and MySQL
>
> i've developed a web application, it runs on Tomcat 5.5.4
Step 1: upgrade. 5.5.4 is over five years old and innumerable bugs and
security issues have been fixed since then.
> It seems that the connection with MySQ
On 18/11/2009 14:57, Neil Aggarwal wrote:
Giocarmine:
It seems that the connection with MySQL it's closed by the
driver due to a
timeout.
Have you set autoReconnect=true in your JDBC url?
jdbc:mysql://localhost:3306/dbName?autoReconnect=true
Opening a single connection, and keeping it open
Giocarmine:
> It seems that the connection with MySQL it's closed by the
> driver due to a
> timeout.
Have you set autoReconnect=true in your JDBC url?
jdbc:mysql://localhost:3306/dbName?autoReconnect=true
Neil
--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host your tomcat
Drop the ?autoReconnect=true from your mysql url and then add
validationQuery="select 1" testOnBorrow="true". I believe the
testOnBorrow is true by default, but their's no harm in setting it
explicitly.
Autoreconnect doesn't do what you'd assume it should. It will not
automatically reco
Luiz Siqueira wrote:
> Sorry about this message but I'm a little despaired.
>
> I create a JAR library with the business logic, I use Hibernate and
> MySQL. Everything work fine but when I try use the JAR from a WebApp
> using the bundled TomCat on NetBeans 5.5 I got an server error. I
> believe t
Not sure if it is the same problem, but we had similar issue and
resolved it by increasing value of wait_timeout in /etc/my.cnf:
wait_timeout=2147483647
I am not sure if the issue we were seeing was tied wth Tomcat or not though.
Martin
On 1/29/07, Chris Long <[EMAIL PROTECTED]> wrote:
Hello,
Sorry about this message but I'm a little despaired.
I create a JAR library with the business logic, I use Hibernate and
MySQL. Everything work fine but when I try use the JAR from a WebApp
using the bundled TomCat on NetBeans 5.5 I got an server error. I
believe that the problem is that the serv
It appears your code is holding on to a connection to the database. Bad
design practice. Review your code for any place that might keep hold of
a connection between requests and make sure the connection is closed.
Also, If you haven't done so yet, use a database connection pool. If
using tomca
If I remember correctly, MySQL basically disconnects and shutdowns after
a certain amount of time. I remember doing something with a
"reload="true" in the datasource to prevent this.
Hopefully someone else may clue you in better, but you may want to check
the datasource props and see if this is va
Hi
We had a simliar problem with Oracle and Tomcat 4.1.30 and a firewall
in between and I don't remember the exact error message, so I'm not sure
if this helps:
The problem was that Tomcat held the DB connection open infinitely, and the
firewall after a while decided it wanted to drop the connect
Thanks again to all !
Did a grep -R on /usr/local and got the file. It is
/usr/local/jakarta/webapps/website/WEB-INF/struts-config.xml and the line
that I had to modify was
Everything works fine now and Thanks again to all of you !!
DK
--
View this message in context:
http://www.nabble.com/T
try the base of usr/local
-Original Message-
From: DK [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 12:48 PM
To: users@tomcat.apache.org
Subject: RE: Tomcat and MySQL error
Thanks to all of you !
I did a search (grep -R) under the /usr/local/jakarta and /etc folder for
this
Thanks to all of you !
I did a search (grep -R) under the /usr/local/jakarta and /etc folder for
this string but found no results. I am still wondering as which file carries
this value.
Thanks again,
DK
--
View this message in context:
http://www.nabble.com/Tomcat-and-MySQL-error-tf2007556.htm
somewhere, likely server.xml, you've got an ODBC setting pointing to the IP
address or domain name of the old box.
Do a global search -- find file or with contents of your old box IP
address/name to find the file(s) that contain said string.
-Original Message-
From: DK [mailto:[EMAIL P
The answer depends on how the MySQL connection is made and where.
Tomcat doesn't offer just one way to handle this or just one place to
configure it. The MySQL connection string can be in server.xml or the
web application itself.
You might want to do a search to see where "www.old-domain.com
I'm not sure if you asked the question at the right place.
Anyways, I think there would be some configuration file / code snippet
which uses the
"www.old-domain.com:3306" while forming the connection URL, which is
passed to the
getConnection(, , ) method.
Hope it helps,
Madhur.
DK wrote:
He
20 matches
Mail list logo
