From owner-freebsd-java@FreeBSD.ORG  Mon Aug 15 19:08:15 2005
Return-Path: <owner-freebsd-java@FreeBSD.ORG>
X-Original-To: freebsd-java@FreeBSD.org
Delivered-To: freebsd-java@FreeBSD.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id F25E116A41F;
	Mon, 15 Aug 2005 19:08:14 +0000 (GMT)
	(envelope-from freezumba@terra.com.br)
Received: from itapoa.terra.com.br (itapoa.terra.com.br [200.176.10.194])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7F70D43D46;
	Mon, 15 Aug 2005 19:08:14 +0000 (GMT)
	(envelope-from freezumba@terra.com.br)
Received: from bugala.terra.com.br (bugala.terra.com.br [200.176.10.11])
	by itapoa.terra.com.br (Postfix) with ESMTP id BA4428C00DF;
	Mon, 15 Aug 2005 16:08:12 -0300 (BRT)
X-Terra-Karma: -2%
X-Terra-Hash: a1d2f02e5c886c70db96bc234aa6631a
Received-SPF: pass (bugala.terra.com.br: domain of terra.com.br designates
	200.176.10.11 as permitted sender) client-ip=200.176.10.11;
	envelope-from=freezumba@terra.com.br;
	helo=201-24-206-33.ctame704.dsl.brasiltelecom.net.br; 
Received: from 201-24-206-33.ctame704.dsl.brasiltelecom.net.br
	(201-24-206-33.ctame704.dsl.brasiltelecom.net.br [201.24.206.33])
	(authenticated user freezumba@terra.com.br)
	by bugala.terra.com.br (Postfix) with ESMTP id 1633BBA40CA;
	Mon, 15 Aug 2005 16:08:12 -0300 (BRT)
From: Zumba <freezumba@terra.com.br>
To: freebsd-java@FreeBSD.org
Content-Type: text/plain
Date: Mon, 15 Aug 2005 16:09:54 -0300
Message-Id: <1124133000.89496.22.camel@paulo.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.2.1.1 FreeBSD GNOME Team Port 
Content-Transfer-Encoding: 7bit
Cc: 
Subject: JDBC Driver, Context & DataSource lookup
X-BeenThere: freebsd-java@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting Java to FreeBSD <freebsd-java.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-java>,
	<mailto:freebsd-java-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-java>
List-Post: <mailto:freebsd-java@freebsd.org>
List-Help: <mailto:freebsd-java-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-java>,
	<mailto:freebsd-java-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 15 Aug 2005 19:08:15 -0000

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