Ok guys, here we are. I have define the new resource inside a <Context> tag
inside a <Host> tag, as suggested by Tomcat documentation. I removed it and
put it inside <GlobalNamingResources> tag like the following:
1. Configure naming Resource:
inside <GlobalNamingResources> i put the following:
<Resource name="jdbc/DBTest" 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. Inside web.xml:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/DBTest</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3. Finally, you have to connect your server to the new resource. To do that,
inside context.xml put the following:
<ResourceLink global="jdbc/DBTest" name="jdbc/DBTest" type="
javax.sql.DataSource"/>
4. Test your code as follow:
<%@ page import = "java.sql.*, javax.naming.*, javax.sql.*" %>
<%
Context initContext = new InitialContext();
DataSource ds =
(DataSource)initContext.lookup("java:comp/env/jdbc/DBTest");
Connection conn = ds.getConnection();
out.println("Connection Established");
%>
Tomcat 6 documentation stated that you have to put naming resource
definition inside the Context tag. And this was the problem, when i removed
it from their it worked find and the connection established successfully.
Anyways, thank you very much buddies for your time and consideration. I am
always saying that the user of this mailing list are the best developers in
the world. ;)
On 7/26/07, Christopher Schultz <[EMAIL PROTECTED]> wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Mohammed,
>
> Mohammed Zabin wrote:
> > If you looked at the exception you will find ClassNotFoundException at
> line
> > 66 in the generated servlet, and this occurs withing the try block, so,
> i
> > think it's a problem of Connector.
>
> You are seriously confused, here.
>
> Your code is not being compiled. Your code is not running. The fact that
> you have a try/catch block in your code is irrelevant.
>
> Why do you think that this "occurs" within the try block? Your stack
> trace does not include any references to your own code. It's simply not
> executing.
>
> And, even if this "occurred" within your try/catch block, you are
> foolishly swallowing all exceptions, meaning that you would never know
> what the problem was.
>
> > But the strange thing is that this
> > code worked fine on a normal java class???
>
> Probably because your "normal java class" actually compiled and ran.
> Something is wrong with your file, not your code.
>
> - -chris
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFGqO9T9CaO5/Lv0PARAuXgAKDBgPM+osNL0y15at28q9YITixicACgqJte
> QOgTrjE+1cqeih2be83XEww=
> =dPUB
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: [email protected]
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
