oracle: table names case sensitive problem

11 posts, 1 answers
  1. Markus
    Markus avatar
    42 posts
    Member since:
    Sep 2008

    Posted 22 Nov 2010 Link to this post

    Hello, I am trying to run an older oracle database ( created with Vanatec OpenAccess 4.x ) with newest OpenAccess version. I imported a dumfile using oralce's imp utility and migrated the schema (VScheme.exe). When I try to start my application exception ORA-00942: Table or view does not exist. The problem is table "voa_key" is named in upper case after import from dumpfile. If I rename the table to lower case, table will be found, but there are other tables named in upper case and OpenAccess cannot found these.
    With older OpenAccess version 4.3.20 it doesn't matter if table names are upper or lower case. So I think these behavior changed.
    Another problem is with VSchema. Table and column names where double quoted, so if table or column name exists in upper case, object could not be found. I had to manually delete quotation marks for this objects to get sscript running.
    I work with genericADO driver, odp not testd yet

    Is it possible to get OpenAccess work case insensitive ?

    Regards,

    Markus
  2.
  3. Answer
    Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 23 Nov 2010 Link to this post

    Hello Markus,

    please add one element into your backend configuration in the app.config file:
    <useDelimitedSQL>false</useDelimitedSQL>

    This element controls if quotation marks are used when the SQL is produced. If no quotation marks are used, the upper case form of the table name will be found by Oracle. 

    Kind regards,
    Thomas
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  5. Joshua Kent
    Joshua Kent avatar
    15 posts
    Member since:
    Nov 2009

    Posted 16 Nov 2012 Link to this post

    Does this work in the domain model (rlinq)? currently openaccess is quoting all of my columns and table names which is making them case sensitive and breaking some of our database tools.

    Thanks,
       Josh
  7. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 19 Nov 2012 Link to this post

    Hi Josh,

    yes, please go to the 'Show Model Settings' dialog on the DSL, select 'Database Names' and control the behavior with the 'Delimit identifiers' checkbox.

    Greetings,
    Thomas
    the Telerik team
    Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
  9. Joshua Kent
    Joshua Kent avatar
    15 posts
    Member since:
    Nov 2009

    Posted 21 Dec 2012 Link to this post

    Thanks this works perfect for tables, however it looks like Triggers and Sequences are still being delimited. Is there anyway to change this behavior?

    Thanks,
       Josh
  11. Joshua Kent
    Joshua Kent avatar
    15 posts
    Member since:
    Nov 2009

    Posted 23 Dec 2012 Link to this post

    It also appears that this configuration option breaks the checking for modifications when generating the ddl. Every time I tell it to update database from model it tries to appears to think none of my tables exist and tries to recreate them all.
  13. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 27 Dec 2012 Link to this post

    Hello Joshua,

     
    Firstly I want to apologize for the inconvenience caused.

    1. It appears that the use delimiter is not respected when creation script for sequences and triggers is being generated. We will improve this behavior in the next major release of the product.
    2. Actually this is expected behavior. The diff / merge algorithm that is used for checking the schema model differences is case-sensitive.

    We will notify you in this thread once the release, containing the schema creation improvements, is available for download.

    Greetings,
    Damyan Bogoev
    the Telerik team
    Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.
  15. Luca Galbiati
    Luca Galbiati avatar
    1 posts
    Member since:
    Jul 2007

    Posted 02 Oct 2013 Link to this post

    Hello Damyan,
    any news about that? I'm using the 2013.2.701.2 version, but the problem on sequences and triggers still remains.
    Thanks.
    Luca,
  17. Doroteya
    Admin
    Doroteya avatar
    498 posts

    Posted 07 Oct 2013 Link to this post

    Hi Luca,

    Please accept our apologies for the inconvenience you are experiencing.

    Indeed, version 2013.2.701.2 does not contain the improvement in question. It was applied in the OpenAccess ORM code, but by mistake it was not released. Next week the Q3 2013 version will be available for download and it will deliver the necessary fix.

    Thank you for your patience and understanding. If you have additional questions, do not hesitate to get back to us.

     

    Regards,
    Doroteya
    Telerik
    OpenAccess ORM Q3 2013 Beta is available for immediate download in your account. Get it now and play with the latest bits. See what's new >>
  19. Allen
    Allen avatar
    50 posts
    Member since:
    Mar 2011

    Posted 24 Oct 2015 in reply to Thomas Link to this post

    Where does this key go in app.config?  Is there a way to set it in code-behind?

     

  20.
  21. Doroteya
    Admin
    Doroteya avatar
    498 posts

    Posted 28 Oct 2015 Link to this post

    Hi Allan,

    The key provided in the the post of Thomas is for the Classic API of Telerik Data Access and might no be suitable in your situation. To define a solution applicable for your case, I would kindly ask you to provide me with more details about the scenario and the behaviour you are experiencing.

    I am looking forward to your feedback.

    Regards,
    Doroteya
    Telerik
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
Back to Top