Errored while looking up datasource: PWC4216: Name jdbc is not bound in this Context

[nikil shar]

hi all,
am trying to deploy my web application (.war which has a servlet which connects to a db and fetches records and displays in jsp) file in SunOne web server V7 but i cant get past this error :


[29/Jun/2010:15:14:46] failure (24218): for host 146.171.59.144 trying to POST /BbaMigrationQueryTool/BBAMigrationQuery, service-j2ee reports: NamingExcep
tion caught: Errored while looking up datasource: PWC4216: Name myDB is not bound in this Context

my java code to lookup the jndi name :

    //looks up a datasource
    private static synchronized DataSource getDataSource(String jndiName) throws NamingException {

        DataSource dataSource = null;

        try {
            Context c = new InitialContext();
             Context envContext = (Context) c.lookup("java:comp/env");
            Logger.getLogger(DBUtilities.class.getName()).log(Level.INFO, "Found sub context");
              dataSource = (DataSource) envContext.lookup(jndiName);

        } catch (NamingException e) {
            e.printStackTrace();
            throw new NamingException("Errored while looking up datasource: " + e.getMessage());
        }

        return dataSource;
    }

i call the above method with "jdbc/myDB" and have created a JDBC recourse within the SunOne web server via the admin console.

my web.xml i have an entry for the resource as follows :

            <resource-ref>
        <res-ref-name>jdbc/myDB</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
        <res-sharing-scope>Shareable</res-sharing-scope>
    </resource-ref>

in my sun-web.xml i have an entry as follows :

    <resource-ref>
        <res-ref-name>jdbc/myDB</res-ref-name>
        <jndi-name>jdbc/myDB</jndi-name>
    </resource-ref>

server.xml has this entry in it :

  <jdbc-resource>
    <jndi-name>jdbc/myDB</jndi-name>
    <datasource-class>oracle.jdbc.pool.OracleDataSource</datasource-class>
    <property>
      <name>password</name>
      <value>76765</value>
    </property>
    <property>
      <name>user</name>
      <value>56756</value>
    </property>
    <property>
      <name>url</name>
      <value>jdbc:oracle:thin:@serveretc etc</value>
    </property>
    <description/>
  </jdbc-resource>

what could be wrong ??

thanks in advance.