Liquibase Community Forum
2010-10-21 10:17:08 UTC
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.
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.