Win a copy of Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2 this week in the Spring forum!

Abhishek Ralhan

Ranch Hand
+ Follow
since Aug 01, 2010
Abhishek likes ...
Eclipse IDE Chrome Ubuntu
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
2
Received in last 30 days
0
Total given
3
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Abhishek Ralhan

Thanks Karthik Shiraly,

We get a list of these codes from another application through webservice request. And we hit the dB with the same list. This functionality is very old but very recently the other application sending codes with leading 0's.
And those leading 0's were the problem and I was not at all aware of this bug in Hibernate earlier.
Thanks very much for your inputs. It solved my one incident in Production
Hello Ranchers,

I am using JPA. And in it I fire a query which comes out to be:
SELECT DISTINCT d FROM table_name d WHERE d.col1.col2.col3 in
(1003713,0001002750,0001024523,0001021484,0001010011,0001003496,0001028583,0001021690,0001002758,0001010034,0001034260,0001025623,0001002765,0001007371,0001022650,0001019684,0001007642,0001027533,0001017113,0001002127,0001018804,0001025417,0001029838,0001030677,0001002780,0001007495,0001025434,0001004385,0001002008,0001011199,0001029506,0001006463,0001006474,0001028575,0001011182,0001008273,0001004161,0001003489,0001006469,0001010440,0001008276,0001006464,0001030665,0001024326,0001024057,0001021230,0001007368,0001004393,0001007360,0001002731,0001026370,0001001113,0001025051,0001026368,0001011204,0001002830,0001012602,0001004101,0001002277,0001028275,0001015916,0001010586,0001030685,0001028501,0001007358,0001029825,0001030796,0001013175,0001002725,0001025645,0001009524,0001007359,0001010443,0001026372,0001001094,0001011522,0001025046,0001029264,0001027449,0001003493,0001001114,0001030879,0001012196,0001004798,0001002494,0001013843,0001013426,0001013634,0001025401,0001011508,0001011677,0001034747,0001025619,0001002493,0001011509,0001002774,0001028690,0001007370,0001004104,0001008578,0001008575,0001002769,0001026016,0001026322,0001019974,0001002495,0001023825,0001007367,0001017864,0001025063,0001029837,0001035223,0001013844,0001003715,0001002129,0001031126,0001035071,0001007373,0001024027,0001022647,0001021997,0001002772,0001019351,0001002019,0001002761,0001025954,0001010892,0001005025,0001022008,0001004102,0001006471,0001004108,0001009523,0001003495,0001029836,0001004805,0001010459,0001007782,0001004391,0001009036,0001007364,0001009398,0001011502,0001031110,0001008274,0001013176,0001011769,0001027234,0001002766,0001019355,0001016220,0001007365,0001028168,0001007106,0001025065,0001024154,0001008707,0001024558,0001029559,0001033631,0001002748,0001004629,0001003515,0001021998,0001021680,0001001982,0001021481,0001009040,0001008574,0001004389,0001002275,0001026815,0001024020,0001004804,0001025564,0001024025,0001023286,0001021482,0001006465,0001021461)
ORDER by d.col4 DESC

Now when this query is hit it throws a below exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 84 near line 1, column 126

Below is the stacktrace:

at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:93)
at org.jboss.ejb3.entity.TransactionScopedEntityManager.createQuery(TransactionScopedEntityManager.java:141)


The reason for this I think is that, may be, I am fitting too many values in the IN () function and it looks like JPA has initial size for the parameters or the queries, which is may be crossed.
Please suggest if this is the case, and what should I do to counter this kind of scenario.
can you please explain what is the whole flow from request to response(before which session times out)?
what is the error message you are getting on console/logs??
are you making a database call, if yes, what is its time-out?
9 years ago
welcome Craig
9 years ago
You may be already aware, but incase you are not, unique constraint allows one null value. So you may have to handle it through code.
if you still have doubts, i think, its the right time for you to start with the design patterns. The design pattern here in discussion is Factory Design Pattern
i have never seen/tried it. But what's the big deal, just put the body script in another <script> tags and go ahead, just likeits donr in the second <script> tag of your code.
use readline for reading sex.
If you want, you can validate the input data afterwards.
Well ideally, you must find it yourself.
Hint: Check the getInstance method of Calender class
if you use eclipse or any other IDE you can search the whole workspace/project for the "commerce.page.title". Believe me it works for me most of the times, when i am clueless, in my project
9 years ago
You can also try to use all these combinations.
Actually it depends upon the term "where no price is defined". Whatever this term means, the answer lies in that meaning only.
Do you mean either of below:
- you want to cache the previous radio button selection,
- persist it somewhere and us next time,
- repopulate it to a default value

if no, please elaborate the requirement. Also, are you using some framework like jsf etc. or simple servlets/jsps??

Never heard in a web application, static methods would access database.
Would like to know the responses though.

Anyone please respond..
Hi,

You can use a hidden field like:
<input type="hidden" id="test" value="#{backBean.value}"> in your page.
And in your javascript you can getElementId("test") and read its value.

Note: I don't remember the "input type hidden" for jsf , hence i used the jsp component "input"
9 years ago
JSF
Try ArulKumaran's "Good java j2ee interview questions". I've been reading it myself too. See if you feel its helpful.
9 years ago