Bad sql grammer

[raj chopra]

Hi All,

My project involves struts1.2,springs1.2,hibernate 3.0

To display few details in the jsp page , i wrote a query in dao layer and created the related pojo files and hbm files etc
query is :

" select billingaddress.billingaddressLine1,billingaddress.billingaddressLine2,billingaddress.city,billingaddress.firstName,billingaddress.middleName,billingaddress.lastName,"+
" billingaddress.pager,"+
" billingaddress.altPhone,billingaddress.officePhone,billingaddress.cellular,"+
" billingaddress.state,billingaddress.zip,billingaddress.email"+
" from SBBillingAddress billingaddress"+
" where memberid =?"

Below i mention the exception

the exception is org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: 
could not execute query; bad SQL grammar 
[select sbbillinga0_.b_address_line1 as col_0_0_, sbbillinga0_.b_address_line2 as col_1_0_, sbbillinga0_.b_city as col_2_0_, 
sbbillinga0_.b_first_name as col_3_0_, sbbillinga0_.b_middle_name as col_4_0_, sbbillinga0_.b_last_name as col_5_0_, sbbillinga0_.pager as col_6_0_, 
sbbillinga0_.alt_phone as col_7_0_, sbbillinga0_.b_phone_work as col_8_0_, sbbillinga0_.b_phone_mobile as col_9_0_, sbbillinga0_.b_state as col_10_0_, 
sbbillinga0_.b_zip_code as col_11_0_, sbbillinga0_.e_mail_address as col_12_0_ from BILLING_ADDRESS sbbillinga0_ where memberid=?]; 

nested excepti
on is java.sql.SQLException: ORA-00904: "MEMBERID": invalid identifier

[Sai Rao]

Hello Raj, Have you checked if the table SBBillingAddress has a field labelled 'Memberid'? Or is it 'member_id'? Please verify the column name used - it seems to be the likely cause of the error you have posted.

[raj chopra]

Hi sai,

thanks for reply,

Sai Rao wrote:Hello Raj, Have you checked if the table SBBillingAddress has a field labelled 'Memberid'? Or is it 'member_id'? Please verify the column name used - it seems to be the likely cause of the error you have posted.

I have cross checked my table in database, pojo class(SBBillingAddress), and hbm file(SBBillingAddress.hbm.xml) all are fine.
also one more thing is that memberid is defined as primary key in hbm file.

[Reddy Prashanth]

In your query use "where billingaddress.memberid =?" instead of "where memberid =?"

[raj chopra]

Hi prashanth,
Thanks for reply,

Reddy Prashanth wrote:In your query use "where billingaddress.memberid =?" instead of "where memberid =?"

Problem got solved.thanks a ton