Hi Mike,
Here are the code snipet from the ejb-jar.xml and the
finder method declaration.
Do u think the way the ejb-ql is written in the
ejb-jar.xml is wrong!!
I tried doing the
[CDATA[SELECT DISTINCT OBJECTS(a) FROM CriminalCMP AS
a WHERE a.lastName = ?1]]
ejb-ql,but that doesn't work.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
ejb-jar.xml
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
<query>
<query-method>
<method-name>findByLastName</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>
[CDATA[SELECT DISTINCT OBJECT(a) FROM CriminalCMP AS a
WHERE a.lastName = ?1]]
</ejb-ql>
</query>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
finder-method declaration
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
* @ejb.finder
* view-type = "both"
* description = "find the Criminals by
PrimaryKey"
* signature = "com.criminalsearch.CriminalRemote
findByPrimaryKey(Integer criminalPK)
* role-name = "Operator"
* query = "SELECT OBJECT(a) FROM
com.criminalsearch.Criminal AS a WHERE a.criminalPK =
?1"
* result-type-mapping = "Local"
* transaction-type = "Required"
* unchecked="true"
*
*
* @ejb.finder
* view-type = "both"
* description = "find the Criminals by LastName"
* signature = "java.util.Collection
findByLastName(java.lang.String lastName)
* role-name = "Operator"
* query = "SELECT DISTINCT OBJECT(a) FROM
Criminal AS a WHERE a.lastName = ?1"
* result-type-mapping = "Local"
* transaction-type = "Required"
* unchecked="true"
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
--- [EMAIL PROTECTED] wrote:
> I need to see the finder declaration in your XDoclet
> entity bean.
>
> It should look something like this:
> ===================================
>
> * @ejb.finder signature="java.util.Collection
> findAllSicCodes()"
> * query="SELECT DISTINCT OBJECT(c)
> FROM SicCode AS c"
> *
> * @ejb.finder signature="java.lang.String
> findSicCodeByBusinessTypeDescription(
> java.lang.String
> pBusinessTypeDescription )"
> * query="SELECT DISTINCT OBJECT(c) FROM
> SicCode AS c WHERE
> c.businessTypeDescription = ?1"
> *
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Behalf Of Natasha
> Varshney
> Sent: Wednesday, May 26, 2004 12:41 AM
> To: [EMAIL PROTECTED]
> Subject: [Xdoclet-user] finder method doesn't return
> anything from DB!!
>
>
> Thanks Mick,
>
> It did save me a lot of time.I have another issue.I
> have a bunch of finder methods(findByFirstName and
> findByLastName) in the Home Interface,but when I try
> to use these methods to get data 'already' present
> from Oracle DB,it doesn't get anything from the DB.
> But If I currently create a row and then do a
> findByFirstName ,it shows me the result.
> findByPrimaryKey works fine and it is able to
> retrive
> data successfully.
> Any clue what is going on here??
>
> Here is the snap code...
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Home Interface
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> public interface CriminalHome
> extends javax.ejb.EJBHome
> {
> public static final String
> COMP_NAME="java:comp/env/ejb/Criminal";
> public static final String
> JNDI_NAME="ejb/CriminalHome";
>
> public com.criminalsearch.CriminalRemote create()
> throws
> javax.ejb.CreateException,java.rmi.RemoteException;
>
> public com.criminalsearch.CriminalRemote
> create(java.lang.Integer criminalPk ,
> java.lang.String
> firstname , java.lang.String lastName)
> throws
> javax.ejb.CreateException,java.rmi.RemoteException;
>
> public com.criminalsearch.CriminalRemote
> findByPrimaryKey(java.lang.Integer criminalPK)
> throws
> javax.ejb.FinderException,java.rmi.RemoteException;
>
> public Collection
> findByLastName(java.lang.String
> lastName)
> throws
> javax.ejb.FinderException,java.rmi.RemoteException;
>
>
> public Collection
> findByFirstName(java.lang.String
> firstName)
> throws
> javax.ejb.FinderException,java.rmi.RemoteException;
>
>
> }
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Client
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> public class Client
> {
> public static void main(String[] args) throws
> Exception
> {
> CriminalHome home = null;
> CriminalRemote remote = null;
>
> try
> {
> Hashtable env = new Hashtable();
>
>
env.put(Context.INITIAL_CONTEXT_FACTORY,weblogic.jndi.WLInitialContextFactor
> y.class.getName());
> env.put(Context.PROVIDER_URL,
> "t3://localhost:7001");
> env.put(Context.SECURITY_PRINCIPAL,
> "weblogic");
> env.put(Context.SECURITY_CREDENTIALS,
> "weblogic");
> Context ctx = new InitialContext(env);
> home = (CriminalHome)
> PortableRemoteObject.narrow
>
> (ctx.lookup("ejb/CriminalHome"),CriminalHome.class);
>
>
> Integer a = new Integer(55555);
> Integer b = new Integer(66666);
> Integer c = new Integer(88888);
> Integer d = new Integer(99999);
> Integer e = new Integer(77777);
> home.create(a,"XXX","RRR");
> home.create(b,"YYY","WWW");
> home.create(c,"ZZZ","TTT");
> home.create(d,"EEE","UUU");
> home.create(e,"DDD","BBB");
>
> Collection c =
> home.findByFirstName("XXX");
> Iterator i = c.iterator();
> if(c.isEmpty())
> {
> System.out.println("No Collection
> with
> First Name Found!!");
> }
> while(i.hasNext())
> {
> CriminalRemote criminal =
> (CriminalRemote) PortableRemoteObject.narrow
>
> (i.next(),CriminalRemote.class);
> // String firstName =
> criminal.getPrimaryKey();
> String lastName =
> criminal.getLastName();
> Integer driver_id =
> criminal.getDriver_Id();
> Integer ssn = criminal.getSSN();
> Integer pass_num =
> criminal.getPassport_Num();
> Integer over_all_rating =
> criminal.getOver_All_Rating();
> String Id_Marks =
> criminal.getId_Marks();
> System.out.println("Display of
> REMOTEXXX
> Object"+"\n"+lastName+"\n"+
>
driver_id+"\n"+ssn+"\n"+pass_num+"\n"+over_all_rating+"\n"+Id_Marks+"\n");
> }
>
> Collection c1 =
> home.findByLastName("BBB");
> Iterator i1 = c1.iterator();
> if(c1.isEmpty())
> {
> System.out.println("No Collection with
> Last Name Found!!");
> }
> while(i1.hasNext())
> {
> CriminalRemote criminal =
> (CriminalRemote)
> PortableRemoteObject.narrow
>
> (i1.next(),CriminalRemote.class);
> // String firstName =
> criminal.getPrimaryKey();
> String firstName =
> criminal.getFirstName();
> Integer driver_id =
> criminal.getDriver_Id();
> Integer ssn = criminal.getSSN();
> Integer pass_num =
> criminal.getPassport_Num();
> Integer over_all_rating =
> criminal.getOver_All_Rating();
> String Id_Marks =
> criminal.getId_Marks();
> System.out.println("Display of REMOTEBBB
> Object"+"\n"+firstName+"\n"+
>
driver_id+"\n"+ssn+"\n"+pass_num+"\n"+over_all_rating+"\n"+Id_Marks+"\n");
> }
> Integer a = new Integer(23140);
> remote = home.findByPrimaryKey(a);
>
> {
> String firstName =
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
xdoclet-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/xdoclet-user
