On Apr 4, 2014, at 1:19 AM, Saurabh Saraswat <ssaras...@pivotalindia.com>
wrote:
Dear All,
I am doing connection pooling with tomcat 7.0.39 and MySQL 5.5.After
searching on google and with your help i have done the below things.
Even i am able to get the connection successfully using this but getting
some trouble and exception.
I am explaining you all steps done by me-
*1. Have created a context.xml*
I have put this context.xml in the META-INF folder of my application. but
when i am deploying the web app to the server then it is not creating its
copy to ${CATALINA-BASE}/conf/Catalina/locathost. Why is that so ?
There are a couple possibilities.
1.) Look at "deployXML" attribute of your <Host> tag. If this is set to
false, it will disable parsing the context XML descriptor embedded inside
the application. This defaults to true, unless you are running with a
security manager, then it defaults to false.
http://tomcat.apache.org/tomcat-7.0-doc/config/host.html#Standard_Implementation
2.) Look at the "copyXML" attribute of both your <Host> and <Context>
tags. This needs to be set to true, because the default in Tomcat 7 is
false.
http://tomcat.apache.org/tomcat-7.0-doc/config/host.html#Standard_Implementation
http://tomcat.apache.org/tomcat-7.0-doc/config/context.html#Standard_Implementation
If both attributes are set properly, you should see the
META-INF/context.xml file from your application copied to
"$CATALINA_BASE/conf/Catalina/localhost".
But when i am putting this context.xml in ${CATALINA-BASE}/conf folder
then
its working.
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/MaxDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="-1"
username="root" password="root"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:MySQL://localhost:3306/MaxDB?zeroDateTimeBehavior=convertToNull"/>
</Context>
*2. Mapping in web.xml*
<resource-ref>
<description>MySql DataSource</description>
<res-ref-name>jdbc/MaxDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
*3. Then on my servlet i am getting the object of connection like this-*
private static InitialContext ic;
protected static DataSource datasource;
private static Context ctx;
public void doSomeStuff() throws DatabaseException
{
Connection conn = null;
try
{
conn= getConnection();
.....................................
// do the required stuff
}
catch (Exception ex)
{
}
finally
{
conn.close();
}
}
*4. This is the method in my DAO Class i am using this method to get the
object of connection at all of my servlet.*
protected static Connection getConnection() throws DatabaseException
{
Connection conn = null;
try
{
ctx = new InitialContext();
datasource = (DataSource)
ctx.lookup("java:/comp/env/jdbc/MaxDB");
conn = datasource.getConnection();
}
catch (Exception ex)
{
}
return conn;
}
Using all this i am able to get connection. But if number of hits
increases
to the server and Initially i got the the below exception-
*org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection,
pool error Timeout waiting for idle object*
This means it was unable to get a connection from the pool within
"maxWait" ms. There are a few reasons this could happen, but I'd guess
it's because of the next error that you reported.
Then i got the exception-
*org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Access denied for user 'root'@'localhost'
(using
password: YES))*
Seems like you can't connect to the database. Have you double checked
your user / password / host configuration info?
Dan
Please assist me to know the root cause of the problem. I have searched
it
on google and have read lots of forum but did not get the satisfactory
answer.
Hope that you all are expert and your suggestion will be valuable for me.
Thanking You!
*Best Regards, *
*Saurabh Sarasvat*
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
