Exception while EJB deployement

[Nabha Panat]

Hi,
I am trying to deploy ejb on weblogic 6.0 server. I am getting following exception ... Pl. help me to understand the exception and solve the problem
The exception is :
weblogic.ejb20.cmp.rdbms.RDBMSException: JNDI lookup of JDBC datasource 'MyJDBC Data Source' failed : javax.naming.NameNotFoundException: Unable to resolve MyJDBC Data Source. Resolved: '' Unresolved:
'MyJDBC Data Source' ; remaining name ''
<<no stack trace available>>
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.setup(RDBMSPersistenceManager.java:71)
at weblogic.ejb20.internal.EntityEJBHome.setBeanInfo(EntityEJBHome.java:152)
at weblogic.ejb20.deployer.ClientDrivenBeanInfoImpl.deploy(ClientDrivenBeanInfoImpl.java:474)
at weblogic.ejb20.deployer.Deployer.deployDescriptor(Deployer.java:1105)
at weblogic.ejb20.deployer.Deployer.deploy(Deployer.java:908)
at weblogic.j2ee.EJBComponent.deploy(EJBComponent.java:31)
at weblogic.j2ee.Application.addComponent(Application.java:133)
at weblogic.j2ee.J2EEService.addDeployment(J2EEService.java:115)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:327)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:277)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:232)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:192)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:439)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:180)
at $Proxy29.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:2299)
at weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManager.java:240)
at weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:122)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:439)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:180)
at $Proxy23.start(Unknown Source)
at weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationManagerMBean_CachingStub.java:435)
at weblogic.management.Admin.startApplicationManager(Admin.java:1033)
at weblogic.management.Admin.finish(Admin.java:493)
at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:429)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:170)
at weblogic.Server.main(Server.java:35)
>
<Aug 10, 2001 4:24:20 PM GMT+05:30> <Error> <J2EE> <Error deploying application dtry: Could not deploy: 'dtry.jar'
Possible reasons include:
1. The bean or an interface class has been modified but
the deployment descriptor has not been updated
2. The database mappings in the deployment descriptor do not
match the database definition
3. The jar file is not a valid jar file
4. The jar file does not contain a valid bean>
Thanks,
Nabha

[George Brown]

It looks to me as though your JNDI reference to your JDBC DataSource is incorrectly mapped (or possibly not mapped at all), and consequently when your bean looks it up it can't find it.
I would re-check your JNDI datasource mappings if I was you.

[Nabha Panat]

Dear George,
Will you please explain me where excatly I should look for the mapping. I am new to EJBs and Weblogic 6.0 and today bit confused. Will you help me ?
Thanks,
Nabha

[Rahul Mahindrakar]

It looks as if you are writing a entity bean. You need to specify the pool in the weblogic-ejb-jar.xml file. Check up if the pool is specified along with the table. You may have forgotten to specify this pool or have specified it wrongly.
------------------

Mahindrakar
IBM Application Server Forum Moderator
Consultant - Zensar Technologies.
SCJP2, SCJD2 & SCJEA (Part I)

[This message has been edited by Rahul Mahindrakar (edited September 04, 2001).]

[This message has been edited by Rahul Mahindrakar (edited September 04, 2001).]

[Rahul Mahindrakar]

I have written a servlet that access data from the connection pool. Check up the servlet code below. You will need a table called "test" for this to work

package rahul; 
import java.io.*;
import javax.sql.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.*; 
public class DataSourceServlet extends HttpServlet{ 
  java.sql.Connection con; 
  PrintWriter out; 
public DataSourceServlet() {
  super();
} 
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
  response.setHeader("Cache-Control", "No-Cache");
  response.setContentType("text/html");
  out = response.getWriter();
  out.print("Hellow"); 
  try{
    out.println("inside init"); 
    javax.sql.DataSource ds1;
    java.sql.Connection con1;
    java.sql.Statement stmt1; 
    InitialContext initCtx = new InitialContext();
    out.print("after initial context");
    out.println("<br>");
    out.println("Hi before generating exception1");
    out.println("<br>");
    System.out.println("hi1");
    
//ds1 = (javax.sql.DataSource)initCtx.lookup("oracle");
    //ds1 = (javax.sql.DataSource)initCtx.lookup("java:comp/env/jdbc/oracle1");
ds1 = (javax.sql.DataSource)initCtx.lookup("oracle1");

out.print("after Datasource");
    out.println("<br>");
    con1 = ds1.getConnection(); 
    //con1 = ds1.getConnection("gbhavani","freedomhappy");
    out.print("after connection");
    stmt1 = con1.createStatement();
    java.sql.ResultSet rs =stmt1.executeQuery("select * from test");
    while(rs.next()){
      out.print(rs.getString("NAME"));
      out.print(rs.getInt("ID"));
      out.print("");
    }
    out.println("<BR></br><br></br> over");
    stmt1.close();
    con1.close(); 
}
catch(Exception e)
{
out.println("exception in init" +e);
} 
 
}
/**
* Insert the method's description here.
* Creation date: (9/22/00 10:17:16 AM)
*/
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
doGet(request, response);
} 
public void init(javax.servlet.ServletConfig config) throws javax.servlet.ServletException {
super.init(config); 
} 
}

[Rahul Mahindrakar]

My DataSource JNDI name is oracle1 and looks like yours is 'MyJDBC Data Source'.
check up if
1) spaces are allowed in the pool as your name has spaces
2) click on the Targets tab and see if the pool is "choosen" same is the case for the DataSource
------------------

Mahindrakar
IBM Application Server Forum Moderator
Consultant - Zensar Technologies.
SCJP2, SCJD2 & SCJEA (Part I)

[This message has been edited by Rahul Mahindrakar (edited September 04, 2001).]

[Nabha Panat]

Dear Rahul and Gorge,
Thank you both. The above exception was misleading ...
It was about the entry of data-source-name in weblogic-cmp-rdbms-jar.xml and the URL for the oracle driver.
The correct entry is: <data-source-name>nabha</data-source-name>
I have created the data-source using admin console in which mentioned the connection pool name and jndi name. It is as follows:
<JDBCDataSource JNDIName="nabha" Name="nabha" PoolName="MyPool" Targets="myserver"/>
Then I have created connection pool using admin console:
<JDBCConnectionPool CapacityIncrement="1" DeploymentOrder="1000"
DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="0"
JDBCXADebugLevel="0" LoginDelaySeconds="0" MaxCapacity="5"
Name="MyPool" Properties="password=pwd;username=unm"
RefreshMinutes="0" ShrinkPeriodMinutes="15"
ShrinkingEnabled="true" SupportsLocalTransaction="false"
Targets="myserver" TestConnectionsOnRelease="false"
TestConnectionsOnReserve="false" URL="jdbc racle:thin:username/password@host ort:sid"/>
The bean is deployed.
Nabha

[Rahul Mahindrakar]

Things work and thats great