Hi Zumba,

It looks like a typo. Change

   Context env = (Context) initialContext.lookup("java:comp/env");

into

   Context env = (Context) initialContext.lookup("java:/comp/env");

Also, I don't think you need to put the entry in your web.xml file.

Cheers,
Frans


On Tue, 16 Aug 2005 12:22:57 -0300, Zumba wrote:
>�I'm trying to connect to mysql database using InitialContext and
>�DataSource lookup but it not works on FreeBSD 5.4 + tomcat 5.5 +
>�jdk 1.5.0 + mysql-connector-java.jar (3.1.0) installed from ports.
>�The application seems that reads ok the JNDI Resources variables
>�but when I invoke dataSource.getConnection() I get the message on
>�SQLException: "Cannot create JDBC class for
>�'com.mysql.jdbc.Driver'. The fact is if I use
>�DriverManager.getConnection("jdbc:mysql//localhost/mysql?params")
>�without handle mysql-connector-java.jar and your directories it
>�(com.mysql.jdbc.Driver) works fine.
>
>�---- META-INF/context.xml:
>�<?xml version="1.0" encoding="ISO-8859-1"?>
>�<Context
>�docBase="${catalina.home}/webapps/Grid"
>�path="/Grid"
>�reloadable="true">
>�<Resource
>�name="jdbc/GridDB"
>�type="javax.sql.DataSource"
>�auth="Container"
>�username="grid"
>�password="abc123456"
>�driverClassName="com.mysql.jdbc.Driver"
>�url="jdbc:mysql://localhost/griddb?autoReconnect=true"/>�</Context>
>
>�---- the reference on WEB-INF/Web.xml:
>�<resource-ref>
>�<res-ref-name>jdbc/GridDB</res-ref-name>�<res-
>�type>javax.sql.DataSource</res-type>�<res-auth>Container</res-auth>
>�</resource-ref>
>
>�---- servlet code:
>�Context initialContext = new InitialContext();
>�Context env = (Context) initialContext.lookup("java:comp/env");
>�DataSource dataSource = (DataSource) env.lookup("jdbc/GridDB");
>�connection = dataSource.getConnection();
>
>�Thanks,
>�Zumba
>
>�______________________________________________________________________
>�_____ To unsubscribe, send email to listserv@(protected)
>�include in the body of the message "signoff SERVLET-INTEREST".
>
>�Archives: http://archives.java.sun.com/archives/servlet-
>�interest.html Resources:
>�http://java.sun.com/products/servlet/external-resources.html
>�LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

===========================================================================
To unsubscribe, send email to listserv@(protected)
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected)".