wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Hibernate error: ORA-01747: invalid user.table.column, table.column, or column specification Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate error: ORA-01747: invalid user.table.column, table.column, or column specification" Watch "Hibernate error: ORA-01747: invalid user.table.column, table.column, or column specification" New topic
Author

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

achsu subra
Greenhorn

Joined: Feb 01, 2011
Posts: 11
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

Joined: May 16, 2005
Posts: 513

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?


If you are not laughing at yourself, then you just didn't get the joke.
achsu subra
Greenhorn

Joined: Feb 01, 2011
Posts: 11
"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

Joined: May 16, 2005
Posts: 513

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

Joined: May 16, 2005
Posts: 513

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

Joined: Feb 01, 2011
Posts: 11
It was an issue with 1 of the column mappings in the hbm... It works fine now..
Thanks a lot for your reply & help...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate error: ORA-01747: invalid user.table.column, table.column, or column specification