problems getting DataSource from JNDI

i can get Resin to make individual connections to MySQL, but i can't get 
a DataSource from JNDI..  anybody seen this before?
Thanks in advance for your help.

This code works fine:

   try {
       Class.forName("com.mysql.jdbc.Driver").newInstance();
       Connection conn = 
DriverManager.getConnection("jdbc:mysql://127.0.0.1/janmdb?user=resin");
       ResultSet rs = Tools.executeQuery("SELECT * FROM staff;", conn);
       while (rs.next()) {
           // do stuff
       }
       conn.close();
   }
   catch (Exception ex) {
       log("testing MySQL Connector/J: ERR"+ex.toString());
   }

But this code doesnt work.  It always ends in a 
javax.naming.NameNotFoundException.

  private static DataSource pool = null;
  public static DataSource getPool() {
      if (pool == null) {
          try {
              Context env = (Context) new 
InitialContext().lookup("java:comp/env");
              pool = (DataSource) env.lookup("jdbc/janmdb");   // 
--ERROR ON THIS LINE--
          }
          catch (Exception e) {
              Tools.err(e, 
"DirectoryManager.getPool("+DATASOURCE_NAME+")");
          }
      }
      return pool;
  }

The relevant parts of resin.conf are:

  <host id=''>
    <web-app id='/' document-directory='/usr/local/cocoon/build/webapp'>
      <database>
        <jndi-name>jdbc/janmdb</jndi-name>
        <driver 
type="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
          <url>jdbc:mysql://localhost:3306/janmdb</url>
          <user>resin</user>
          <!--<password>resin</password>-->
        </driver>
      </database>
    </web-app>
  </host>



- Setup is as follows:
  - Red Hat Linux 9.0
  - MySQL 3.2.58 (binary install)
  - MySQL Connector/J (mysql-connector-java-3.0.11-stable-bin.jar)
  - Resin 3.0.3
  - Cocoon 2.1.2

- The resin directory and its contents are owned by the user 'resin'.
- The cocoon webapp directory and its contents are owned by the user 
'resin'.
- The MySQL database 'janmdb' exists and has tables with records in them.
- MySQL user records have been created for resin@localhost, 
resin@xxxxxxxxx, and resin@[dev mechine's IP addr], and access has been 
granted to the database 'janmdb'.  Password is not used (though i tried 
this and couldnt get it to work).
- It is possible to log in to the MySQL database from the command line 
as the user 'resin' (not using password).  All tables and sample data 
are visible.
  $ whoami
  resin
  $ mysql -u resin --host 127.0.0.1 janmdb
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 78 to server version: 4.0.18-standard-log
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  mysql>

- It is possible to see all the tables and data in MySQL Command Center 
(logged in across the network as mysql root).
- MySQL Connector/J jarfile (mysql-connector-java-3.0.11-stable-bin.jar) 
is installed in resin/lib.


- Resin is started as the user 'resin'.
  [root@redhatdev root]# su resin
  bash-2.05b$ /usr/local/resin/bin/httpd.sh start &
  [1] 17222
  bash-2.05b$ Resin httpd start at Tue Mar  2 10:58:45 PST 2004

- Resin and MySQL are both running.

$ ps -ef | grep resin
root     16608 16101  0 10:02 pts/3    00:00:00 su resin
resin    16609 16608  0 10:02 pts/3    00:00:00 bash
resin    16838     1  0 10:11 pts/3    00:00:00 perl bin/wrapper.pl 
-chdir -name httpd -class com.caucho.server.resin.Resin start
resin    16840 16838  0 10:11 pts/3    00:00:00 sh -c 
/usr/local/j2sdk/bin/java   -Dresin.home=/usr/local/resin 
-Djava.util.logging.manager=com.caucho.log.LogManagerImpl 
com.caucho.server.resin.Resin -socketwait 39239   -stdout 
/usr/local/resin/log/stdout.log -stderr /usr/local/resin/log/stderr.log 
1>> /usr/local/resin
resin    16841 16840  1 10:11 pts/3    00:00:10 
/usr/local/j2sdk/bin/java -Dresin.home=/usr/local/resin 
-Djava.util.logging.manager=com.caucho.log.LogManagerImpl 
com.caucho.server.resin.Resin -socketwait 39239 -stdout 
/usr/local/resin/log/stdout.log -stderr /usr/local/resin/log/stderr.log
jefurii  16884 16019  0 10:26 pts/5    00:00:00 grep resin
$ ps -ef | grep mysql
mysql    26263     1  0 Feb27 ?        00:00:00 /bin/sh 
/usr/local/mysql/bin/mysqld_safe --user=mysql
mysql    26284 26263  0 Feb27 ?        00:00:50 
/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql 
--datadir=/usr/local/mysql/data 
--pid-file=/usr/local/mysql/data/redhatdev.pid --skip-locking 
--port=3306 --socket=/tmp/mysql.sock
jefurii  16886 16019  0 10:27 pts/5    00:00:00 grep mysql



- Here's the output of stdout.log and stderr.log:

Resin 3.0.3 (built Mon Sep 22 15:54:15 PDT 2003)
Copyright(c) 1998-2003 Caucho Technology.  All rights reserved.

Starting Resin on Mon, 08 Mar 2004 13:45:16 -0800 (PST)
[13:45:17.521] Loaded Socket JNI library.
[13:45:17.522] http listening to *:8080
[13:45:17.522] ServletServer[] starting
[13:45:17.740] hmux listening to redhatdev:6802
[13:45:17.962] Host[] starting
[13:45:18.338] Application[http://localhost:8080/resin-doc] starting
[13:45:18.511] In-place class reloading is not available.  In-place 
class reloading during development requires -Xdebug.
server.properties not found, using command line or default properties
Opening database: /usr/local/cocoon-2.1.2/build/webapp/WEB-INF/db/cocoondb
HSQLDB server 1.7.1 is running
Use SHUTDOWN to close normally. Use [Ctrl]+[C] to abort abruptly
Mon Mar 08 13:45:23 PST 2004 Listening for connections ...
INFO [main] (DirectSchedulerFactory.java:295) - Quartz scheduler 'Cocoon
INFO [main] (DirectSchedulerFactory.java:298) - Quartz scheduler 
version: 1.2.3
INFO [main] (QuartzScheduler.java:327) - Scheduler 
Cocoon_$_Mon_Mar_08_13:45:23_PST_2004 started.

==> resin/log/stderr.log <==
Tools.getPool(jdbc/janmdb)
javax.naming.NameNotFoundException: java:comp/env/jdbc/janmdb
       at com.caucho.naming.ContextImpl.lookupImpl(ContextImpl.java:214)
       at com.caucho.naming.ContextImpl.lookup(ContextImpl.java:172)
       at org.janm.tools.Tools.getPool(Tools.java:56)
       at nlp.DirectoryManager.getPool(DirectoryManager.java:39)
       at nlp.DirectoryManager.getKeyValues(DirectoryManager.java:149)
       at nlp.DirectoryManager.getSubjects(DirectoryManager.java:76)
       at 
org.apache.cocoon.www.mount.discover_nikkei_org.xsp.directory.index_xsp.generate(org.apache.cocoon.www.mount.discover_nikkei_org.xsp.directory.index_xsp:283)
       at 
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:260)
       at 
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:548)
       at 
org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:196)
       at 
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:492)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:147)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:164)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:163)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:161)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:351)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:304)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:130)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:164)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:163)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:161)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:351)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:304)
       at org.apache.cocoon.Cocoon.process(Cocoon.java:640)
       at 
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
       at 
org.apache.cocoon.servlet.ParanoidCocoonServlet.service(ParanoidCocoonServlet.java:267)
       at 
com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:105)
       at 
com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:211)
       at 
com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:165)
       at 
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
       at 
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:253)
       at com.caucho.server.port.WorkerThread.run(WorkerThread.java:129)
       at java.lang.Thread.run(Thread.java:536)
DirectoryManager.getKeyValues():1
java.lang.NullPointerException
       at nlp.DirectoryManager.getKeyValues(DirectoryManager.java:169)
       at nlp.DirectoryManager.getSubjects(DirectoryManager.java:76)
       at 
org.apache.cocoon.www.mount.discover_nikkei_org.xsp.directory.index_xsp.generate(org.apache.cocoon.www.mount.discover_nikkei_org.xsp.directory.index_xsp:283)
       at 
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:260)
       at 
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:548)
       at 
org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:196)
       at 
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:492)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:147)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:164)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:163)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:161)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:351)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:304)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:130)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:164)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:163)
       at 
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
       at 
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:161)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:351)
       at 
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:304)
       at org.apache.cocoon.Cocoon.process(Cocoon.java:640)
       at 
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
       at 
org.apache.cocoon.servlet.ParanoidCocoonServlet.service(ParanoidCocoonServlet.java:267)
       at 
com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:105)
       at 
com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:211)
       at 
com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:165)
       at 
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
       at 
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:253)
       at com.caucho.server.port.WorkerThread.run(WorkerThread.java:129)
       at java.lang.Thread.run(Thread.java:536)

==> resin/log/stdout.log <==
Tools.getPool(jdbc/janmdb): getting pool
Tools.getPool(jdbc/janmdb): context env:[ContextImpl java:comp/env]





Many, many thanks for your help!!

--
Geoffrey Jost
MIS Supervisor, Japanese American National Museum
gjost@xxxxxxxx - 213-830-5654


--
Geoffrey Jost
MIS Supervisor, Japanese American National Museum
gjost@xxxxxxxx - 213-830-5654