2009.3.1103.4 and CLOB's

[cayates]

Hello,

I upgraded to 2009.3.1103.4 and now CLOB's are returning as null when they actually have data in them.  Here are the steps I took:

1) Brand new project
2) Enable project to use telerik (using oracle 10g database with odp driver)
3) Reverse engineer a table that has a CLOB column
4) Do a simple OqlQuery that selects the object

The data member that is mapped to the clob is null even though the table has data in that column.  The previous version I was using, 2008.3.1327.2, worked fine before.

Is there a known bug with that version and Oracle clob's?

Thanks,

Chris

[Jan Blessenohl]

Hi cayates,

I am sorry, you are right, I have to dig into that and find out why it happens. The workaround is to use varchar type in the middle.

<field name="nClobString">
  <extension key="db-column">
    <extension key="db-sql-type" value="NCLOB" />
    <extension key="db-length" value="0" />
    <extension key="db-type" value="VARCHAR" />
  </extension>
</field>

We will fix that ASAP and keep you informed.

Greetings,
Jan Blessenohl
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[cayates]

That fixed the problem of selecting the CLOB data, however, here's the error I got when I tried that while doing an update:

Update failed: Telerik.OpenAccess.RT.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()
   at OpenAccessRuntime.Relational.RelationalStorageManager.generateUpdates(OID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, Boolean haveNewObjects, CharBuf s)

Is there a workaround for that also?

Thanks,

Chris

[Jan Blessenohl]

Hello cayates,
A custom build that fixes your problem is now available in your download area.


Kind regards,
Jan Blessenohl
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Ricardo Moura]

We have the same problem here. Can we get that custom build with the fix ?

[Ady]

Hi Ricardo Moura,

 Can you upgrade to the latest internal build? You can download it via the 'Downloads' link in your account page. Click on the 'Internal builds' link to see a list of available internal builds.

Kind regards,
Ady
the Telerik team

Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.

[Ricardo Moura]

Hi,

We have already upgraded, and it worked fine.

Thanks.