Hello everyone,
Marina,
Don't be confuse anymore. I have made changes to my project and everything
is working now. I will also tidy up my work. See below for details
All items:
Itemcode
Name
Description
Size
Colour
Price
4547887
iris
table
17in
red
1.20
BC Bargain Corner
5456865
protey
asdf
52in
sdf
5.00
CP Collection Point
5468679
opara
table
16in
pink
12.00
BC Bargain Corner
5475686
asdf
asdf
12inch
white
1.02
CP Collection Point
564646
asdf
yop
14in
red
1.30
SS Self-Serve
564798
asdf
red
8in
grey
14.00
CP Collection Point
I still have issues with the other composite one but I think I have to take time
and resolve that one. I will update people on this.
Thanks for your help Marina.
eve
> Date: Fri, 17 Aug 2007 17:25:53 -0700
> From: Marina.Vatkina_at_Sun.COM
> To: persistence_at_glassfish.dev.java.net
> CC: ejb_at_glassfish.dev.java.net
> Subject: Re: printing composite/foreign keys in the client
>
> Eve,
>
> I'm still confused about your problem... Iteamdetailhlp's constructor doesn't
> populate the departmentent field, so it's null. What is the exact problem that
> you are facing?
>
> Now, what is the purpose of creating the copy of the iteamdetailsent instead of
> just returning the entities from the query? If you do need a copy, why can't you
> store the result of getDepartment() there (or whatever your latest method name is)?
>
> And one more - in your latest code you have both, the department field and the
> depid. Do you really need both? How do you keep them in sync if you do?
>
> thanks,
> -marina
>
> Eve Pokua wrote:
> > Marina,
> >
> > I forgot to paste in my implementation side of this:
> >
> > //To retrieve all items
> > public List<Iteamdetailhlp> AllItems(){
> > List<Iteamdetailsent> iteamdetailsent=null;
> >
> > try{
> > iteamdetailsent=(List<Iteamdetailsent>)em.createNamedQuery("GetAllItems").getResultList();
> >
> > return copyToDetails(iteamdetailsent);
> > }catch (Exception ex) {
> > throw new EJBException(ex);
> > }
> > }//end of AllItems
> >
> > And also from the Query from Iteamdetailsent:
> >
> > @NamedQuery(name = "GetAllItems",query = "SELECT i FROM Iteamdetailsent i"),
> >
> >
> > THanks
> >
> > eve
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> > From: gorgeous65_at_msn.com
> > To: persistence_at_glassfish.dev.java.net
> > CC: ejb_at_glassfish.dev.java.net
> > Date: Fri, 17 Aug 2007 23:59:21 +0100
> > Subject: RE: printing composite/foreign keys in the client
> >
> >
> > Marina,
> >
> > Thanks for your reply.
> >
> > I make still trying to work it out. Below is my helping class to my
> > Iteamdetailsent
> > package StockInformation;
> >
> > *import java.io.Serializable;*
> > *public class Iteamdetailhlp implements Serializable{*
> > *
> > private String itmid;
> > private String itmname;
> > private String description;
> > private String colour;
> > private String price;
> > private String itemsize;
> > private String depid;
> > private String Discount;
> >
> > private Departmentent departmentent;*
> >
> > * public Iteamdetailhlp(){
> > }
> > public Iteamdetailhlp(String itmid, String itmname, String
> > description, String itemsize, String colour, String price){
> > this.itmid=itmid;
> > this.itmname=itmname;
> > this.description=description;
> > this.itemsize=itemsize;
> > this.colour=colour;
> > this.price=price;
> > //this.departmentent=departmentent;
> > }*
> > *
> >
> > public String getitmid(){
> > return itmid;}
> >
> > public void setitmid(String itmid){
> > this.itmid=itmid;}
> >
> >
> > public String getitmname(){
> > return itmname;}
> >
> > public void setitmname(String itmname){
> > this.itmname=itmname;}
> > *
> > * public String getdescription(){
> > return description;}
> >
> > public void setdescription(String description){
> > this.description=description;}*
> > * public String getcolour(){
> > return colour;}
> >
> > public void setcolour(String colour){
> > this.colour=colour;}*
> >
> > * public String getprice(){
> > return price;}
> >
> > public void setprice(String price){
> > this.price=price;}*
> > * public String getitemsize(){
> > return itemsize;}
> >
> > public void setitemsize(String itemsize){
> > this.itemsize=itemsize;}*
> > * public String getDeptID(){
> > return depid;}
> >
> > public Departmentent getDeptID2(){
> > return departmentent;}
> >
> > public void setDeptID(String depid){
> > this.depid=depid;}
> >
> > public String getDiscount(){
> > return Discount;}
> >
> > public void setDiscount(String Discount){
> > this.Discount=Discount;}
> >
> > public String toString() {
> > String s = itmid + " " + itmname +" " + description + "
> > "+ itemsize + " " + colour + " " + price + " " + departmentent;*
> > * return s;
> > }*
> > *}*
> >
> >
> > ANd within the client I am using the helper class to retrieve
> > details to print it up.
> >
> > *try{
> > InitialContext ctx=new InitialContext();
> > Iteamdetails
> > iteamdetails=(Iteamdetails)ctx.lookup("IteamdetailsBeanJNDI");
> > iteamdetailhlp=iteamdetails.AllItems();
> >
> > List<Iteamdetailsent>
> > iteamdetailsent=iteamdetails.DeptItems2();
> > out.println("<TABLE BORDER='1'
> > CELLPADDING='3' CELLSPACING='1'>");
> > out.println("<TR>");
> > out.println("<td>"
> > +"Itemcode");out.println("<td>" +"Name"); out.println("<td>"
> > +"Description"); out.println("<td>" +"Size"); out.println("<td>"
> > +"Colour");out.println("<td>" +"Price");out.println("</td>");
> > out.println("</TR>");
> >
> >
> >
> > for(Iteamdetailhlp itemlist: iteamdetailhlp){
> >
> > out.println("<TR>");
> >
> > out.println("<td>");out.println(itemlist.getitmid());out.println("</td>");
> > out.println("<td>");out.println(itemlist.getitmname());out.println("</td>");
> > out.println("<td>");out.println(itemlist.getdescription());out.println("</td>");
> > out.println("<td>");out.println(itemlist.getitemsize());out.println("</td>");
> > out.println("<td>");out.println(itemlist.getcolour());out.println("</td>");
> >
> > out.println("<td>");out.println(itemlist.getprice());out.println("</td>");
> > out.println("<td>");out.println(
> > itemlist.getDeptID2());out.println("</td>");
> > *
> > **
> > *}*
> >
> > It would have worked if I was using Iteamdetailsent to print the
> > above details But since
> > I am using the helper class and the relationship is not established
> > properly, so is the null
> > result.
> >
> > I hope you understand what I am saying.
> >
> > The other issue I will bring it up later.
> >
> > Thank you.
> >
> > eve
> >
> > Below is
> > > Date: Fri, 17 Aug 2007 13:52:08 -0700
> > > From: Marina.Vatkina_at_Sun.COM
> > > To: persistence_at_glassfish.dev.java.net
> > > CC: ejb_at_glassfish.dev.java.net
> > > Subject: Re: printing composite/foreign keys in the client
> > >
> > > Eve,
> > >
> > > Now I'm confused...
> > >
> > >
> > out.println("<td>");out.println(itemlist.getDeptID());out.println("</td>")
> > >
> > > will print the department (if Department class has toString()
> > method - otherwise
> > > it'll print it's hashcode).
> > >
> > > So what else is not working?
> > >
> > > thanks,
> > > -marina
> > >
> > > Eve Pokua wrote:
> > > >
> > > > Hello everyone,
> > > >
> > > > I believe I have identitied where this problem lies especailly
> > between my
> > > > and
> > > >
> > > >
> > > >
> > > > In my client, I am using my helper class (Iteamdetailhlp) to print
> > > > details from the database.
> > > >
> > > > try{
> > > > InitialContext ctx=new InitialContext();
> > > > Iteamdetails
> > > > iteamdetails=(Iteamdetails)ctx.lookup("IteamdetailsBeanJNDI");
> > > >
> > > > iteamdetailhlp=iteamdetails.BargainCornItems(barconr);
> > > >
> > > >
> > > > out.println("<TABLE BORDER='1' CELLPADDING='3'
> > > > CELLSPACING='1'>");
> > > > out.println("<TR>");
> > > > out.println("<td>"
> > > > +"Itemcode");out.println("<td>" +"Name"); out.println("<td>"
> > > > +"Description"); out.println("<td>" +"Size"); out.println("<td>"
> > > > +"Colour");out.println("<td>" +"Price");out.println("</td>");
> > > > out.println("</TR>");
> > > >
> > > >
> > > > for(Iteamdetailhlp itemlist: iteamdetailhlp){
> > > >
> > > > out.println("<TR>");
> > > > out.println("<form method='get'
> > > > action='AllItemsser'>");
> > > >
> > > >
> > > >
> > out.println("<td>");out.println(itemlist.getItmid());out.println("</td>");
> > > >
> > out.println("<td>");out.println(itemlist.getItmname());out.println("</td>");
> > > >
> > > >
> > out.println("<td>");out.println(itemlist.getDescription());out.println("</td>");
> > > >
> > > >
> > out.println("<td>");out.println(itemlist.getItemsize());out.println("</td>");
> > > >
> > > >
> > out.println("<td>");out.println(itemlist.getColour());out.println("</td>");
> > > >
> > > >
> > out.println("<td>");out.println(itemlist.getPrice());out.println("</td>");
> > > >
> > > >
> > out.println("<td>");out.println(itemlist.getDeptID());out.println("</td>");
> > > > out.println("</td>");
> > > >
> > > >
> > > > But I was having issues linking the helper class to the
> > > > my Departmentent,
> > > >
> > > > So this would not work:
> > > >
> > > > public String toString() {
> > > > String s = itmid + " " + itmname +" " + description + " "+
> > > > itemsize + " " + colour + " " + price + " " + departmentent;
> > > > return s;
> > > > }
> > > >
> > > > This is why the departmentent above in the toString() does not work
> > > > because, there is
> > > > no relationship between this class the related class. However, my
> > > > entity class (Iteamdetailsent)
> > > > is mapped and related to the Departmentent entity.
> > > >
> > > > How do I go about this? Any ideas?
> > > >
> > > > Thanks
> > > >
> > > > eve
> > > >
> > > >
> > > >
> > ------------------------------------------------------------------------
> > > > From: gorgeous65_at_msn.com
> > > > To: persistence_at_glassfish.dev.java.net
> > > > CC: ejb_at_glassfish.dev.java.net
> > > > Date: Thu, 16 Aug 2007 15:52:11 +0100
> > > > Subject: RE: printing composite/foreign keys in the client
> > > >
> > > > Hello everyone,
> > > >
> > > > I have made changes to methods of my classes. I understand this
> > > > mistake was causing some
> > > > confusion. Please, see attached.
> > > >
> > > > Thanks
> > > >
> > > > eve
> > > >
> > > >
> > > >
> > ------------------------------------------------------------------------
> > > > From: gorgeous65_at_msn.com
> > > > To: persistence_at_glassfish.dev.java.net
> > > > CC: ejb_at_glassfish.dev.java.net
> > > > Date: Thu, 16 Aug 2007 12:38:59 +0100
> > > > Subject: RE: printing composite/foreign keys in the client
> > > >
> > > > hi,
> > > >
> > > > > Iteamdetailsent.toString()
> > > >
> > > > I believe this is what you are talking about:
> > > >
> > > > public String toString() {
> > > > String s = itmid + ' ' + itmname +' ' + description +
> > > > ' '+ itemsize + ' ' + colour + ' ' + price + ' ' +
> > > > departmentent;
> > > >
> > > > return s;
> > > > }
> > > >
> > > > it is mapped at the being of the class:
> > > >
> > > > @ManyToOne()
> > > > @JoinColumn(name='DeptID')
> > > > private Departmentent departmentent;
> > > >
> > > > although, I am not sure if I should map these as well:
> > > >
> > > > public Departmentent getDeptID(){
> > > > return departmentent;}
> > > >
> > > > public void setDeptID(Departmentent departmentent){
> > > > this.departmentent=departmentent;}
> > > >
> > > > This is all in the Iteamdetailsent class
> > > >
> > > >
> > > > I will make more changes and see if it works.
> > > >
> > > > Thanks
> > > >
> > > > eve
> > > >
> > > >
> > > >
> > > >
> > > > > Date: Wed, 15 Aug 2007 19:38:58 -0700
> > > > > From: Marina.Vatkina_at_Sun.COM
> > > > > To: persistence_at_glassfish.dev.java.net
> > > > > CC: ejb_at_glassfish.dev.java.net
> > > > > Subject: Re: printing composite/foreign keys in the client
> > > > >
> > > > > Eve,
> > > > >
> > > > > Eve Pokua wrote:
> > > > > > Thanks Marina,
> > > > > >
> > > > > > I will try and clean them up as much as possible. I have
> > > > commented most
> > > > > > out for testing. Just a few questions:
> > > > > >
> > > > > > b) You current example prints the departmentent object ref.
> > > > Does it
> > > > > > print null?
> > > > > >
> > > > > > Are you refering this to the client AllItem??
> > > > >
> > > > > Iteamdetailsent.toString()
> > > > >
> > > > > >
> > > > > > > d) Your properties are not capitalized in CollOrdline -
> > > > that's not a
> > > > > > JavaBean style.
> > > > > >
> > > > > > Sorry! Do you mean I have to state the mothods or variable?
> > > > capital?
> > > > > > Please, explain yourself. I am still learning or I might
> > > > have ignore
> > > > > > certain java styles.
> > > > > > Bear with me please.
> > > > >
> > > > > JavaBean style properties mean having getFoo/setFoo methods
> > > > to represent
> > > > > property named 'foo'.
> > > > >
> > > > > >
> > > > > > e) 'iteamdetailsent' is not initialized - are you sure you
> > > > set it up?
> > > > > >
> > > > > > which of the client are you refering to?? AllItem?/
> > > > >
> > > > > Departmentent. It's not only that the client will be creating
> > > > new instances, but
> > > > > the JPA provider as well.
> > > > >
> > > > > HTH,
> > > > > -marina
> > > > >
> > > > >
> > > > > > Thanks
> > > > > >
> > > > > > eve
> > > > > >
> > > > > >
> > > > > >
> > > > > > > Date: Tue, 14 Aug 2007 12:52:40 -0700
> > > > > > > From: Marina.Vatkina_at_Sun.COM
> > > > > > > To: persistence_at_glassfish.dev.java.net
> > > > > > > CC: ejb_at_glassfish.dev.java.net
> > > > > > > Subject: Re: printing composite/foreign keys in the client
> > > > > > >
> > > > > > > Eve,
> > > > > > >
> > > > > > > Can you cleanup your example? This is a quick list of
> > > > things that can
> > > > > > or cannot
> > > > > > > affect the results, but will make the example(s) easier
> > > > to read:
> > > > > > >
> > > > > > > a) There are too many commented out lines so it's not
> > > > clear if you
> > > > > > used them for
> > > > > > > testing or not.
> > > > > > > b) You current example prints the departmentent object
> > > > ref. Does it
> > > > > > print null?
> > > > > > > c) Your CollOrdlinementKey has other fields besides ids -
> > > > if they are
> > > > > > not used,
> > > > > > > please remove them.
> > > > > > > d) Your properties are not capitalized in CollOrdline -
> > > > that's not a
> > > > > > JavaBean style.
> > > > > > > e) 'iteamdetailsent' is not initialized - are you sure
> > > > you set it up?
> > > > > > TLE caches
> > > > > > > objects as-is, so if you didn't set that relationship, it
> > > > will be
> > > > > > null until you
> > > > > > > refresh the instance.
> > > > > > >
> > > > > > > thanks,
> > > > > > > -marina
> > > > > > >
> > > > > > > Eve Pokua wrote:
> > > > > > > > Marina,
> > > > > > > >
> > > > > > > > I have attached the Iteamdetailsent and Department in a
> > > > zip file.
> > > > > > > > And I have also attached CollOrdline with the client.
> > > > Please, feel free
> > > > > > > > to edit them. Or maybe I didn't make use of
> > > > 'bidirectional entity
> > > > > > > > persistence relations'. How do I specified this type of
> > > > relation in my
> > > > > > > > entities? Or maybe I
> > > > > > > > did not map my getmethods well. Whatever, the reason, I
> > > > would
> > > > > > > > appreciate any help.
> > > > > > > >
> > > > > > > > There is an IdClass in my composite entity
> > > > CollOrderline. I have
> > > > > > > > attached this as well. There was an issue about this
> > > > some time ago and
> > > > > > > > I do believe I have done it right but maybe I'm wrong.
> > > > Please, feel
> > > > > > > > free to edit this as well.
> > > > > > > >
> > > > > > > > here is an example:
> > > > > > > >
> > > > > > > >
> > > > > > > > StUDENT
> > > > > > > >
> > > > > > > >
> > > > > > > > sid
> > > > > > > >
> > > > > > > >
> > > > > > > > fname
> > > > > > > >
> > > > > > > >
> > > > > > > > surname
> > > > > > > >
> > > > > > > >
> > > > > > > > Course
> > > > > > > >
> > > > > > > >
> > > > > > > > cid
> > > > > > > >
> > > > > > > > discription
> > > > > > > >
> > > > > > > >
> > > > > > > > ENROLMENT
> > > > > > > >
> > > > > > > >
> > > > > > > > sid
> > > > > > > >
> > > > > > > >
> > > > > > > > cid
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > >
> > > > > > > > eve
> > > > > > > >
> > > > > > > > > Date: Mon, 13 Aug 2007 10:14:46 -0700
> > > > > > > > > From: Marina.Vatkina_at_Sun.COM
> > > > > > > > > To: persistence_at_glassfish.dev.java.net
> > > > > > > > > CC: ejb_at_glassfish.dev.java.net
> > > > > > > > > Subject: Re: printing composite/foreign keys in the
> > > > client
> > > > > > > > >
> > > > > > > > > Eve,
> > > > > > > > >
> > > > > > > > > I do not see getDeptID() method on Iteamdetailsent.
> > > > Do you map
> > > > > > the FK
> > > > > > > > twice,
> > > > > > > > > once as a relationship and another time as a field?
> > > > > > > > >
> > > > > > > > > Also, CollOrdline does not define an @IdClass - is it
> > > > a typo?
> > > > > > > > >
> > > > > > > > > thanks,
> > > > > > > > > -marina
> > > > > > > > >
> > > > > > > > > Eve Pokua wrote:
> > > > > > > > > > Hello everyone,
> > > > > > > > > >
> > > > > > > > > > I wonder if somebody could provide me with some help.
> > > > > > > > > >
> > > > > > > > > > First of all I have two entities relating to each
> > > > other:
> > > > > > > > > >
> > > > > > > > > > public class Iteamdetailsent implements Serializable{
> > > > > > > > > > ....................
> > > > > > > > > > @ManyToOne()
> > > > > > > > > > @JoinColumn(name='DeptID')
> > > > > > > > > > private Departmentent departmentent;
> > > > > > > > > > }
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > relating to:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > public class Departmentent implements
> > > > java.io.Serializable{
> > > > > > > > > > ...
> > > > > > > > > > @OneToMany(mappedBy='departmentent')
> > > > > > > > > > private Collection <Iteamdetailsent> iteamdetailsent;
> > > > > > > > > >
> > > > > > > > > > ...
> > > > > > > > > > }
> > > > > > > > > >
> > > > > > > > > > In the client when I print details as follows:
> > > > > > > > > >
> > > > > > > > > > for(Iteamdetailhlp itemlist: iteamdetailhlp){
> > > > > > > > > >
> > > > > > > > > > out.println('<TR>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > out.println('<td>');out.println(itemlist.getitmid());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > out.println('<td>');out.println(itemlist.getitmname());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > out.println('<td>');out.println(itemlist.getdescription());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > out.println('<td>');out.println(itemlist.getitemsize());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > out.println('<td>');out.println(itemlist.getcolour());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > out.println('<td>');out.println(itemlist.getprice());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > > out.println('<td>');out.println(
> > > > > > > > itemlist.getDeptID());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > ...........}
> > > > > > > > > >
> > > > > > > > > > The Iteamdetailhlp is a helper class
> > > > > > > > > >
> > > > > > > > > > But this last column gives me a null:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > out.println('<td>');out.println(itemlist.getprice());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > > out.println('<td>');out.println(
> > > > > > > > itemlist.getDeptID());out.println('</td>');
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Itemcode Name Description Size Colour Price
> > > > > > > > > > 4547887 iris table 17in red 1.20 null
> > > > > > > > > > 5456865 protey asdf 52in sdf 5.00 null
> > > > > > > > > > 5468679 opara table 16in pink 12.00 null
> > > > > > > > > > 5475686 asdf asdf 12inch white 1.02 null
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Why is this?
> > > > > > > > > >
> > > > > > > > > > In the log file I get this:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > [#|2007-08-13T15:50:10.603+0100|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=httpWorkerThread-8080-1;|All
> > > >
> > > > > >
> > > > > > > >
> > > > > > > > > > Items:|#]
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Secondly, i have 3 entities relating to each other.
> > > > To resolve
> > > > > > many to
> > > > > > > > > > many relationship and from my understanding of DB,
> > > > I created and
> > > > > > > > entity
> > > > > > > > > > for composition, containing all the primary keys of
> > > > all three
> > > > > > entities
> > > > > > > > > > as follows:
> > > > > > > > > >
> > > > > > > > > > public class Iteamdetailsent implements Serializable{
> > > > > > > > > >
> > > > > > > > > > @Id
> > > > > > > > > > @Column(name='ITMID', nullable=false)
> > > > > > > > > > private String itmid;
> > > > > > > > > >
> > > > > > > > > > ................
> > > > > > > > > >
> > > > > > > > > > }
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > public class Customerent implements Serializable {
> > > > > > > > > >
> > > > > > > > > > @Id
> > > > > > > > > > @Column(name='CUSID', nullable=false)
> > > > > > > > > > private String cusid;
> > > > > > > > > >
> > > > > > > > > > ..................
> > > > > > > > > > }
> > > > > > > > > >
> > > > > > > > > > public class CollOrdersrement implements
> > > > java.io.Serializable{
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > @Id
> > > > > > > > > > @Column(name='CollORDID', nullable=false)
> > > > > > > > > > private String collOrdID;
> > > > > > > > > >
> > > > > > > > > > ............
> > > > > > > > > > }
> > > > > > > > > >
> > > > > > > > > > with the composite keys defined in the following class:
> > > > > > > > > >
> > > > > > > > > > public class CollOrdline implements
> > > > java.io.Serializable{
> > > > > > > > > >
> > > > > > > > > > private String itmid;
> > > > > > > > > > private String cusid;
> > > > > > > > > > private String collOrdID;
> > > > > > > > > >
> > > > > > > > > > public CollOrdline(){}
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > @Id
> > > > > > > > > > public String getitmid(){
> > > > > > > > > > return itmid;}
> > > > > > > > > >
> > > > > > > > > > public void setitmid(String itmid){
> > > > > > > > > > this.itmid=itmid;}
> > > > > > > > > >
> > > > > > > > > > @Id
> > > > > > > > > > //_at_Column(name = 'CollORDID', nullable = false,
> > > > insertable = false,
> > > > > > > > > > updatable = false)
> > > > > > > > > > public String getcollOrdID(){
> > > > > > > > > > return collOrdID;}
> > > > > > > > > >
> > > > > > > > > > public void setcollOrdID(String collOrdID){
> > > > > > > > > > this.collOrdID=collOrdID;}
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > @Id
> > > > > > > > > > public String getcusid()
> > > > > > > > > > {return cusid;}
> > > > > > > > > >
> > > > > > > > > > public void setcusid(String cusid){
> > > > > > > > > > this.cusid=cusid;
> > > > > > > > > > }
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Now when I try to retrieve data from CollOrdline as
> > > > below:
> > > > > > > > > >
> > > > > > > > > > try{
> > > > > > > > > > InitialContext ctx=new InitialContext();
> > > > > > > > > > //call the interface
> > > > > > > > > >
> > > > > > > > > >
> > > > collOrdlinerem=(CollOrdlinerem)ctx.lookup('CollOrdersrementJNDI');
> > > > > > > > > > String sbc='1';
> > > > > > > > > > String rest;
> > > > > > > > > > collOrdline=collOrdlinerem.Collpoinordid(sbc);
> > > > > > > > > > rest=collOrdline.getcollOrdID();
> > > > > > > > > >
> > > > > > > > > > System.out.print(rest);
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > }catch(Exception ex){
> > > > > > > > > > System.err.println('Can not
> > > > > > > > > > show the collection point order');
> > > > > > > > > > }
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > I get a null with the following message in my log file:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > [#|2007-08-13T16:18:36.993+0100|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=httpWorkerThread-8080-1;|
> > > > > > > > > > null|#]
> > > > > > > > > >
> > > > > > > > > > I believe, this has something to do with the way I
> > > > have
> > > > > > specified the
> > > > > > > > > > relationships. How do I resolve this issue?
> > > > > > > > > >
> > > > > > > > > > Any suggestion will be greatly appreciated.
> > > > > > > > > >
> > > > > > > > > > Thanks
> > > > > > > > > >
> > > > > > > > > > eve
> > > > > > > > > >
> > > > > >
> > > > > >
> > > >
> > ------------------------------------------------------------------------
> > > > > > Are you the Quizmaster? Play BrainBattle with a friend now!
> > > > > > <http://specials.uk.msn.com/brainbattle>
> > > >
> > > >
> > ------------------------------------------------------------------------
> > > > The next generation of MSN Hotmail has arrived - Windows Live
> > > > Hotmail <http://www.newhotmail.co.uk/>
> > > >
> > > >
> > > >
> > ------------------------------------------------------------------------
> > > > Play Movie Mash-up and win BIG prizes!
> > <https://www.moviemashup.co.uk/>
> > > >
> > > >
> > > >
> > ------------------------------------------------------------------------
> > > > Play Movie Mash-up and win BIG prizes!
> > <https://www.moviemashup.co.uk>
> >
> >
> > ------------------------------------------------------------------------
> > The future of MSN Messenger! Windows Live Messenger
> > <http://imagine-msn.com/messenger/launch/en-GB/>
> >
> >
> > ------------------------------------------------------------------------
> > The next generation of MSN Hotmail has arrived - Windows Live Hotmail
> > <http://www.newhotmail.co.uk>
_________________________________________________________________
Celeb spotting – Play CelebMashup and win cool prizes
https://www.celebmashup.com/index2.html