The thing to remembert is that the ENC does *not* use MySQL's own connection pool implementation -- it uses its own (Tyrex). And Tyrex's mechanism for connectiong to the database requires logging on with a username and password.
Craig On Fri, 14 Dec 2001, Diego Castillo wrote: > Date: Fri, 14 Dec 2001 19:16:39 +0100 > From: Diego Castillo <[EMAIL PROTECTED]> > Reply-To: Tomcat Users List <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > To: Tomcat Users List <[EMAIL PROTECTED]> > Subject: RE: MySQL DataSource using Tomcat 4 > > Hello Craig, > > Thanks for your answer. I have tried your suggestion, but I still have the > same problem: the object I found using JNDI ENC is not initialised, it's > null. This is normal because I have set up my MySQL database so that it > requires no login/password for the moment. > > I am using the following resource definition: > <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> > <parameter><name>user</name><value/></parameter> > <parameter><name>password</name><value/></parameter> > </ResourceParams> > > I have read the JNDI How-To hundreds of times, but I am still missing > something... > > > Diego > > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]De la part de Craig R. > McClanahan > Envoye : vendredi 14 decembre 2001 18:40 > A : Tomcat Users List; [EMAIL PROTECTED] > Objet : Re: MySQL DataSource using Tomcat 4 > > > 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]> > > > -- > 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]>
