Discussion:
[Liquibase-user] New Topic: Almost every databaseObjectName is escaped on Oracle
Liquibase Community Forum
2010-10-21 10:17:08 UTC
Permalink
A new topic, 'Almost every databaseObjectName is escaped on Oracle', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=752.new#new

The text of the topic is shown below:

Hi,

while testing 2.0-rc7-SNAPSHOT (trunk) on oracle, it seems that OracleDatabase.escapeDatabaseObject(objectName) escapes almost every objectName, although my names don't include any non-word characters.

e.g.
I tried to create a sequence named sq_search_role, which results in:

Code:
create sequence "sq_search_role";

The problem is: When inserting a entry using Hibernate, it is not able to query the sequence because Oracle (case-insensitive db) requires the double quotes around the name.

I created a Jira issue with a patch for this.

Regards,
Michael

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.

Loading...