Geoffrey Jost wrote:
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.
That configuration looks fine. Can you try adding the following to your
getPool():
if (pool == null) {
System.out.println("CLASS-LOADER: " +
Thread.currentThread().getContextClassLoader());
...
Also, you may want to increase the logging level:
<log name="" level="finer" path="log/debug.log"/>
I'm guessing either the <database> isn't getting configured properly
(which would be strange, and likely a Resin bug and should appear in the
log), or somehow Cocoon is changing the ContextClassLoader, which may
make the <database> not visible (which would be shown by the
CLASS-LOADER println()).
-- Scott
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!!
