Return-Path: 
 <tomcat-user-return-39847-qmlist-jakarta-archive-tomcat-user=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 60554 invoked from network); 1 Nov 2002 15:15:18 -0000
Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131)
  by daedalus.apache.org with SMTP; 1 Nov 2002 15:15:18 -0000
Received: (qmail 14283 invoked by uid 97); 1 Nov 2002 15:15:44 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org
Received: (qmail 14234 invoked by uid 97); 1 Nov 2002 15:15:43 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 14211 invoked by uid 98); 1 Nov 2002 15:15:42 -0000
X-Antivirus: nagoya (v4218 created Aug 14 2002)
From: "Neil Aggarwal" <neil@JAMMConsulting.com>
To: "Tomcat-User" <tomcat-user@jakarta.apache.org>
Subject: Has anyone gotten Castor to work using JNDI?
Date: Fri, 1 Nov 2002 09:15:12 -0600
Message-ID: <ACEDKBKBMCFCDCBFOOEJGEMACBAA.neil@JAMMConsulting.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Importance: Normal
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hello:

Has anyone gotten Castor to work using JNDI and
the JBCP pooling mechanism?

My platform is Tomcat 4.0.6, Apache 2.0.43, and
MySQL 3.23.53a on RedHat Linux 8.0.

When I try to load the JDO object from the JNDI context,
here is the error I get:

javax.naming.NamingException: Cannot create resource instance
	at
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.
java:167)
	at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:311)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:834)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
	at org.apache.naming.SelectorContext.lookup(SelectorContext.java:183)
	at javax.naming.InitialContext.lookup(InitialContext.java:354)
	at top.Utils.getJDO(Utils.java:31)

Here is the code that I am using to get the JDO instance:
package top;
// imports
public class Utils {
  public static synchronized JDO getJDO() throws NamingException,
SQLException, MappingException {
    ClassLoader loader = Utils.class.getClassLoader();
    URL url = loader.getResource("database.xml");
    JDO.loadConfiguration(url.toString());
    InitialContext ctx = new InitialContext();
    return (JDO) ctx.lookup( "java:comp/env/jdo/videoSearchPPV" );
  }
}

Here is my web.xml:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
  <resource-ref>
    <description>Resource reference to DataSource</description>
    <res-ref-name>jdbc/videoSearchPPV</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>
  <resource-ref>
    <description>Resource reference to JDO</description>
    <res-ref-name>jdo/videoSearchPPV</res-ref-name>
    <res-type>org.exolab.castor.jdo.JDO</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>
</web-app>

Here is my database.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version
1.0//EN" "http://castor.exolab.org/jdo-conf.dtd">
<database name="videoSearchPPV" engine="mysql">
  <jndi name="java:comp/env/jdbc/videoSearchPPV" />
  <mapping href="mapping.xml"/>
</database>

Here is what I put in tomcat's server.xml:
  <Service name="Tomcat-Apache">
    <Connector ...>
    <Engine ...>
      <DefaultContext reloadable="true" >
        <Resource auth="Container" name="jdo/videoSearchPPV"
scope="Shareable" type="org.exolab.castor.jdo.JDO"/>
        <Resource auth="Container" name="jdbc/videoSearchPPV"
scope="Shareable" type="javax.sql.DataSource"/>
        <ResourceParams name="jdbc/videoSearchPPV">
          <parameter>
            <name>factory</name>
            <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
          </parameter>
          <parameter>
            <name>url</name>
            <value>jdbc:mysql://localhost:3306/videoSearchPPV</value>
          </parameter>
          <parameter>
            <name>password</name>
            <value>[The password to my database]</value>
          </parameter>
          <parameter>
            <name>maxWait</name>
            <value>100</value>
          </parameter>
          <parameter>
            <name>maxActive</name>
            <value>100</value>
          </parameter>
          <parameter>
            <name>driverClassName</name>
            <value>com.mysql.jdbc.Driver</value>
          </parameter>
          <parameter>
            <name>username</name>
            <value>videoSearchPPV</value>
          </parameter>
          <parameter>
            <name>maxIdle</name>
            <value>30000</value>
          </parameter>
        </ResourceParams>
      </DefaultContext>

Any ideas?

Thanks,
	Neil.

--
Neil Aggarwal
JAMM Consulting, Inc.    (972) 612-6056, http://www.JAMMConsulting.com
Custom Internet Development    Websites, Ecommerce, Java, databases


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>