please check my code

[jyothi mahadevan]

hi all,
my jsp displays an empty vector when i execute it.

package examples.ejb.basic.beanManaged;
import java.rmi.RemoteException;
import javax.ejb.EJBObject;
import java.util.Enumeration;
public interface TempAccount extends EJBObject
{
public Enumeration getResult() throws RemoteException;
}

package examples.ejb.basic.beanManaged;
import javax.ejb.CreateException;
import javax.ejb.EJBHome;
import javax.ejb.FinderException;
import java.rmi.RemoteException;
import java.util.Enumeration;
public interface TempAccountHome extends EJBHome
{
public TempAccount create()    throws CreateException, RemoteException;
public TempAccount findByPrimaryKey(String primaryKey)  throws FinderException, RemoteException;
public Enumeration findData(String description,String language) throws FinderException,RemoteException;
}

package examples.ejb.basic.beanManaged;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import java.util.Enumeration;
import java.util.Vector;
import java.sql.*;
import java.util.Date;
import javax.ejb.CreateException;
import javax.ejb.DuplicateKeyException;
import javax.ejb.EJBException;
import javax.ejb.EntityBean;
import javax.ejb.EntityContext;
import javax.ejb.FinderException;
import javax.ejb.NoSuchEntityException;
import javax.ejb.ObjectNotFoundException;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class TempAccountBean implements EntityBean
{
Vector v=new Vector();
String value=" " ;
private EntityContext ctx;
public void setEntityContext(EntityContext ctx) {   this.ctx = ctx; }
public void unsetEntityContext() { this.ctx = null; }
public void ejbActivate() {  }
public void ejbPassivate() {  }
public void ejbLoad() { }
public void ejbStore() { }
public String ejbCreate()  throws CreateException { return null;  }
public void ejbPostCreate() {  }
public void ejbRemove() {  }
public String ejbFindByPrimaryKey(String pk)    throws ObjectNotFoundException
{
return pk;
}

public Enumeration ejbFindData(String description,String language)
{
    Connection con = null;
    Statement stmt =null;
    try {
             con = getConnection();
             String query=null;
             query="SELECT t.Benennung AS description, u.UnitName, "+
                   " u.CreateDate , u.ChangeDate, + u.ReleaseDate, "+
                   " u.Version, o.Name AS owner, s.Name AS State, p.Extension AS Format, '"+
                   "\\"+"\\"+ "hpeaso67'+a.ArchivePath+'/'+a.ArchiveFile+p.Extension AS path"  +
                   " FROM V_Units u, RSLang2HDMLang l, TedrisBenennung t, U_User o, RS_StateNames s, "+
                   " Pub_Format2Extension p, RS_Archive a WHERE t.Benennung LIKE INSENSITIVE "+ "'"+
                     description + "%'" +
                   " AND t.SprachCode = "+"'"+language+"'"+
                   " AND u.UnitID = t.UnitID"+
                   " AND l.SprachCode = t.SprachCode"+
                   " AND u.LangID = l.LangID"+
                   " AND o.UserID = u.OwnerID"+
                   " AND s.StateID = u.StateID"+
                   " AND s.LangID = l.LangID "+
                   " AND p.FormatID = u.OrgFormatID"+
                   " AND a.LangID=u.LangID"+
                   " AND a.UnitID = u.UnitID"+
                   " AND a.Version=u.Version order by UnitName";
System.out.println(query);
stmt = con.createStatement();
ResultSet rs= stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
while (rs.next())
 {
for(int i=1;i<=columnCount;++i)
    {
if ((rs.wasNull()))
{
value=value+"null";
}
      value = rs.getString(1) +  rs.getString(2) +  rs.getDate(3) +
        rs.getDate(4)   +  rs.getString(5) +  rs.getString(6) +
          rs.getString(7) +  rs.getString(8) +  rs.getString(9) +
          rs.getString(10);

System.out.println(value);
v.addElement(value);
}
}
return v.elements();
}
 catch (SQLException sqe)
 {
    throw new EJBException (sqe);
 }
}
public Enumeration getResult()
{
return v.elements();
}

private Connection getConnection() throws SQLException
{
    InitialContext initCtx = null;
    try {
      initCtx = new InitialContext();
      DataSource ds = (javax.sql.DataSource)
      initCtx.lookup("java:comp/env/jdbc/transPool");
      return ds.getConnection();
}
catch(NamingException ne) {  throw new EJBException(ne); }
finally
 {
  try
  {
       if(initCtx != null) initCtx.close();
   }
   catch(NamingException ne)
   {
     throw new EJBException(ne);
   }
    }
  }

/* public void setDescription(String description)
 {

 if(description == null | | description.equals(""))
 throw (new IllegalArgumentException("description cannot be null"));
 this.description = description;
 }
 public void setLanguage(String language)
 {
 if(language == null | | language.equals(""))
  throw (new IllegalArgumentException("language  cannot be null"));
  this.language = language;
 }*/
}

< !-- Copyright (c) 1999-2000 by BEA Systems, Inc. All Rights Reserved.-->
< !-- Here we use a Java string ("PAGETITLE") to set 
     the same phrase as the title and as a head.-->
< html>
< head>
< title>
JSP example using EJBean-managed persistence
< /title>
< /head>
< body bgcolor=gold>
< font face="Helvetica">
< !-- Using the "import" feature -->
<%@ page import="
    javax.naming.*,
    javax.ejb.*,
    java.rmi.RemoteException,
    java.rmi.Remote,
    java.util.*,
    examples.ejb.basic.beanManaged.* 
"%>
<%!
String url       = "t3://localhost:7001";
    // Declaring a Java class
  public Context getInitialContext() throws Exception 
  {
    Properties p = new Properties();
    p.put(Context.INITIAL_CONTEXT_FACTORY,
          "weblogic.jndi.WLInitialContextFactory");
    p.put(Context.PROVIDER_URL, url);
    return new InitialContext(p);
 }
  String getStackTraceAsString(Exception e)
  {
    // Dump the stack trace to a buffered stream, then send it's contents
    // to the JSPWriter. 
    ByteArrayOutputStream ostr = new ByteArrayOutputStream();
    e.printStackTrace(new PrintWriter(ostr));
    return(ostr.toString());
  }
%>

<%
  try 
  {
      Context ctx = getInitialContext();
       TempAccountHome home = (TempAccountHome) ctx.lookup("beanManaged.AccountHome");
       String description = "inking";
       String language = "EN";
%>
< table border=1>
<%
Enumeration e= home.findData(description,language);
if (e != null) 
{
  while (e.hasMoreElements()) 
  {   
            TempAccount ta = (TempAccount) e.nextElement();
%>
    < tr>
      < td> <%= ta.getResult() %> < /td>
    < /tr>      
<%
           }
         }
%>

< /table>
<% 
} 
 catch (Exception e) 
 {
    out.print("
:::::::::::::: Unexpected Error :::::::::::::::::");
    out.print("<pre>"+getStackTraceAsString(e)+"< /pre>");
  }
  finally 
  {
%>

Completed EJB operations at <%= new Date() %>

< hr width=80%>
<%
  }
%>


< font size=-1>
Copyright � 1999-2000 by BEA Systems, Inc. All Rights Reserved.
< /font>
< /font>
< /body>
< /html>

Added UBB CODE tags to aid readability

[This message has been edited by Frank Carver (edited May 09, 2001).]

[Paul Ralph]

Could you explain what the code was expected to do? Also, it might help to edit your post to place them within [ code] [/ code] marks so that the brackets line up in the proper spots and make it easier to read.
Note: make sure to take out the spaces before the word code to get it to work properly
Paul R

[Desai Sandeep]

Jyothi,
Any exceptions on the server/client side being thrown?If yes, could you post the stack trace?
At the outset, I can say since your BMP bean needs to do the following:

1. Implement the ejbLoad(),ejbStore() methods.
   
2. Define the instance variable in your Bean class, mapping it to the table you want to load as a Entity Bean.
   
3. Define getter/setter business methods in your RemoteObject interface.
   
4. Implement the getter/setter methods in the Bean class.
   
5. Since you have already defined the findData(String,String) returning an Enumeration Object,and also, from your JSP, I infer you want to obtain the RemoteObject, get the Primary Key and store it in the Vector and then return the Enumeration Object.
   
6. Further in your JSP, after obtaining the RemoteObject, use the getter methods to display the values in the form.
   

Note that..


<%= ta.getResult() %>


..returns an Enumeration.You would need to iterate through it!!
Hope this helps,
Sandeep



• Sun Certified Programmer for Java 2 Platform Scored 93 per cent
  
• Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java Scored 56 out of 59
  
• IBM Enterprise Connectivity with J2EE Scored 72 per cent
  
• Enterprise Development on the Oracle Internet Platform Scored 44 out of 56
  

[This message has been edited by Desai Sandeep (edited May 09, 2001).]