Oracle column name issue

Question

I have parent-child mapping in hibernate where the entities are connected through table.

The problem is that column automatically created by hibernate in this table is called like "_actions_id". But I use Oracle and it says that column name "_actions_id" is invalid.

It works fine when I wrap the name with "" and execute the script manually, but is there a way to make hibernate to wrap all columns with "" ?

Do you have to rely on the default names? If you don't, then you can specify the name using the joinColumns annotation property and create the column in the database manually. You can have quotes in the property as well. — billc.cn
– billc.cn, Commented Jun 4, 2012 at 23:53
Could you bring a simplest example? how are name and referencedColumnName are correlated? Should I specify 2 columns or just for the child entity? — Oleg
– Oleg, Commented Jun 5, 2012 at 0:28

Community · Accepted Answer · 2017-05-23 11:56:30Z

1

In your example, you specified a join table, which is for scenarios like this

People table:
PID | Name
1   | Albert
2   | Bob


TelephoneNumbers table:
TID | Tel
1   | 123-456
2   | 456-789
3   | 789-012

Join table:
PID | TID
1   | 1
1   | 2
2   | 3

I.e. the column that connects the current entity to the entity in the collection is in neither the current table nor the table for the collection entity. This is more useful for the many-to-many mapping, but you can also use it for OneToMany if you don't have control over the TelephoneNumbers table for example. Otherwise you should just use plain @JoinColumn.

The usage of @JoinTable has been explained many times by many websites. See the JavaDoc and this question.

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Jun 5, 2012 at 0:40

billc.cn

7,3443 gold badges43 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Watts · Accepted Answer · 2012-06-04 23:09:51Z

0

I think you want a custom NamingStrategy. I got the idea here. In your case, it would be something like:

public class MyNamingStrategy extends DefaultNamingStrategy {
    public String logicalCollectionColumnName(String columnName, String propertyName, String referencedColumn) {
        return "`" + super.logicalCollectionColumnName(columnName, propertyName, referencedColumn + "`";
    }
}

answered Jun 4, 2012 at 23:09

John Watts

8,9151 gold badge35 silver badges36 bronze badges

Collectives™ on Stack Overflow

Oracle column name issue

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related