How to connect mysql database with struts application through jndi

[Satchidananda Mohanty]

Hi,

Could you say me how to connect the mysql database from a struts application through jndi process.

I have used these steps..

Context.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context>
    <!-- Specify a JDBC datasource -->
    <Resource name="jdbc/mydatabase" 
              auth="Container"
              type="javax.sql.DataSource" 
              username="username" 
              password="password"
              driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://127.0.0.1:3306/dbname?autoReconnect=true"
              validationQuery="select 1"
              maxActive="10" 
              maxIdle="4"/>

    <!-- Specify the security realm and location of the users file
    <Realm className="org.apache.catalina.realm.MemoryRealm" 
           pathname="/tomcat/webapps/ROOT/WEB-INF/users.xml" />
    -->
</Context>

in my action class i have used

// Get DataSource
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mydatabase");
// Get Connection and Statement
Connection c = ds.getConnection();
Statement s = c.createStatement();

after deploying this i got this error

javax.servlet.ServletException: javax.naming.NameNotFoundException: mydatabase not found

SO i have checked with driver file,context.xml file.
I saw this from http://wiki.metawerx.net/wiki/JNDIDBCPExampleForMySQL5.x

If you get a javax.naming.NameNotFoundException error, you have either not installed the context.xml file correctly, or have used a different name in the context.xml <Resource> element's "name" attribute to what you are using in your Context.lookup() call.

I think some more configuration is requird to use the context.xml file..

can anybody help me regarding this..


Thanks in advance..
zeet

[Campbell Ritchie]

Posted in wrong forum. Moving thread.

[Sagar Rohankar]

Please refer to this Tomcat docs:
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
and edit the web.xml as given there.

[Satchidananda Mohanty]

Thanks a lot Sagar,
I am going through that..

[David Newton]

It's certainly not a Struts question. Moving to Tomcat for now.