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.
Important thing is the same code was working fine yesterday. I checked with the hbm mapping files and it is correct. Any pointers to solve this will be very helpful. Thanks a lot...
Code:
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 -[b] SQL Error: 1747, SQLState: 42000 [/b]
17:34:32.612 [pool-1-thread-1] ERROR o.h.util.JDBCExceptionReporter - [b]ORA-01747: invalid user.table.column, table.column, or column specification [/b]
Exception in thread "pool-1-thread-1"[b] org.hibernate.exception.SQLGrammarException: could not retrieve snapshot:[/b] [com.test.Option#16244429873196835671]
Login
FAQ
Search