This is a migrated thread and some comments may be shown as answers.

Open Access is changing name of table in SQL statement

2 Answers 61 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Chris
Top achievements
Rank 1
Chris asked on 20 Jul 2009, 05:55 PM
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 Answers, 1 is accepted

Sort by
0
cayates
Top achievements
Rank 1
answered on 20 Jul 2009, 08:31 PM
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.
0
Alexander
Telerik team
answered on 21 Jul 2009, 06:03 AM
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.

Greetings,
Alexander
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.
Tags
General Discussions
Asked by
Chris
Top achievements
Rank 1
Answers by
cayates
Top achievements
Rank 1
Alexander
Telerik team
Share this question
or