Re: need createCriteria help

2009-03-18 Thread TarakBhandary
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 jo

Re: need createCriteria help

2009-03-18 Thread Kengkaj Sathianpantarit
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 wrote: > > Actually i dont have enough knowledge in this pls help me ou

Re: need createCriteria help

2009-03-18 Thread TarakBhandary
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, 20

Re: need createCriteria help

2009-03-18 Thread Kengkaj Sathianpantarit
Have you used Dynamic Mapped Statements? Read Developer Guide. Kengkaj On Thu, Mar 19, 2009 at 1:25 PM, TarakBhandary wrote: > > I am not getting the required result from the following, will anybody help > me > out > > public List listAll(){ > >ContactInfoExample example = ne

need createCriteria help

2009-03-18 Thread TarakBhandary
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(

Re: mysql default value

2009-03-18 Thread Kengkaj Sathianpantarit
Interesting, thanks. However, I think it's a bit ugly. And what about if we want to insert null value? Kengkaj 2009/3/18 Iwao AVE! > Hi Alin, > > How about using or ? > > > INSERT INTO vjobs ( > name, status > > description > > ) VALUES ( > #name#, #status# > > #description# >

Re: mysql default value

2009-03-18 Thread Iwao AVE!
Hi Alin, How about using or ? INSERT INTO vjobs ( name, status description ) VALUES ( #name#, #status# #description# ) I haven't tested this, but it should work. Regards, Iwao on 09.3.18 9:42 PM Alin Popa said the following: > Thanks Nicholoz, > > This is what I've

Re: mysql default value

2009-03-18 Thread Nicholoz Koka Kiknadze
I do not like idea of keeping defaults both in database and application. If I have a not nullable database field with some default value, besides setting default value in database I use 'before insert' table trigger that checks if supplied value is NULL and sets it to the desired value. Well, I b

Re: mysql default value

2009-03-18 Thread Kengkaj Sathianpantarit
I think it would be better to put initialize code in constructor, putting checking code in getter will make unnecessary checking every time the getter is called. Kengkaj On Wed, Mar 18, 2009 at 8:00 PM, Alex Sherwin wrote: > What I ususally do: > > > public String getStatus() { > return null ==

Re: mysql default value

2009-03-18 Thread Alex Sherwin
What I ususally do: public String getStatus() { return null == status ? "Some Default Value" : status; } Alin Popa wrote: Thanks Nicholoz, This is what I've done. And I also have a facade that will abstract for the user, the insert actions. I thought that ibatis knows how to handle this, or

Re: mysql default value

2009-03-18 Thread Alin Popa
Thanks Nicholoz, This is what I've done. And I also have a facade that will abstract for the user, the insert actions. I thought that ibatis knows how to handle this, or have a trick for it. On Wed, Mar 18, 2009 at 10:51 AM, Nicholoz Koka Kiknadze wrote: >> Why don't you just exclude this field

Re: mysql default value

2009-03-18 Thread Nicholoz Koka Kiknadze
> Why don't you just exclude this field in the ? INSERT INTO vjobs(name, description) VALUES (#name#,#description#) GL IMO because sometimes one need to insert NULL values too. So why don't you add another insert statement to your xml that will omit the status field? On Wed, Mar 18, 2009 a

Clustering Environment Configuration help needed

2009-03-18 Thread Santhoshkumar_Rajan
Hi, We are in the design phase of a project for a highly-reputed client. We are focusing that the project to be a java based standard. Hence we are using the JPA. Since JPA does not provide clear idea of caching mechanism and about the clustering environment, we thought of usi

Re: mysql default value

2009-03-18 Thread Kengkaj Sathianpantarit
However, I think that default value is good in the case that we don't need to specify value in INSERT command. Why don't you just exclude this field in the ? For , I think that we should specify value explicitly in the model, error from database is correct behavior in case the field has null value

Re: mysql default value

2009-03-18 Thread Kengkaj Sathianpantarit
Sorry, I thought iBATIS should support this behavior. You can solve this problem easily by specify default value in Java class. public class Example { private String status; ... public Example() { this.status = "ready"; } ... } On Wed, Mar 18, 2009 at 3:06 PM, Alin Popa wr

Re: mysql default value

2009-03-18 Thread Alin Popa
Thanks Kengkaj, But from what I read it seems that nullValue is used to substitute value with a database NULL. The thing is that I'm not allowed to use null since field is "NOT NULL". On Wed, Mar 18, 2009 at 6:00 AM, Kengkaj Sathianpantarit wrote: > Use null value replacement feature, read user