This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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...
 
Consider Paul's rocket mass heater.
 
subject: Hibernate error: ORA-01747: invalid user.table.column, table.column, or column specification
 
Similar Threads
How to use Bind Variable with FROM and UPDATE clauses in PreparedStatement???
How many tables can a join have max ?
CachedRowSet updateRow() question
Need a set of eyes...
Error calling stored procedure !!