JNDI exception when creating dataSource

[Anadi Misra]

Hi,

I have configured the following context tag for using a dataSource over JNDI,
this is added within the Host Tag in server.xml

<Context path="/webmeet" docBase="webmeet">
<Resource name="jdbc/webmeet" scope="Shareable" type="com.mchange.v2.c3p0.PooledDataSource" 
maxActive="25" maxIdle="10" maxWait="3000" username="appuser" password="password"
            driverClassName="oracle.jdbc.Oracle.Driver"
            url="jdbc  :-o	  racle:thin:@dev01:1521:XE"
            defaultAutoCommit="false"
            validationQuery="SELECT 1 FROM DUAL"
            testOnBorrow="true"
            testWhileIdle="true"
            timeBetweenEvictionRunsMillis="300000" />
<Environment name="propertyhost" type="java.lang.String" value="localhost:22081/" allowOverride="false"/>
</Context>

And in my web application I add the following defintion

 
    <resource-ref>
    <res-ref-name>jdbc/webmeet</res-ref-name>
    <res-type>com.mchange.v2.c3p0.PooledDataSource</res-type>
    <res-auth>Container</res-auth>
    </resource-ref>

However initialization still fails and I get the Error

Caused by: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context

the enite trace is as follows

  
 
SEVERE: StandardWrapper.Throwable
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'wmDataSource': Invocation of init method failed; nested exception is javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1336)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:471)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:220)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
at org.springframework.web.context.ContextLoaderServlet.init(ContextLoaderServlet.java:81)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4364)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:132)
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:88)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:130)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:155)
at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:104)
at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105)
at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:193)
at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:179)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1367)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1333)
... 33 more

Sorry I forgot to add, its a spring web app, and I have the following addedthe applicationContext.xml

   
 
<jee:jndi-lookup id="wmDataSource" jndi-name="jdbc/webmeet" />
 

I am using Spring 2.5.4. Please help
[ July 31, 2008: Message edited by: Anadi Mishra ]

[Jetendra Ivaturi]

@PersistenceContext(unitName="datasourcename") private EntityManager manager;

Have you done this.

[Anadi Misra]

Hi,

Not sure what you meant but I am not using an Entity Manager, I am using the HibernateTransactionManager in the application. The application runs on Tomcat 5.5.28.

The application persists POJOs which hold User, and Event information

  
 
<!-- <bean id="wmDataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:/comp/env/jdbc/webmeet">
</property>
 
</bean> -->

<jee:jndi-lookup id="wmDataSource" jndi-name="jdbc/webmeet" />

<bean id="wmSessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
scope="singleton">
<property name="dataSource" ref="wmDataSource" />
 
<property name="mappingResources">
<list>
<value>com/cybercom/webmeet/domain/Event.hbm.xml</value>
 
<value>com/cybercom/webmeet/domain/User.hbm.xml</value>
 
<!--             
<value>com/cybercom/webmeet/domain/Participant.hbm.xml</value>

<value>com/cybercom/webmeet/domain/Role.hbm.xml</value>

<value>com/cybercom/webmeet/domain/UserToRole.hbm.xml</value>
-->
</list>
</property>
 
<property name="hibernateProperties">
<props>
                                <prop key="hibernate.show_sql">true</prop>
 
<prop key="hibernate.dialect">
org.hibernate.dialect.Oracle10gDialect
</prop>
 
</props>
</property>
</bean>
 
<bean id="wmTXManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="wmSessionFactory" />
</bean>
 

As you can see i was earlier using the JndiObjectFacotryBean but then i used to get

  org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'wmDataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is javax.naming.NamingException: Cannot create resource instance  

[Jetendra Ivaturi]

Oh ok. I think am wrong. Not sure.

[Alaa Nassef]

Caused by: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context

Your JNDI name is "jdbc/webmeet" but "jdbc" is not bound to your context

[Anadi Misra]

Hi,

Any specific way or configuration that i have to do to bind this 'jdbc' name? I have provided a Context definition and a resource ref definition in the web.xml. The reason for asking is that even if i use a name like wmAppDS i get the sane exception with wmAppDS replacing jdbc.

More I some how see that tomcats pooling restricts you to using javax.sql.DataSource only. For example if i use something like these

 
 
<Context path="/webmeet" docBase="webmeet">
<Resource name="jdbc/webmeet" scope="Shareable" 
type="com.mchange.v2.c3p0.PooledDataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
maxActive="25" maxIdle="10" maxWait="3000" username="appuser" password="password"
            driverClassName="oracle.jdbc.OracleDriver"
            url="jdbc :-o	 racle:thin:@192.168.18.137:1521:XE"
            defaultAutoCommit="false"
            validationQuery="SELECT 1 FROM DUAL"
            testOnBorrow="true"
            testWhileIdle="true"
            timeBetweenEvictionRunsMillis="300000" />
<Environment name="propertyhost" type="java.lang.String" value="localhost:22081/" allowOverride="false"/>
</Context>
 

and the web xml res-type tag to

<res-type>com.mchange.v2.c3p0.PooledDataSource</res-type>

or even

<res-type>javax.sql.DataSource</res-type>

It still fails. It only works if i keep res-type in the web.xml and the type attribute or resource tag in server.xml to javax.sql.DataSource, but then the logs show that C3P0 is not being used.

ID 31 Jul 2008 17:08:23 INFO [HibernateTransactionManager] - Using DataSource [org.apache.tomcat.dbcp.dbcp.BasicDataSource@1dc64a 5] of Hibernate SessionFactory for HibernateTransactionManager