Getting Error in WAS5.1

[Bikash Paul]

We have very old application running on WAS5.1. We used to use properties file to get the DB connection information. Due to some issues now we are trying to use DataSource of WAS.

Accordingly we modified our code to get the DB connection through DataSource. We have used resource-ref to avoid WAS default warning.

Here is the code snippet:

Connection class:

public Connection getConnection() throws SQLException
    {
        InitialContext ic;
        Connection connection = null;
		try {
			ic = new InitialContext();
	        DataSource managedDS =
	            (DataSource) ic.lookup("java:comp/env/jdbc/AIPOnlineDB");
	        connection = managedDS.getConnection();
		} catch (NamingException e) {
			log(e);
		}

		return connection;

    }

web.xml file

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE web-app PUBLIC '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN' 'http://java.sun.com/dtd/web-app_2_3.dtd'>

<!-- retail.com private exchange deployment -->

<web-app>
    <display-name>AIPOnlineWAR</display-name>

    <!-- setup blank page -->

    <context-param>
      <param-name>blankpage</param-name>
      <param-value>/setup/blankpage.jsp</param-value>
    </context-param>

    <!-- main servlet -->

    <servlet>
    
        <servlet-name>rfpservlet</servlet-name>
        <servlet-class>com.workspace.servlet.CgiWsp</servlet-class>

	<!-- The main properties filename is stored in a file in the WEB-INF hierarchy -->

        <init-param>
            <param-name>props</param-name>
            <param-value>/opt/rfp/properties/main.properties</param-value>
            <!-- <param-value>/u00/webaipga/aiponline.properties/properties/main.properties</param-value> -->
        </init-param>

        <init-param>
            <param-name>title</param-name>
            <param-value>Retek Advanced Inventory Planning</param-value>
        </init-param>

	<load-on-startup></load-on-startup>

    </servlet>

    <!-- servlet mappings -->

    <servlet-mapping>
      <servlet-name>rfpservlet</servlet-name>
      <url-pattern>/servlet/rfpservlet/*</url-pattern>
    </servlet-mapping>

    <!-- mime settings: ensure PDF is recognized along with pdf -->

    <mime-mapping>
        <extension>pdf</extension>
        <mime-type>application/pdf</mime-type>
    </mime-mapping>

    <mime-mapping>
        <extension>PDF</extension>
        <mime-type>application/pdf</mime-type>
    </mime-mapping>

    <!-- Ensure index.jsp is recognized as welcome file; include HTML forms for helps -->

    <welcome-file-list>
      <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>

    <!-- retailserver taglib -->

    <taglib>
      <taglib-uri>/taglibs/rcapps.tld</taglib-uri>
      <taglib-location>/WEB-INF/tld/rcapps.tld</taglib-location>
    </taglib>

    <ejb-local-ref>
      <ejb-ref-name>ejb/OrderSender</ejb-ref-name>
      <ejb-ref-type>Session</ejb-ref-type>
      <local-home>com.retek.aip.aiprib.interfaces.OrderSenderLocalHome</local-home>
      <local>com.retek.aip.aiprib.interfaces.OrderSenderLocal</local>
      <ejb-link>OrderSenderEJB.jar#OrderSender</ejb-link>
    </ejb-local-ref>
    
	<!-- resource reference for DataSource -->

    <resource-ref>
   	<description>AIP Online Database</description>
   	<res-ref-name>jdbc/AIPOnlineDB</res-ref-name>
   	<res-type>javax.sql.DataSource</res-type>
   	<res-auth>CONTAINER</res-auth>
    </resource-ref> 
</web-app>

But during running the application we are getting below error:

[1/13/12 16:26:59:545 CST] 214aa0e8 SessionContex E SESN0043E: BackedHashtable: problem obtaining the configured datasource. Ensure that you have properly co
nfigured a datasource. When Session Manager persistence is enabled the Session Manager configuration must contain a valid datasource.
[1/13/12 16:26:59:593 CST] 214aa0e8 SessionContex E Exception is: javax.naming.NameNotFoundException: Context: mspdev23aipdev112a/nodes/mspdev23aipdev112a/se
rvers/server1, name: jdbc/Sessions: First component in name Sessions not found. Root exception is org.omg.CosNaming.NamingContextPackage.NotFound: IDL:omg.o
rg/CosNaming/NamingContext/NotFound:1.0

We couldn't understand why WAS is looking for "jdbc/Sessions"

[Murali Ranga]

1.you have to create datasource from websphere administrative console.I don't know whether WAS5.1 has option to create JNDI from administrative console.
2.Why did you keep ejb code in web.xml for web container ? move the code to ejb-jar.xml

[Bikash Paul]

Hi,

WAS5.1 has option to create JNDI. As I have mentioned earlier that it's a pretty old application and and it's working fine with ejb references in the web.xml file.

And it is also working fine with below connection class:

public Connection getConnection() throws SQLException  
    {  
        InitialContext ic;  
        Connection connection = null;  
        try {  
            ic = new InitialContext();  
            DataSource managedDS =  
                (DataSource) ic.lookup("jdbc/AIPOnlineDB");  
            connection = managedDS.getConnection();  
        } catch (NamingException e) {  
            log(e);  
        }  
  
        return connection;  
  
    }

But the problem is WAS throwing default warning message in the log file due to absence of resource-ref.

 48e34e90 ConnectionFac I J2CA0122I: Resource reference jdbc/AIPOnlineDB could not be located, so default values of the following are used: [Resource-ref settings]

        res-auth:                 1 (APPLICATION)
        res-isolation-level:      0 (TRANSACTION_NONE)
        res-sharing-scope:        true (SHAREABLE)
        res-resolution-control:   999 (undefined)

So to avoid that warning message we introduced resource-ref and after we started getting below exception in the log file.

[1/13/12 16:26:59:545 CST] 214aa0e8 SessionContex E SESN0043E: BackedHashtable: problem obtaining the configured datasource. Ensure that you have properly co
nfigured a datasource. When Session Manager persistence is enabled the Session Manager configuration must contain a valid datasource.
[1/13/12 16:26:59:593 CST] 214aa0e8 SessionContex E Exception is: javax.naming.NameNotFoundException: Context: mspdev23aipdev112a/nodes/mspdev23aipdev112a/se
rvers/server1, name: jdbc/Sessions: First component in name Sessions not found. Root exception is org.omg.CosNaming.NamingContextPackage.NotFound: IDLmg.o
rg/CosNaming/NamingContext/NotFound:1.0 

Could you please give us some clue why WAS is looking for 'jdbc/sessions'.

[Bikash Paul]

Hi,

Can anyone please give some clue on this issue.

Thanks,
-Bikash