Weblogic JNDI

[Yoo-Jin Lee]

Hi,

I'm trying to setup a JNDI datasource in Spring's applicationContext.xml file but I get the following error:

 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in file [C:\Source_Control\UI Technical\default\3evolve\pfs\tomcat\pfs\WEB-INF\classes\applicationContext-hibernate.xml]: Initialization of bean failed; nested exception is javax.naming.NameNotFoundException: Unable to resolve 'mysql' Resolved: '' Unresolved:'mysql' 
javax.naming.NameNotFoundException: Unable to resolve 'mysql' Resolved: '' Unresolved:'mysql' ; remaining name 'mysql'
at weblogic.rjvm.BasicOutboundRequest.sendReceive(BasicOutboundRequest.java:108)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:247)
at weblogic.jndi.internal.ServerNamingNode_814_WLStub.lookup(Unknown Source)
at weblogic.jndi.internal.WLContextImpl.lookup(WLContextImpl.java:371)
at weblogic.jndi.internal.WLContextImpl.lookup(WLContextImpl.java:359)
at javax.naming.InitialContext.lookup(InitialContext.java:347)
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:123)
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:85)
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:121)
at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:71)
at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:85)
at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:124)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:937)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:146)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:271)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:310)
at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:82)
at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:67)
at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:58)
at au.com.hutchison.evolve.common.service.SpringServiceRegistry.init(SpringServiceRegistry.java:36)
at au.com.hutchison.evolve.common.service.SpringServiceRegistry.getPFSMarketService(SpringServiceRegistry.java:46)
at au.com.hutchison.evolve.pfs.control.PFSBaseAction.<init>(PFSBaseAction.java:35)
at au.com.hutchison.evolve.pfs.control.PFSActionGetIndices.<init>(PFSActionGetIndices.java:22)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at org.apache.struts.action.ActionServlet.processActionCreate(ActionServlet.java:1632)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1577)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6718)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
 

I'm using Spring 1.2, Hibernate 3, MySql, and Weblogic 8.1.

My applicationContext.xml file:

  
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
 
<beans>
 
    <!-- ========================= RESOURCE DEFINITIONS ========================= -->
    <!-- JNDI Environment Template -->
    <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName">
            <value>mysql</value>
        </property>
        <property name="resourceRef">
            <value>false</value>
        </property>
    </bean>
 
    <!-- Hibernate SessionFactory -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref local="dataSource"/>
        </property>
        <property name="mappingResources">
            <list>
                <value>test/MarketStock.hbm.xml</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="java.naming.factory.initial">weblogic.jndi.WLInitialContextFactory</prop>
                <prop key="java.naming.provider.url">t3://localhost:7001</prop>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
            </props>
        </property>
    </bean>
 
    <!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
 
    <!-- Transaction manager that delegates to JTA (for a transactional JNDI DataSource) -->
    <!--
    <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"/>
    -->
 

    <!-- ========================= BUSINESS OBJECT DEFINITIONS ========================= -->
    <!--
        - Defines specific transaction attributes with "readOnly" markers,
        - which is an optimization that is particularly valuable with Hibernate
        - (to suppress unnecessary flush attempts for read-only operations).
    -->
    <bean id="pfsMarketService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="transactionManager">
            <ref local="transactionManager"/>
        </property>
        <property name="target">
            <ref local="pfsMarketServiceTarget"/>
        </property>
        <property name="transactionAttributes">
            <props>
                <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="load*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="store*">PROPAGATION_REQUIRED</prop>
            </props>
        </property>
    </bean>
 

    <bean id="pfsMarketServiceTarget" class="test.PFSMarketServiceSpringImpl">
        <property name="mktDao">
            <ref local="mktDao"/>
        </property>
    </bean>
 
    <bean id="mktDao" class="test.HibernateMarketDAOImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
 
</beans>
 

I know the JNDI name is valid because I can get a connection in a main code.

 
        Context ctx = null;
        Hashtable ht = new Hashtable();
        ht.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
        ht.put(Context.PROVIDER_URL, "t3://localhost:7001");
        ctx = new InitialContext(ht);
        javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("mysql");
        System.out.println("node"); 

Any ideas?

thanks in advance.

Yoo-Jin

[J Weite]

I had two issues when trying to do the same. The first was the provider complaining that I didn't have a usable context. I fixed this by explicitly creating a JndiTemplate and configuring it with the usual JNDI context stuff. (Maybe because I'm running Weblogic at port 7011???)

At this point, I started getting the same error you did. On a long shot, I dropped the resource-ref param so that JndiObjectFactoryBean wouldn't supplement my jndiName with "java:comp/env/", since I don't supply this myself when manually getting a datasource. It worked. In the end, my key beans looks like this:

  
<bean id="myJNDITemplate" class="org.springframework.jndi.JndiTemplate">
<property name="environment">
<props>
<prop key="java.naming.factory.initial">weblogic.jndi.WLInitialContextFactory</prop>
<prop key="java.naming.provider.url">t3://localhost:7011</prop>
</props>
</property>
</bean>
 
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiTemplate"><ref bean="myJNDITemplate"/></property>
<property name="jndiName"><value>jdbc/r2mdRegistry</value></property>
<!--
    <property name="resourceRef"><value>true</value></property>
-->    
</bean>
 

 

Maybe it'll work for you too...