Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes Object Relational Mapping and the fly likes unexpected token Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "unexpected token" Watch "unexpected token" New topic

unexpected token

raj chopra
Ranch Hand

Joined: Apr 09, 2012
Posts: 64
Hi All,

i am using hibernate,springs,struts in my project.
i am trying to fetch a value from a table in oracle db, when i am trying to do so i get the below error

org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: org near line 1, column 125 [se
lect org.ein from org, billwhere org.organizationId
=bill.organizationid and bill.organizationid=?]; nested exception is org.hibernate.hql.ast.QuerySyntaxError: unexpected token: org near lin
e 1, column 125 [select org.ein from org, billwhere
org.organizationId=bill.organizationid and bill.organizationid=?]

query i used was :
"select org.ein "+
"from SBOrganization org,SBBillingAddress bill" +
"where org.organizationId=bill.organizationid " +
"and bill.organizationid=?"

The above query was working fine when i executed the query directly in oracle database,(i entered the value in where condition eg: organizationid=482 )
however when i execute the same query in application i get the above mentioned exception.

kindly guide me to shoot this error.
thanks in advance

raj chopra
raj chopra
Ranch Hand

Joined: Apr 09, 2012
Posts: 64
problem solved.

solution was that there was a space problem before quation mark at end of the line.
I agree. Here's the link:
subject: unexpected token
It's not a secret anymore!