ORM Error after connecting with the DB

6 posts, 0 answers
  1. Grace Manasseh
    Grace Manasseh avatar
    10 posts
    Member since:
    Mar 2010

    Posted 09 Jul 2010 Link to this post

    Hello,

    I'm trying to enable ORM with an existing Oracle database schema, using the Telerik OpenAccess domain model designer by using 'Add new item' and add a 'Telerik OpenAccess Domain Model'. It connects with the database and when retreiving the database schema, I'm getting the following error:

    Connection error, ExceptionTelerik.OpenAccess.RT.sql.SQLException, Details:ORA-00942: table or view does not exist

    Any Idea?? Please find attached the screenshot.
    Note that I'm using the latest version Telerik-OpenAccess-ORM-2010.1.623.5
  2. Peter Meinl
    Peter Meinl avatar
    35 posts
    Member since:
    Jan 2010

    Posted 10 Jul 2010 Link to this post

    I have the same problem.

    Using:
    Telerik_OpenAccess_ORM_2010_1_624_trial
    Oracle ODP.NET: ODAC112011beta
  3. DevCraft banner
  4. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 13 Jul 2010 Link to this post

    Hello Grace Manasseh,

    This is a known issue which is already fixed. The fix will be part of the product in the Q2 release (due this week).
    I am sorry for the inconvenience caused.

    All the best,
    Damyan Bogoev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Emanuele Zambrano
    Emanuele Zambrano avatar
    21 posts
    Member since:
    Dec 2009

    Posted 24 Aug 2010 Link to this post

    I have a similar issue with version 2010.2.714.1 of ORM and Oracle ODAC 11g R2.
    In the Domain Model wizard all work correctly.

    Error ORA-00942 (table or view not found) raise when I query the data with this code:
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim conn As New Db
        Dim qry = From p In conn.TBLNOLEGGIRAC Where p.DDATAFINEFATTURA.Value.Year = 2009 Select p
        For Each item In qry.ToList
            Debug.WriteLine(item.ToString)
        Next
    End Sub
  6. Ady
    Admin
    Ady avatar
    589 posts

    Posted 27 Aug 2010 Link to this post

    Hello Emanuele Zambrano,

     As pointed out  in your other support ticket  (341728) for the same problem, the Domain Wizard will detect the appropriate pk column(s) and it will be automatically mapped to a field(s) which is marked as the identity field for the class. Can you verify this in the wizard? You should ensure that every class has a Pk specified in the designer.

    Do you still get the 'PK not defined' error?

    Greetings,
    Ady
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  7. Emanuele Zambrano
    Emanuele Zambrano avatar
    21 posts
    Member since:
    Dec 2009

    Posted 27 Aug 2010 Link to this post

    I have fixed the problem adding voa_key table and defining all PKs.
Back to Top
DevCraft banner