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]>
