Re: need createCriteria help
Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting the required result from the following, will anybody help me out public List listAll(){ ContactInfoExample example = new ContactInfoExample(); example.createCriteria().andIdContactInfoEqualTo(24); return contactInfoDAO.selectByExample(example); } -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594367.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: need createCriteria help
I read the doc but that is not enough for me. Actually I am done according to the doc but still getting my required result. Thats why i need ur help. I dont understand why i am not getting my desire result. Do u ever tried this example class. I mean example.createCriteria()? if yes then tell me where was i am going wrong. TarakBhandary wrote: Are you mocking me..?? Its sounds like that. Anyways thanks for the link... Kengkaj Sathianpantarit wrote: You can download dev guide from the link as follows. http://ibatis.apache.org/onlinehelp.html Don't hurry, actually you don't have to do the job ASAP :). Do it right. Kengkaj On Thu, Mar 19, 2009 at 1:42 PM, TarakBhandary reach2ta...@gmail.comwrote: Actually i dont have enough knowledge in this pls help me out i have to do the job as soon as possible. If there is any link which will help me out pls provide. Kengkaj Sathianpantarit wrote: Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting the required result from the following, will anybody help me out public List listAll(){ ContactInfoExample example = new ContactInfoExample(); example.createCriteria().andIdContactInfoEqualTo(24); return contactInfoDAO.selectByExample(example); } -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594367.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594491.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594759.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: need createCriteria help
I haven't tried the Example class because I don't have source codes. As you said you did according to the doc, can you post source codes, and XML mapping? Kengkaj On Thu, Mar 19, 2009 at 2:13 PM, TarakBhandary reach2ta...@gmail.comwrote: I read the doc but that is not enough for me. Actually I am done according to the doc but still getting my required result. Thats why i need ur help. I dont understand why i am not getting my desire result. Do u ever tried this example class. I mean example.createCriteria()? if yes then tell me where was i am going wrong. TarakBhandary wrote: Are you mocking me..?? Its sounds like that. Anyways thanks for the link... Kengkaj Sathianpantarit wrote: You can download dev guide from the link as follows. http://ibatis.apache.org/onlinehelp.html Don't hurry, actually you don't have to do the job ASAP :). Do it right. Kengkaj On Thu, Mar 19, 2009 at 1:42 PM, TarakBhandary reach2ta...@gmail.comwrote: Actually i dont have enough knowledge in this pls help me out i have to do the job as soon as possible. If there is any link which will help me out pls provide. Kengkaj Sathianpantarit wrote: Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting the required result from the following, will anybody help me out public List listAll(){ ContactInfoExample example = new ContactInfoExample(); example.createCriteria().andIdContactInfoEqualTo(24); return contactInfoDAO.selectByExample(example); } -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594367.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594491.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594759.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
RE: need createCriteria help
Hi tarak, It's probably the quickest to debug yourself; - What is wrong in the result set? - Did you get log4j working, and do you see the generated query? == What is wrong with the generated query? - Put a breakpoint and view the example class and logical check this against the query map in your xml. This should make it fairly clear from this what is wrong. Kind Regards Meindert -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 11:10 AM To: user-java@ibatis.apache.org Subject: Re: need createCriteria help Look its not possible to post all the pages. I have post the listAll method where I am trying to get the result as the sql query. I will post the source code if it is in one page, but its linked in so many pages. So it is not possible at this moment. Kengkaj Sathianpantarit wrote: I haven't tried the Example class because I don't have source codes. As you said you did according to the doc, can you post source codes, and XML mapping? Kengkaj On Thu, Mar 19, 2009 at 2:13 PM, TarakBhandary reach2ta...@gmail.comwrote: I read the doc but that is not enough for me. Actually I am done according to the doc but still getting my required result. Thats why i need ur help. I dont understand why i am not getting my desire result. Do u ever tried this example class. I mean example.createCriteria()? if yes then tell me where was i am going wrong. TarakBhandary wrote: Are you mocking me..?? Its sounds like that. Anyways thanks for the link... Kengkaj Sathianpantarit wrote: You can download dev guide from the link as follows. http://ibatis.apache.org/onlinehelp.html Don't hurry, actually you don't have to do the job ASAP :). Do it right. Kengkaj On Thu, Mar 19, 2009 at 1:42 PM, TarakBhandary reach2ta...@gmail.comwrote: Actually i dont have enough knowledge in this pls help me out i have to do the job as soon as possible. If there is any link which will help me out pls provide. Kengkaj Sathianpantarit wrote: Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting the required result from the following, will anybody help me out public List listAll(){ ContactInfoExample example = new ContactInfoExample(); example.createCriteria().andIdContactInfoEqualTo(24); return contactInfoDAO.selectByExample(example); } -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594367.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594491.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594759.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22595554.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.18/2008 - Release Date: 03/17/09 16:25:00
RE: need createCriteria help
Thanks for the reply. Do you think that my method is ok? Is it the way to fetch the records. Do u have any other way to fetch the conditional records. meindert-3 wrote: Hi tarak, It's probably the quickest to debug yourself; - What is wrong in the result set? - Did you get log4j working, and do you see the generated query? == What is wrong with the generated query? - Put a breakpoint and view the example class and logical check this against the query map in your xml. This should make it fairly clear from this what is wrong. Kind Regards Meindert -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 11:10 AM To: user-java@ibatis.apache.org Subject: Re: need createCriteria help Look its not possible to post all the pages. I have post the listAll method where I am trying to get the result as the sql query. I will post the source code if it is in one page, but its linked in so many pages. So it is not possible at this moment. Kengkaj Sathianpantarit wrote: I haven't tried the Example class because I don't have source codes. As you said you did according to the doc, can you post source codes, and XML mapping? Kengkaj On Thu, Mar 19, 2009 at 2:13 PM, TarakBhandary reach2ta...@gmail.comwrote: I read the doc but that is not enough for me. Actually I am done according to the doc but still getting my required result. Thats why i need ur help. I dont understand why i am not getting my desire result. Do u ever tried this example class. I mean example.createCriteria()? if yes then tell me where was i am going wrong. TarakBhandary wrote: Are you mocking me..?? Its sounds like that. Anyways thanks for the link... Kengkaj Sathianpantarit wrote: You can download dev guide from the link as follows. http://ibatis.apache.org/onlinehelp.html Don't hurry, actually you don't have to do the job ASAP :). Do it right. Kengkaj On Thu, Mar 19, 2009 at 1:42 PM, TarakBhandary reach2ta...@gmail.comwrote: Actually i dont have enough knowledge in this pls help me out i have to do the job as soon as possible. If there is any link which will help me out pls provide. Kengkaj Sathianpantarit wrote: Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting the required result from the following, will anybody help me out public List listAll(){ ContactInfoExample example = new ContactInfoExample(); example.createCriteria().andIdContactInfoEqualTo(24); return contactInfoDAO.selectByExample(example); } -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594367.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594491.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594759.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22595554.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.18/2008 - Release Date: 03/17/09 16:25:00 -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22596627.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
RE: need createCriteria help
I agreed with your views but here I have something to say, that there is the methods available, which I am using to fetch the records, right. Now I am not getting my results according to the requirement. I have done this according to there document. Now what I am trying to say is the tool is provide us the sql code then why I write those sql manually. If methods are there to retrieve the record then I should use those methods with compatible to the framework, isn't it. Now what is reason behind that my method is not giving me the actual output then is the given example class methods are wrong or the way I am using that is wrong. Here I am not finding any answer. Hope u ll give me some better idea regarding this matter. meindert-3 wrote: Is it the way to fetch the records. It's a universal way to fetch records. The power in ibatis is the control over your queries and the ease of debugging. Hibernate is probably the better tool if you don't want query control or if you want your persistent layer to create the DB Do u have any other way to fetch the conditional records. Definitely, just add your custom method to the DAO and to the sqlmaps. For your example where you have just one (integer) criteria that you want to put in the where clause I would look in the sqlmap's xml file how the query is actual structured and make your own query taking a 'int' as parameterclass The query would look something like; SELECT X FROM Y WHERE Z=#value# Or you can use ContactInfo as parameterclass, the query would be SELECT X FROM Y WHERE Z=#idContactInfo# In fact, I rarely let ibator generate the selectbyExample code. -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 11:43 AM To: user-java@ibatis.apache.org Subject: RE: need createCriteria help Thanks for the reply. Do you think that my method is ok? Is it the way to fetch the records. Do u have any other way to fetch the conditional records. meindert-3 wrote: Hi tarak, It's probably the quickest to debug yourself; - What is wrong in the result set? - Did you get log4j working, and do you see the generated query? == What is wrong with the generated query? - Put a breakpoint and view the example class and logical check this against the query map in your xml. This should make it fairly clear from this what is wrong. Kind Regards Meindert -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 11:10 AM To: user-java@ibatis.apache.org Subject: Re: need createCriteria help Look its not possible to post all the pages. I have post the listAll method where I am trying to get the result as the sql query. I will post the source code if it is in one page, but its linked in so many pages. So it is not possible at this moment. Kengkaj Sathianpantarit wrote: I haven't tried the Example class because I don't have source codes. As you said you did according to the doc, can you post source codes, and XML mapping? Kengkaj On Thu, Mar 19, 2009 at 2:13 PM, TarakBhandary reach2ta...@gmail.comwrote: I read the doc but that is not enough for me. Actually I am done according to the doc but still getting my required result. Thats why i need ur help. I dont understand why i am not getting my desire result. Do u ever tried this example class. I mean example.createCriteria()? if yes then tell me where was i am going wrong. TarakBhandary wrote: Are you mocking me..?? Its sounds like that. Anyways thanks for the link... Kengkaj Sathianpantarit wrote: You can download dev guide from the link as follows. http://ibatis.apache.org/onlinehelp.html Don't hurry, actually you don't have to do the job ASAP :). Do it right. Kengkaj On Thu, Mar 19, 2009 at 1:42 PM, TarakBhandary reach2ta...@gmail.comwrote: Actually i dont have enough knowledge in this pls help me out i have to do the job as soon as possible. If there is any link which will help me out pls provide. Kengkaj Sathianpantarit wrote: Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting the required result from the following, will anybody help me out public List listAll(){ ContactInfoExample example = new ContactInfoExample(); example.createCriteria().andIdContactInfoEqualTo(24); return contactInfoDAO.selectByExample(example); } -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594367.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594491.html Sent from
Re: need createCriteria help
Look its not possible to post all the pages. I have post the listAll method where I am trying to get the result as the sql query. I will post the source code if it is in one page, but its linked in so many pages. So it is not possible at this moment. Kengkaj Sathianpantarit wrote: I haven't tried the Example class because I don't have source codes. As you said you did according to the doc, can you post source codes, and XML mapping? Kengkaj On Thu, Mar 19, 2009 at 2:13 PM, TarakBhandary reach2ta...@gmail.comwrote: I read the doc but that is not enough for me. Actually I am done according to the doc but still getting my required result. Thats why i need ur help. I dont understand why i am not getting my desire result. Do u ever tried this example class. I mean example.createCriteria()? if yes then tell me where was i am going wrong. TarakBhandary wrote: Are you mocking me..?? Its sounds like that. Anyways thanks for the link... Kengkaj Sathianpantarit wrote: You can download dev guide from the link as follows. http://ibatis.apache.org/onlinehelp.html Don't hurry, actually you don't have to do the job ASAP :). Do it right. Kengkaj On Thu, Mar 19, 2009 at 1:42 PM, TarakBhandary reach2ta...@gmail.comwrote: Actually i dont have enough knowledge in this pls help me out i have to do the job as soon as possible. If there is any link which will help me out pls provide. Kengkaj Sathianpantarit wrote: Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting the required result from the following, will anybody help me out public List listAll(){ ContactInfoExample example = new ContactInfoExample(); example.createCriteria().andIdContactInfoEqualTo(24); return contactInfoDAO.selectByExample(example); } -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594367.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594491.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22594759.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/need-createCriteria-help-tp22594367p22595554.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
RE: need createCriteria help
Sorry, I don't see anything wrong with the way you are using the generated code. And I'm not even going to ask you for the detailed information (to find out what is wrong) because it would quite likely also show yourself what is wrong with the generated code. So my unhelpful answer is; Debug it and report the bug that you discovered in the code generated by ibatus. I love ibatus in the transparent and easy to debug way it creates the queries. Meindert -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 12:18 PM To: user-java@ibatis.apache.org Subject: RE: need createCriteria help I agreed with your views but here I have something to say, that there is the methods available, which I am using to fetch the records, right. Now I am not getting my results according to the requirement. I have done this according to there document. Now what I am trying to say is the tool is provide us the sql code then why I write those sql manually. If methods are there to retrieve the record then I should use those methods with compatible to the framework, isn't it. Now what is reason behind that my method is not giving me the actual output then is the given example class methods are wrong or the way I am using that is wrong. Here I am not finding any answer. Hope u ll give me some better idea regarding this matter. meindert-3 wrote: Is it the way to fetch the records. It's a universal way to fetch records. The power in ibatis is the control over your queries and the ease of debugging. Hibernate is probably the better tool if you don't want query control or if you want your persistent layer to create the DB Do u have any other way to fetch the conditional records. Definitely, just add your custom method to the DAO and to the sqlmaps. For your example where you have just one (integer) criteria that you want to put in the where clause I would look in the sqlmap's xml file how the query is actual structured and make your own query taking a 'int' as parameterclass The query would look something like; SELECT X FROM Y WHERE Z=#value# Or you can use ContactInfo as parameterclass, the query would be SELECT X FROM Y WHERE Z=#idContactInfo# In fact, I rarely let ibator generate the selectbyExample code. -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 11:43 AM To: user-java@ibatis.apache.org Subject: RE: need createCriteria help Thanks for the reply. Do you think that my method is ok? Is it the way to fetch the records. Do u have any other way to fetch the conditional records. meindert-3 wrote: Hi tarak, It's probably the quickest to debug yourself; - What is wrong in the result set? - Did you get log4j working, and do you see the generated query? == What is wrong with the generated query? - Put a breakpoint and view the example class and logical check this against the query map in your xml. This should make it fairly clear from this what is wrong. Kind Regards Meindert -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 11:10 AM To: user-java@ibatis.apache.org Subject: Re: need createCriteria help Look its not possible to post all the pages. I have post the listAll method where I am trying to get the result as the sql query. I will post the source code if it is in one page, but its linked in so many pages. So it is not possible at this moment. Kengkaj Sathianpantarit wrote: I haven't tried the Example class because I don't have source codes. As you said you did according to the doc, can you post source codes, and XML mapping? Kengkaj On Thu, Mar 19, 2009 at 2:13 PM, TarakBhandary reach2ta...@gmail.comwrote: I read the doc but that is not enough for me. Actually I am done according to the doc but still getting my required result. Thats why i need ur help. I dont understand why i am not getting my desire result. Do u ever tried this example class. I mean example.createCriteria()? if yes then tell me where was i am going wrong. TarakBhandary wrote: Are you mocking me..?? Its sounds like that. Anyways thanks for the link... Kengkaj Sathianpantarit wrote: You can download dev guide from the link as follows. http://ibatis.apache.org/onlinehelp.html Don't hurry, actually you don't have to do the job ASAP :). Do it right. Kengkaj On Thu, Mar 19, 2009 at 1:42 PM, TarakBhandary reach2ta...@gmail.comwrote: Actually i dont have enough knowledge in this pls help me out i have to do the job as soon as possible. If there is any link which will help me out pls provide. Kengkaj Sathianpantarit wrote: Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary reach2ta...@gmail.comwrote: I am not getting