unexpected token

raj_pane · **Joined:** Tue Oct 09, 2012 5:30 am **Posts:** 2

Hi all,

i am using hibernate 3.0,spring 1.2,struts1.2 and oracle 9i db.
i am trying to fetch a value froam a table. the query was executed with no exception in oracle db ,however when i execute the same in my application an exception is fired.
below i mention the exception :

org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: billing near line 1, column 124
[select o.ein from com.syntel.sb.appl.bo.client.SBOrganization o,com.syntel.sb.appl.bo.vendor.SBBillingAddress billingwhere billing.organiz
ationid=? and o.organizationId=billing.organizationid ]; nested exception is org.hibernate.hql.ast.QuerySyntaxError: unexpected token: billing near line 1, column 124 [select o.ein from com.syntel.sb.appl.bo.client.SBOrganization o,com.syntel.sb.appl.bo.vendor.SBBillingAddress bi
llingwhere billing.organizationid=? and o.organizationId=billing.organizationid ]

the query i used in application was :

select o.ein "+
"from SBOrganization o,SBBillingAddress billing" +
"where billing.organizationid=? " +
"and o.organizationId=billing.organizationid " ;

kindly guide me to shoot the issue.
thanks in advance.

pb00067 · **Joined:** Tue Jun 16, 2009 3:36 am **Posts:** 990

There's is a space missing between the words "billing" and "where" resulting in "billingwhere"

Code:

"from SBOrganization o,SBBillingAddress billing" +
"where billing.organizationid=? " +

you must transform into:

Code:

"from SBOrganization o,SBBillingAddress billing " +
"where billing.organizationid=? " +

raj_pane · **Joined:** Tue Oct 09, 2012 5:30 am **Posts:** 2

Thank you for your reply.

issue got solved.