Open Access is changing name of table in SQL statement

Thread is closed for posting
3 posts, 0 answers
  1. Chris
    Chris avatar
    2 posts
    Member since:
    Sep 2008

    Posted 20 Jul 2009 Link to this post

    I have a table called CF_MESSAGE which I reverse engineered into a class named "Message".  When I try to do an OQL query I get a table does not exist error because it replaces CF_MESSAGE with MSG in the SQL.

    Snippet of the binding:

    <class name="Message"
        <extension key="db-do-not-create-table" value="true" /> 
        <extension key="db-table-name" value="CF_MESSAGE" /> 
        <extension key="db-key-generator" value="HIGHLOW" /> 

    SQL that the OQL browser generates using SELECT * FROM MessageExtent AS x:

    SELECT "id", "expire_date", "message_body", "voa_version" FROM "msg"

    What is causing this?

  2. cayates
    cayates avatar
    71 posts
    Member since:
    Feb 2007

    Posted 20 Jul 2009 Link to this post

    I figured it out.  I have two connection's, a dev and prod.  For some reason telerik switched the backendconfigurationname property to oracleConfiguration and added an oracleConfiguration section for the dev connection.  So it wasn't using the correct backend configuration.
  3. Alexander
    Alexander avatar
    727 posts

    Posted 21 Jul 2009 Link to this post

    Hi cayates,

    This unwanted changing of the current backend configuration was a bug in our Enable project wizard and has already been fixed. The patch will be available in the upcoming service pack.

    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Back to Top