You also need the database username and password (in the "user" and "password" parameters, respectively). More info in the JNDI How-To, which is part of the docs shipped with Tomcat and also available online.
http://jakarta.apache.org/tomcat/tomcat-4.0-doc/jndi-resources-howto.html Craig On Fri, 14 Dec 2001, Diego Castillo wrote: > Date: Fri, 14 Dec 2001 10:18:58 +0100 > From: Diego Castillo <[EMAIL PROTECTED]> > Reply-To: Tomcat Users List <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > To: Tomcat Users List <[EMAIL PROTECTED]> > Subject: MySQL DataSource using Tomcat 4 > > Hi all! > > I have a JSP that must fetch some information from a MySQL database. > Everything works fine if I create manually a DataSource in my code: > > org.gjt.mm.mysql.MysqlDataSource pool = > new org.gjt.mm.mysql.MysqlDataSource(); > pool.setServerName("localhost"); > pool.setPort(3306); > pool.setDatabaseName("pim"); > > > Now I would like Tomcat to create this DataSource object at start-up and > find it using JNDI ENC. My code looks like: > > InitialContext initialContext = new InitialContext(); > DataSource pool = > (DataSource) initialContext.lookup("java:comp/env/jdbc/pim"); > > > This code does find a DataSource object, but it seems that the object found > is not initialised. I have tried many different combinations for my > "server.xml" file, but it just looks impossible to figure out what the > problem is. The JDBC driver is below common/lib and I am using Tomcat in > standalone mode. My "server.xml" file looks like: > > <Context path="" docBase="pim" debug="0"> > <Resource name="jdbc/pim" auth="Container" type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/pim"> > <parameter> > <name>driverClassName</name> > <value>org.gjt.mm.mysql.MysqlDataSource</value> > </parameter> > <parameter> > <name>driverName</name> > <value>jdbc:mysql://localhost:3306/pim</value> > </parameter> > </ResourceParams> > </Context> > > > Does anybody know what is happening? How do I instruct tyrex about the > factory it should use? > > > Any help would be welcome! > > > Diego Castillo > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
