This question is locked. New answers and comments are not allowed.
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:
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
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
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.
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
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.
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
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 ;-)
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?
What are the workrounds without me having to change the datatype in my DB?
0
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.
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.
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.
I have just installed the latest custom build 2009.01.0520.1 and can confirm this has now been fixed.
Thanks again.
Paul.