Re: AW: Re[2]: [JBoss-user] jboss-ql error
Then, if comparisons are expressed in millis i could do and i can't use >=, <= (cal.validityEnd > (?1 - 1)) ??? Dannemann, Björn wrote: Hi, see JBoss QuickStart.pdf = <= are not allowed with dates in EJBQL, user < and > instead Bjoern -Ursprüngliche Nachricht- Von: Alex Loubyansky [mailto:loubyansky@;ua.fm] Gesendet: Donnerstag, 24. Oktober 2002 15:21 An: kiuma Betreff: Re[2]: [JBoss-user] jboss-ql error Hello kiuma, validityStart and validityEnd are of type Date? if so, then pass in Date type parameter. alex Thursday, October 24, 2002, 4:09:16 PM, you wrote: k> Signature function is k> signature="java.util.Collection findInPeriod( long pInDate) k> where pInDate is date in millis. Hi all, I'm haveing the following error on th is query (jboss v3.2b) SELECT OBJECT(cal) FROM WaCalendar cal WHERE (cal.validityStart <= ?1) AND (cal.validityEnd >= ?1) ORDER BY cal.validityEnd cal.validityStart <= ?1 at line 1 column 51 expecting one of ABS LENGTH LOCATE .. What's wrong? Thx in advance, kiuma -- Best regards, Alex Loubyansky --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun .com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user . --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
AW: Re[2]: [JBoss-user] jboss-ql error
Hi, see JBoss QuickStart.pdf >= <= are not allowed with dates in EJBQL, user < and > instead Bjoern > -Ursprüngliche Nachricht- > Von: Alex Loubyansky [mailto:loubyansky@;ua.fm] > Gesendet: Donnerstag, 24. Oktober 2002 15:21 > An: kiuma > Betreff: Re[2]: [JBoss-user] jboss-ql error > > > Hello kiuma, > > validityStart and validityEnd are of type Date? > if so, then pass in Date type parameter. > > alex > > Thursday, October 24, 2002, 4:09:16 PM, you wrote: > > k> Signature function is > > k> signature="java.util.Collection findInPeriod( long pInDate) > > k> where pInDate is date in millis. > > >> Hi all, > >> I'm haveing the following error on th > > >> is query (jboss v3.2b) > >> > >> SELECT OBJECT(cal) FROM WaCalendar cal WHERE > (cal.validityStart <= ?1) > >> AND (cal.validityEnd >= ?1) ORDER BY cal.validityEnd > >> > >> > >> cal.validityStart <= ?1 at line 1 column 51 > >> > >> expecting one of > >> ABS > >> LENGTH > >> LOCATE > >> .. > >> > >> What's wrong? > >> > >> Thx in advance, > >> kiuma > >> > > > -- > Best regards, > Alex Loubyansky > > > > > --- > This sf.net email is sponsored by: Influence the future > of Java(TM) technology. Join the Java Community > Process(SM) (JCP(SM)) program now. > http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun .com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re[3]: [JBoss-user] jboss-ql error
k>> Do I have to use java.sql.Time in time values finder params ? AL> No. Sorry, yes. :) alex --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re[2]: [JBoss-user] jboss-ql error
k> Thank you alex but now I'm a bit confused: k> accordin to ejb specs v2 k> 11.2.11 Restrinctions k> Date and time values should use the standard java long ,illisecond k> value. . k> What does it mean? It means that dates are compared only by their millisecond values. Not by years, month, days and so on. k> Do I have to use java.sql.Time in time values finder params ? No. alex k> Alex Loubyansky wrote: >>Hello kiuma, >> >>validityStart and validityEnd are of type Date? >>if so, then pass in Date type parameter. >> >>alex >> >>Thursday, October 24, 2002, 4:09:16 PM, you wrote: >> >>k> Signature function is >> >>k> signature="java.util.Collection findInPeriod( long pInDate) >> >>k> where pInDate is date in millis. >> Hi all, I'm haveing the following error on th >> is query (jboss v3.2b) SELECT OBJECT(cal) FROM WaCalendar cal WHERE (cal.validityStart <= ?1) AND (cal.validityEnd >= ?1) ORDER BY cal.validityEnd cal.validityStart <= ?1 at line 1 column 51 expecting one of ABS LENGTH LOCATE .. What's wrong? Thx in advance, kiuma -- Best regards, Alex Loubyansky --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] jboss-ql error
Thank you alex but now I'm a bit confused: accordin to ejb specs v2 11.2.11 Restrinctions Date and time values should use the standard java long ,illisecond value. . What does it mean? Do I have to use java.sql.Time in time values finder params ? Alex Loubyansky wrote: Hello kiuma, validityStart and validityEnd are of type Date? if so, then pass in Date type parameter. alex Thursday, October 24, 2002, 4:09:16 PM, you wrote: k> Signature function is k> signature="java.util.Collection findInPeriod( long pInDate) k> where pInDate is date in millis. Hi all, I'm haveing the following error on th is query (jboss v3.2b) SELECT OBJECT(cal) FROM WaCalendar cal WHERE (cal.validityStart <= ?1) AND (cal.validityEnd >= ?1) ORDER BY cal.validityEnd cal.validityStart <= ?1 at line 1 column 51 expecting one of ABS LENGTH LOCATE .. What's wrong? Thx in advance, kiuma --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re[2]: [JBoss-user] jboss-ql error
Hello kiuma, validityStart and validityEnd are of type Date? if so, then pass in Date type parameter. alex Thursday, October 24, 2002, 4:09:16 PM, you wrote: k> Signature function is k> signature="java.util.Collection findInPeriod( long pInDate) k> where pInDate is date in millis. >> Hi all, >> I'm haveing the following error on th >> is query (jboss v3.2b) >> >> SELECT OBJECT(cal) FROM WaCalendar cal WHERE (cal.validityStart <= ?1) >> AND (cal.validityEnd >= ?1) ORDER BY cal.validityEnd >> >> >> cal.validityStart <= ?1 at line 1 column 51 >> >> expecting one of >> ABS >> LENGTH >> LOCATE >> .. >> >> What's wrong? >> >> Thx in advance, >> kiuma >> -- Best regards, Alex Loubyansky --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] jboss-ql error
Signature function is signature="java.util.Collection findInPeriod( long pInDate) where pInDate is date in millis. Hi all, I'm haveing the following error on th is query (jboss v3.2b) SELECT OBJECT(cal) FROM WaCalendar cal WHERE (cal.validityStart <= ?1) AND (cal.validityEnd >= ?1) ORDER BY cal.validityEnd cal.validityStart <= ?1 at line 1 column 51 expecting one of ABS LENGTH LOCATE .. What's wrong? Thx in advance, kiuma --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user . --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] jboss-ql error
Hi all, I'm haveing the following error on this query (jboss v3.2b) SELECT OBJECT(cal) FROM WaCalendar cal WHERE (cal.validityStart <= ?1) AND (cal.validityEnd >= ?1) ORDER BY cal.validityEnd cal.validityStart <= ?1 at line 1 column 51 expecting one of ABS LENGTH LOCATE .. What's wrong? Thx in advance, kiuma --- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user