PostgreSQL Mapping with custom types

7 posts, 0 answers
  1. Sebastian SWC
    Sebastian SWC avatar
    4 posts
    Member since:
    Nov 2009

    Posted 16 Jan 2011 Link to this post

    Hy, sorry for my poor english.

    I'm trying to use OpenAcess with PostgreSQL. My database have just only a table with a custom type.

    Table definition:
    CREATE TABLE test
    (
      id serial NOT NULL,
      myarray integer[],
      mycontrol custom_control,
      CONSTRAINT test_pk PRIMARY KEY (id)
    );

    My custom_control Definition:
    CREATE TYPE custom_control
    AS (
        dt_modify timestamp without time zone,
        obs character varying(50)
    );

    After create a new domain model and try to see the table table on a radgrid, the following error occours:

    Server Error in '/' Application.

    No database type mapping found for field '_myarray': CLR type 'System.Object' or column type '_int4' unmapped.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: Telerik.OpenAccess.Exceptions.MetadataException: No database type mapping found for field '_myarray': CLR type 'System.Object' or column type '_int4' unmapped. 

    Any idea what i have to do to solve this problem?
  2. Sebastian SWC
    Sebastian SWC avatar
    4 posts
    Member since:
    Nov 2009

    Posted 16 Jan 2011 Link to this post

    I uploaded the project with the related problem in my website. 
  3. DevCraft banner
  4. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 18 Jan 2011 Link to this post

    Hi Sebastian SWC,

    It seems that there is an issue when PostgreSql user defined types are used in Telerik OpenAccess ORM. We will investigate the cause for this problem and fix it.
    Once we resolve the problem we will provide you with details regarding the wrong behavior.
    I am sorry for the inconvenience caused.

    All the best,
    Damyan Bogoev
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  5. Sebastian SWC
    Sebastian SWC avatar
    4 posts
    Member since:
    Nov 2009

    Posted 18 Jan 2011 Link to this post

    Hey,

    Don't forget the array types with problem too.

    Thanks for your support.
  6. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 20 Jan 2011 Link to this post

    Hi Sebastian SWC,

    We will do our best to implement this feature for the next Q1 release.
    Once again I am sorry for the inconvenience caused.

    Kind regards,
    Damyan Bogoev
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  7. Sebastian SWC
    Sebastian SWC avatar
    4 posts
    Member since:
    Nov 2009

    Posted 27 May 2011 Link to this post

    Hi,

    any news about that?

    Thanks
  8. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 31 May 2011 Link to this post

    Hi Sebastian SWC,

    I am afraid that currently we do not provide support for PostgreSql user-defined types in the product.
    I am sorry for the inconvenience caused.

    All the best,
    Damyan Bogoev
    the Telerik team
    Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 
Back to Top
DevCraft banner