Hibernate error: ORA-01747: invalid user.table.column, table.column, or column specification

Hi All,

I am using Hibernate 3.6.1. I am getting the error "ORA-01747: invalid user.table.column, table.column, or column specification" when I try to insert a row in the table. The error is coming up when session.saveOrUpdate is called. The column names & table name in the hbm mapping is perfectly correct. But I am unable to make out the problem.

Any pointers to solve this will be very helpful. Thanks a lot...

Hibernate: select option_.CNCPT_OPT_ID, option_.CNCPT_OPT_DESC_TXT as CNCPT2_2_, option_.CNCPT_OPT_LNG_DESC_TXT as CNCPT3_2_, option_.PRMRY_MTRL_DESC_TXT as PRMRY4_2_, option_.PRMRY_MTRL_TYP_ID as PRMRY5_2_, option_.CNCPT_ID as CNCPT6_2_, option_.PRFL_CD as PRFL7_2_, option_.PRMRY_MTRL_GRP_ID as PRMRY8_2_, option_.SCNDRY_MTRL_GRP_ID as SCNDRY9_2_, option_.SCNDRY_MTRL_TYP_ID as SCNDRY10_2_, option_.SCNDRY_MTRL_DESC_TXT as SCNDRY11_2_, option_.OTHR_MTRL_DESC_TXT as OTHR12_2_, option_.PROD_DIM_TXT as PROD13_2_, option_.EMBLSHMNT_COLR_ID as EMBLSHMNT14_2_, option_.ACCENT_PLTG_TYP_ID as ACCENT15_2_, option_.FORM_ID as FORM16_2_, option_.DCLRD_FILL_UOM_ID. as DCLRD17_2_, option_.OWNR_ORG_ID as OWNR18_2_, option_.CNTNT_SIZE_RNG_ID as CNTNT19_2_, option_.DCLRD_FILL_NR as DCLRD20_2_ from CNCPT_OPT option_ where option_.CNCPT_OPT_ID=?

17:34:32.612 [pool-1-thread-1] WARN  o.h.util.JDBCExceptionReporter - SQL Error: 1747, SQLState: 42000
17:34:32.612 [pool-1-thread-1] ERROR o.h.util.JDBCExceptionReporter - ORA-01747: invalid user.table.column, table.column, or column specification

Exception in thread "pool-1-thread-1" org.hibernate.exception.SQLGrammarException: could not retrieve snapshot: [com.test.Option#16244429873196835671]

Can you post the exception stack trace?
Also, if you can post the .hbm files and the code, it would be helpful.
Did you check the "ORA-01747" error? Any pointers?

"ORA-01747" tells "A column name was specified improperly- Check the statement's syntax, especially references to column names, and retry the statement". I have checked all the column names in my hbm file and its correct. Any inputs will be very helpful..

Quick reply, I don't see any underscores in the column names, but I see them in the query!!

I see you've removed the hbm file.
Can you post it again and are you sure for the userId you are using for connecting all the columns in the particular view or table are visible?

It was an issue with 1 of the column mappings in the hbm... It works fine now..
Thanks a lot for your reply & help...