CATALINA_HOME/lib implies this is tomcat 6 and that would be the proper
place for the mysql jar file. However the poster should NEVER mess with
the classpath in tomcat as it does cause soooo many headaches.
--David
Propes, Barry L wrote:
did you also have the Oracle jar file in that lib directory? I would have
thought you'd want it in the common/lib dir.
-----Original Message-----
From: Mohammed Zabin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 25, 2007 12:52 AM
To: Tomcat Users List
Subject: Re: MySql Connector
In cotrast, i have installed Oracle and worked very well, but MySql didn't
work with me. I am using Connecter/J from MySql website, the beta version, I
put the jar file in the CATALINA_HOME/lib, and i add it to the CLASSPATH.
and I followed the instructions provided in Tomcat documentation, exactly,
Didn't work :(
On 7/24/07, David Smith <[EMAIL PROTECTED]> wrote:
I've never dealt with Oracle but have done a lot of MySQL installs
without a single failure. Your config outside of the web.xml doesn't
look wrong in any way.
You might want to put the <resource-ref> block in your web.xml as
described in the how-to's. It doesn't hurt and is part of the servlet
spec.
--David
Mohammed Zabin wrote:
No, the same error, You know what David?? I put nothing in web.xml, I am
confused about this issue, when to use web.xml, and it might be the
reason
behind the unsuccessfull MySql Connection, I follow the same procedure I
followed to configure Oracle DBCP, I think it must work for MySql,
right?
On 7/24/07, David Smith <[EMAIL PROTECTED]> wrote:
Try this variant of your code:
Context initContext = new InitialContext();
DataSource ds =
(DataSource)initContext.lookup("java:comp/env/jdbc/TestMySql");
Connection conn = ds.getConnection();
out.println("Connection Established");
Essentially when you lookup java:comp/env/jdbc/TestMySql, that's the
full JNDI path to the DataSource and returns a DataSource type object,
not a Context type object.
--David
Mohammed Zabin wrote:
Ok thank you, I did the following as you have stated:
1. in server.xml:
<Resource name="jdbc/TestMySql" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="exam" driverClassName="
com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/exam"/>
2. in context.xml
<ResourceLink global="jdbc/TestMySql" name="jdbc/TestMySql" type="
javax.sql.DataSource"/>
3. in my test page:
Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup("java:comp/env/jdbc/TestMySql");
DataSource ds = (DataSource)envContext.lookup("jdbc/TestMySql");
Connection conn = ds.getConnection();
out.println("Connection Established");
And i put nothing in web.xml, I have the following error:
org.apache.jasper.JasperException: Unable to compile class for JSP:
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(
DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(
ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(
JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(
JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(
JspServletWrapper.java:308)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java
:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
On 7/23/07, David Smith <[EMAIL PROTECTED]> wrote:
A few things to consider:
1. Either place your Resource definition in server.xml as a
GlobalResource *OR* in your webapp's context.xml file.
2. If you have the Resource defined in the GlobalResources, that's
the
only time you need to use a ResourceLink element in context.xml.
3. Drop the autoReconnect parameter in your mysql URL. It has it's
uses, but not in a pooled environment.
4. You should probably be attempting to use the path
java:comp/env/jdbc/TestMySQL (note the lack of a '/' before comp) as
described in the JNDI howto on tomcat's website. I think I saw you
using java:/comp/env/jdbc/TestMySQL in one of your posts.
5. Please post relevant messages from your logs if this isn't
working.
--David
Mohammed Zabin wrote:
Would you please be more specific? which file you mean? I have
created
Oracel connection Pool as the stated way above, and it's worked
fine,
shall
i put resource defeninitoin in context.xml only?
On 7/22/07, Pid <[EMAIL PROTECTED]> wrote:
You only need one resource definition.
You only need a resource link definition if your resource is a
global
one.
Simplify your configuration and then post the error message
from the
logs so we can see Tomcat says is wrong.
p
Mohammed Zabin wrote:
Hi All
I have confiured oracle connection pool on my tomacat 6, and it
worked
fine.
When i came to configure MySql, I repeated the same steps for
Oracle
databse, with considering the specfication of MySql database.
But
it's
didn't work. Any Help please about configuring MySql,
I downloaded MySql connector from mysql website and place it in
CATALINA_HOME/lib directory, and i put the following:
1. in server.xml file:
<Resource name="jdbc/TestMySql" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="*" password="*" driverClassName="
com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/exam?autoReconnect=true"/>
2. in web.xml file
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/TestMySql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3. in context.xml file (on server's context.xml file):
<Resource name="jdbc/TestMySql" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="*" password="*" driverClassName="
com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/exam"/>
4. in cotext.xml file ( In my web application's context.xml
file):
<ResourceLink global="jdbc/TestMySql" name="jdbc/TestMySql"
type="
javax.sql.DataSource"/>
Any Help please?
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]