Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
achsu subra
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...


 
Arun Kumarr
Ranch Hand
Posts: 661
Eclipse IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
achsu subra
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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..
 
Arun Kumarr
Ranch Hand
Posts: 661
Eclipse IDE Java Spring
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Quick reply, I don't see any underscores in the column names, but I see them in the query!!
 
Arun Kumarr
Ranch Hand
Posts: 661
Eclipse IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
achsu subra
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It was an issue with 1 of the column mappings in the hbm... It works fine now..
Thanks a lot for your reply & help...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic