Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-dev@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of Chiradeep.Vittal@citrix.com
 designates 66.165.176.63 as permitted sender)
From: Chiradeep Vittal <Chiradeep.Vittal@citrix.com>
To: "cloudstack-dev@incubator.apache.org"
	<cloudstack-dev@incubator.apache.org>
Date: Thu, 3 May 2012 13:02:15 -0700
Subject: FW: Avoid tomcat6.0.35 (java.sql.SQLException: No suitable driver
 found for
 jdbc:mysql://localhost:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true)
Thread-Topic: Avoid tomcat6.0.35 (java.sql.SQLException: No suitable driver
 found for
 jdbc:mysql://localhost:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true)
Thread-Index: Ac0pZ6Suhnm2VhPfR9uC3JTCmWJu3g==
Message-ID: <CBC83230.1FC5C%chiradeep.vittal@citrix.com>
In-Reply-To: 
 <93099572B72EB341B81A644E134F240B010A7DCDA49A@SJCPMAILBOX01.citrite.net>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-MacOutlook/14.13.0.110805
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_CBC832301FC5Cchiradeepvittalcitrixcom_"
MIME-Version: 1.0

--_000_CBC832301FC5Cchiradeepvittalcitrixcom_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable


From: Frank Zhang <Frank.Zhang@citrix.com<mailto:Frank.Zhang@citrix.com>>
Date: Tue, 10 Jan 2012 13:56:14 -0800

Subject: Avoid tomcat6.0.35 (java.sql.SQLException: No suitable driver foun=
d for jdbc:mysql://localhost:3306/cloud?autoReconnect=3Dtrue&prepStmtCacheS=
ize=3D517&cachePrepStmts=3Dtrue)

If you see exception:


  [java] java.sql.SQLException: No suitable driver found for jdbc:mysql://l=
ocalhost:3306/cloud?autoReconnect=3Dtrue&prepStmtCacheSize=3D517&cachePrepS=
tmts=3Dtrue

     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:=
640)

     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:=
200)

     [java]     at org.apache.commons.dbcp.DriverManagerConnectionFactory.c=
reateConnection(DriverManagerConnectionFactory.java:75)

     [java]     at org.apache.commons.dbcp.PoolableConnectionFactory.makeOb=
ject(PoolableConnectionFactory.java:582)

     [java]     at org.apache.commons.pool.impl.GenericObjectPool.borrowObj=
ect(GenericObjectPool.java:1181)

     [java]     at org.apache.commons.dbcp.PoolingDataSource.getConnection(=
PoolingDataSource.java:106)

     [java]     at com.cloud.utils.db.Transaction.getStandaloneConnectionWi=
thException(Transaction.java:199)

     [java]     at com.cloud.utils.db.Transaction.getStandaloneConnection(T=
ransaction.java:208)


Please check if you are using tomcat6.0.35. We do have this driver cloud-my=
sql-connector-java-5.1.7-bin.jar which works peacefully with former version=
s of tomcat6.

I have been investigating this for a while, my best guess is tomcat silentl=
y did some tricks in its library loading method. I had sent a mail to tomca=
t6 community but received no reply yet, and the 6.0.35 release notes have n=
o particulars as well.
As 6.0.35 is the newest version, the older one 6.0.33 works well.


--_000_CBC832301FC5Cchiradeepvittalcitrixcom_--