Mysql field type text

[Casper]

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;
                }           
}

[Casper]

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.

[Jan Blessenohl]

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.

[Jouie]

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

[Jan Blessenohl]

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.

[Erdal]

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

[Erdal]

Hi,

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


Thanks for listening ;-)

[Paul]

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?

[Jan Blessenohl]

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.

[Paul]

Hi Jan,
           Thats great news thanks.

[Paul]

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

Thanks again.

Paul.