Styjun

Is encryption still applied if you ignore the SSL certificate warning for self signed?

How to remove the first colon ':' from a timestamp?

Wordplay addition paradox

Are there any restrictions on how amendment should be related to original law in US Senate?

Why did my "seldom" get corrected?

Software need db owner permission to master database (sql2016)

Term “console” in game consoles

What is this green alien supposed to be on the American covers of the "Hitchhiker's Guide to the Galaxy"?

How did Jayne know when to shoot?

Zhora asks Deckard: "Are you for real?". Was this meant to be significant?

Not able to find the "TcmTemplateDebugHost" process in Attach process, Even we run the Template builder

Random piece of plastic

Did 007 exist before James Bond?

How fast does a character need to move to be effectively invisible?

How can one convert an expression to a string while keeping the quotation marks of strings that are part of the expression?

Necroskitter and creatures dying because of placing -1/-1 counters

Difference between c++14 and c++17 using: `*p++ = *p`

A scene of Jimmy diversity

Why won't some unicode characters print to my terminal?

How would you say "Sorry, that was a mistake on my part"?

Redirect if userid is not found in a database table

Should I have shared a document with a former employee?

Why is Google approaching my VPS machine?

What were the problems on the Apollo 11 lunar module?

Getting exception while fetching a list from subquery

How to get an enum value from a string value in Java?HQl equivalent of sql queryHibernate: HQL Row Count Subquery issueJPA/hibernate subquery in from clauseHibernate HQL for finding by parameter and criteriahow to use Oracle's regexp_like in Hibernate HQL?hibernate HQL error for update query when use join onselecting records from tables using HQL Query…@HQL QuerySyntaxExceptionHow to select data from SubQuery in HQL?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I want to fetch a list from a subquery in HQL

return (List<Sitecnb>) hibernateTemplate.find(
"from Sitecnb as sc where sc.countrycnbCode in(from Land as ld where ld.landKennzeichen)= ? ", name);

I am getting error

•An unexpected error occured. Details: unexpected AST node: in near
line 1, column 75 [from com.bearingpoint.sisnet.domain.Sitecnb as sc
where sc.countrycnbCode in(from com.bearingpoint.sisnet.domain.Land as
ld where ld.landKennzeichen)= ? ]; nested exception is
org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: in
near line 1, column 75 [from com.bearingpoint.sisnet.domain.Sitecnb as
sc where sc.countrycnbCode in(from com.bearingpoint.sisnet.domain.Land
as ld where ld.landKennzeichen)= ? ]

java hibernate hql

share|improve this question

edited Mar 26 at 13:48

Dave Newton

143k2020 gold badges220220 silver badges260260 bronze badges

asked Mar 26 at 9:47

sumant kumarsumant kumar

133 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Yes, because it's invalid, just like it says. Maybe you meant to have the =? inside the parentheses instead of dangling outside? This is a basic syntax problem, which IMO means you should probably take a step back and actually learn a little bit about HQL instead of typing random strings.
  
  – Dave Newton
  Mar 26 at 13:49
  

  
  
  
  

add a comment | 

0

I want to fetch a list from a subquery in HQL

return (List<Sitecnb>) hibernateTemplate.find(
"from Sitecnb as sc where sc.countrycnbCode in(from Land as ld where ld.landKennzeichen)= ? ", name);

I am getting error

•An unexpected error occured. Details: unexpected AST node: in near
line 1, column 75 [from com.bearingpoint.sisnet.domain.Sitecnb as sc
where sc.countrycnbCode in(from com.bearingpoint.sisnet.domain.Land as
ld where ld.landKennzeichen)= ? ]; nested exception is
org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: in
near line 1, column 75 [from com.bearingpoint.sisnet.domain.Sitecnb as
sc where sc.countrycnbCode in(from com.bearingpoint.sisnet.domain.Land
as ld where ld.landKennzeichen)= ? ]

java hibernate hql

share|improve this question

edited Mar 26 at 13:48

Dave Newton

143k2020 gold badges220220 silver badges260260 bronze badges

asked Mar 26 at 9:47

sumant kumarsumant kumar

133 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Yes, because it's invalid, just like it says. Maybe you meant to have the =? inside the parentheses instead of dangling outside? This is a basic syntax problem, which IMO means you should probably take a step back and actually learn a little bit about HQL instead of typing random strings.
  
  – Dave Newton
  Mar 26 at 13:49
  

  
  
  
  

add a comment | 

I want to fetch a list from a subquery in HQL

return (List<Sitecnb>) hibernateTemplate.find(
"from Sitecnb as sc where sc.countrycnbCode in(from Land as ld where ld.landKennzeichen)= ? ", name);

I am getting error

•An unexpected error occured. Details: unexpected AST node: in near
line 1, column 75 [from com.bearingpoint.sisnet.domain.Sitecnb as sc
where sc.countrycnbCode in(from com.bearingpoint.sisnet.domain.Land as
ld where ld.landKennzeichen)= ? ]; nested exception is
org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: in
near line 1, column 75 [from com.bearingpoint.sisnet.domain.Sitecnb as
sc where sc.countrycnbCode in(from com.bearingpoint.sisnet.domain.Land
as ld where ld.landKennzeichen)= ? ]

java hibernate hql

share|improve this question

edited Mar 26 at 13:48

Dave Newton

143k2020 gold badges220220 silver badges260260 bronze badges

asked Mar 26 at 9:47

sumant kumarsumant kumar

133 bronze badges

return (List<Sitecnb>) hibernateTemplate.find(
"from Sitecnb as sc where sc.countrycnbCode in(from Land as ld where ld.landKennzeichen)= ? ", name);

share|improve this question

edited Mar 26 at 13:48

Dave Newton

143k2020 gold badges220220 silver badges260260 bronze badges

asked Mar 26 at 9:47

sumant kumarsumant kumar

133 bronze badges

share|improve this question

edited Mar 26 at 13:48

Dave Newton

143k2020 gold badges220220 silver badges260260 bronze badges

asked Mar 26 at 9:47

sumant kumarsumant kumar

133 bronze badges

edited Mar 26 at 13:48

Dave Newton

143k2020 gold badges220220 silver badges260260 bronze badges

edited Mar 26 at 13:48

Dave Newton

143k2020 gold badges220220 silver badges260260 bronze badges

asked Mar 26 at 9:47

sumant kumarsumant kumar

133 bronze badges

asked Mar 26 at 9:47

sumant kumarsumant kumar

133 bronze badges