Mysql field type text

11 posts, 0 answers
  1. Casper
    Casper avatar
    4 posts
    Member since:
    Feb 2009

    Posted 14 Feb 2009 Link to this post

    Hi,

    When i try to retrieve a text field from det db i get this error:

    Error reading field MyClassLibrary.News.text from ResultSet: Telerik.OpenAccess.RT.sql.SQLException: Not implemented yet: ResultSetImp.getAsciiStream
       ved Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.getAsciiStream(Int32 columnIndex)
       ved OpenAccessRuntime.Relational.sql.conv.AsciiStreamConverter.getValue(ResultSet rs, Int32 index, RelationalColumn col)
       ved OpenAccessRuntime.Relational.RelationalGenericState.getFieldData(RelationalField f, ResultSet rs, Int32 firstCol, Int32 fieldNo)
       ved OpenAccessRuntime.Relational.RelationalGenericState.copyPass1Fields(ResultSet rs, FetchGroupField[] fetchGroups, Int32 firstCol) Telerik.OpenAccess.RT.sql.SQLException: Not implemented yet: ResultSetImp.getAsciiStream
       ved Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.getAsciiStream(Int32 columnIndex)
       ved OpenAccessRuntime.Relational.sql.conv.AsciiStreamConverter.getValue(ResultSet rs, Int32 index, RelationalColumn col)
       ved OpenAccessRuntime.Relational.RelationalGenericState.getFieldData(RelationalField f, ResultSet rs, Int32 firstCol, Int32 fieldNo)
       ved OpenAccessRuntime.Relational.RelationalGenericState.copyPass1Fields(ResultSet rs, FetchGroupField[] fetchGroups, Int32 firstCol)

    My code:

    using (IObjectScope objectScope = MyClassLibrary.ObjectScopeProvider1.GetNewObjectScope())
                {
                    string oql = "SELECT * FROM NewsExtent AS n " +
                            "WHERE n.DeletedDate = nil AND n.Public = true AND n.Newsid = $1";

                    IQuery query = objectScope.GetOqlQuery(oql);
                    IQueryResult result = query.Execute(new object[] { newsId });

                   foreach (MyClassLibrary.News news in result)
                    {
                        return news;
                    }           
    }

  2. Casper
    Casper avatar
    4 posts
    Member since:
    Feb 2009

    Posted 15 Feb 2009 Link to this post

    I have also tried to change the field type to longtext and changing the mapping from longtext to text in the 
    ADO Type Mapping tool. Both with the same result: It gives me the same error.
  3. DevCraft banner
  4. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 17 Feb 2009 Link to this post

    Hi Casper,
    There is a problem with our type converters for mysql , you can not use LONGVARCHAR and CLOB at the moment. Please try to use varchar as db-type.

    We will try to fix it for the next patch.

    Greetings,
    Jan Blessenohl
    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.
  5. Jouie
    Jouie avatar
    9 posts
    Member since:
    Nov 2007

    Posted 11 Mar 2009 Link to this post

    Hi Jan,

     

    I am currently evaluating your free edition of OpenAccess ORM for MySQL and encountered also the problem. When do we expect the patch to be posted?

    Thanks,

    Jouie

  6. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 20 Mar 2009 Link to this post

    Hello Jouie,
    The fix did not make it into the last release. The next patch might be available in 3-4 weeks.

    Sincerely yours,
    Jan Blessenohl
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  7. Erdal
    Erdal avatar
    6 posts
    Member since:
    Jan 2009

    Posted 24 Mar 2009 Link to this post

    hi,

    is CLOB supported for Oracle-DB?
    When I try to change Column to CLOB, I get not even mke the fowardmapping.

    Can you please confirm this so that I don't have to try on


    Thanks
  8. Erdal
    Erdal avatar
    6 posts
    Member since:
    Jan 2009

    Posted 24 Mar 2009 Link to this post

    Hi,

    just changing sqltype and leave type to varchar had the desired result.


    Thanks for listening ;-)
  9. Paul
    Paul avatar
    113 posts
    Member since:
    May 2009

    Posted 18 May 2009 Link to this post

    When will the fix for this be available as I have a lot of Text datatypes in my MySQL db.

    What are the workrounds without me having to change the datatype in my DB?
  10. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 19 May 2009 Link to this post

    Hi Paul,
    The problem with Text columns has been fixed. The fix will be available in the next build. Hopefully in an custom build available this week.

    Regards,
    Jan Blessenohl
    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.
  11. Paul
    Paul avatar
    113 posts
    Member since:
    May 2009

    Posted 20 May 2009 Link to this post

    Hi Jan,
               Thats great news thanks.
  12. Paul
    Paul avatar
    113 posts
    Member since:
    May 2009

    Posted 22 May 2009 Link to this post

    Hi,
       I have just installed the latest custom build  2009.01.0520.1 and can confirm this has now been fixed.

    Thanks again.

    Paul.
Back to Top
DevCraft banner