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

Mysql field type text

10 Answers 204 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Casper
Top achievements
Rank 1
Casper asked on 14 Feb 2009, 02:03 PM
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;
                }           
}

10 Answers, 1 is accepted

Sort by
0
Casper
Top achievements
Rank 1
answered on 15 Feb 2009, 08:47 PM
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.
0
Jan Blessenohl
Telerik team
answered on 17 Feb 2009, 03:53 PM
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.
0
Jouie
Top achievements
Rank 1
answered on 11 Mar 2009, 07:51 AM

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

0
Jan Blessenohl
Telerik team
answered on 20 Mar 2009, 05:13 PM
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.
0
Erdal
Top achievements
Rank 1
answered on 24 Mar 2009, 05:16 PM
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
0
Erdal
Top achievements
Rank 1
answered on 24 Mar 2009, 05:45 PM
Hi,

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


Thanks for listening ;-)
0
Paul
Top achievements
Rank 1
answered on 18 May 2009, 01:18 PM
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?
0
Jan Blessenohl
Telerik team
answered on 19 May 2009, 11:53 AM
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.
0
Paul
Top achievements
Rank 1
answered on 20 May 2009, 08:21 AM
Hi Jan,
           Thats great news thanks.
0
Paul
Top achievements
Rank 1
answered on 22 May 2009, 09:21 AM
Hi,
   I have just installed the latest custom build  2009.01.0520.1 and can confirm this has now been fixed.

Thanks again.

Paul.
Tags
Databases and Data Types
Asked by
Casper
Top achievements
Rank 1
Answers by
Casper
Top achievements
Rank 1
Jan Blessenohl
Telerik team
Jouie
Top achievements
Rank 1
Erdal
Top achievements
Rank 1
Paul
Top achievements
Rank 1
Share this question
or