You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Vemund Jakobsen <vj...@dataloy.com> on 2020/01/20 07:38:07 UTC
Filtering with Long values
Hi,
I'm using Cayenne 4.0.2 and am trying to filter with Long values, but I get the exception below. Am I doing something wrong or are there other ways of filtering? I do not see any method called makeLong in the ExpressionParserTokenManager class.
08:24:08,623 ERROR [stderr] (default task-2) java.lang.NumberFormatException: For input string: "2284222503"
08:24:08,624 ERROR [stderr] (default task-2) at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
08:24:08,624 ERROR [stderr] (default task-2) at java.lang.Integer.parseInt(Integer.java:583)
08:24:08,624 ERROR [stderr] (default task-2) at java.lang.Integer.valueOf(Integer.java:740)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.makeInt(ExpressionParserTokenManager.java:80)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.TokenLexicalActions(ExpressionParserTokenManager.java:2569)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.getNextToken(ExpressionParserTokenManager.java:2470)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.jj_ntk(ExpressionParser.java:2667)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.scalarExpression(ExpressionParser.java:956)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.simpleCondition(ExpressionParser.java:318)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.notCondition(ExpressionParser.java:206)
08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.andCondition(ExpressionParser.java:82)
08:24:08,625 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.orCondition(ExpressionParser.java:42)
08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.expression(ExpressionParser.java:35)
08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.ExpressionFactory.fromString(ExpressionFactory.java:1338)
08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.ExpressionFactory.exp(ExpressionFactory.java:1296)
08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.Expression.fromString(Expression.java:181)
Re: Filtering with Long values
Posted by Vemund Jakobsen <vj...@dataloy.com>.
Thanks for the tip! I will try that.
On 2020/01/20 08:21:31, Andrus Adamchik <an...@objectstyle.org> wrote:
> Hi Vemund,
>
> Try changing the format to add "L" at the end: "2284222503L". This form will be parsed as Long.
>
> Andrus
>
> > On Jan 20, 2020, at 10:38 AM, Vemund Jakobsen <vj...@dataloy.com> wrote:
> >
> > Hi,
> >
> > I'm using Cayenne 4.0.2 and am trying to filter with Long values, but I get the exception below. Am I doing something wrong or are there other ways of filtering? I do not see any method called makeLong in the ExpressionParserTokenManager class.
> >
> > 08:24:08,623 ERROR [stderr] (default task-2) java.lang.NumberFormatException: For input string: "2284222503"
> > 08:24:08,624 ERROR [stderr] (default task-2) at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> > 08:24:08,624 ERROR [stderr] (default task-2) at java.lang.Integer.parseInt(Integer.java:583)
> > 08:24:08,624 ERROR [stderr] (default task-2) at java.lang.Integer.valueOf(Integer.java:740)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.makeInt(ExpressionParserTokenManager.java:80)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.TokenLexicalActions(ExpressionParserTokenManager.java:2569)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.getNextToken(ExpressionParserTokenManager.java:2470)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.jj_ntk(ExpressionParser.java:2667)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.scalarExpression(ExpressionParser.java:956)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.simpleCondition(ExpressionParser.java:318)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.notCondition(ExpressionParser.java:206)
> > 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.andCondition(ExpressionParser.java:82)
> > 08:24:08,625 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.orCondition(ExpressionParser.java:42)
> > 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.expression(ExpressionParser.java:35)
> > 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.ExpressionFactory.fromString(ExpressionFactory.java:1338)
> > 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.ExpressionFactory.exp(ExpressionFactory.java:1296)
> > 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.Expression.fromString(Expression.java:181)
>
>
Re: Filtering with Long values
Posted by Andrus Adamchik <an...@objectstyle.org>.
Hi Vemund,
Try changing the format to add "L" at the end: "2284222503L". This form will be parsed as Long.
Andrus
> On Jan 20, 2020, at 10:38 AM, Vemund Jakobsen <vj...@dataloy.com> wrote:
>
> Hi,
>
> I'm using Cayenne 4.0.2 and am trying to filter with Long values, but I get the exception below. Am I doing something wrong or are there other ways of filtering? I do not see any method called makeLong in the ExpressionParserTokenManager class.
>
> 08:24:08,623 ERROR [stderr] (default task-2) java.lang.NumberFormatException: For input string: "2284222503"
> 08:24:08,624 ERROR [stderr] (default task-2) at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> 08:24:08,624 ERROR [stderr] (default task-2) at java.lang.Integer.parseInt(Integer.java:583)
> 08:24:08,624 ERROR [stderr] (default task-2) at java.lang.Integer.valueOf(Integer.java:740)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.makeInt(ExpressionParserTokenManager.java:80)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.TokenLexicalActions(ExpressionParserTokenManager.java:2569)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParserTokenManager.getNextToken(ExpressionParserTokenManager.java:2470)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.jj_ntk(ExpressionParser.java:2667)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.scalarExpression(ExpressionParser.java:956)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.simpleCondition(ExpressionParser.java:318)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.notCondition(ExpressionParser.java:206)
> 08:24:08,624 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.andCondition(ExpressionParser.java:82)
> 08:24:08,625 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.orCondition(ExpressionParser.java:42)
> 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.parser.ExpressionParser.expression(ExpressionParser.java:35)
> 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.ExpressionFactory.fromString(ExpressionFactory.java:1338)
> 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.ExpressionFactory.exp(ExpressionFactory.java:1296)
> 08:24:08,629 ERROR [stderr] (default task-2) at org.apache.cayenne.exp.Expression.fromString(Expression.java:181)