Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 350036

Summary: [DB] Convert CLOB to String in SQLQueryHandler
Product: [Modeling] EMF Reporter: Erdal Karaca <erdal.karaca.de>
Component: cdo.dbAssignee: Eike Stepper <stepper>
Status: CLOSED FIXED QA Contact: Eike Stepper <stepper>
Severity: enhancement    
Priority: P3    
Version: 4.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard: Lighter, Faster and Better
Attachments:
Description Flags
Conversion of java.sql.Clob to String
none
Patch v2 none

Description Erdal Karaca CLA 2011-06-22 07:46:48 EDT 
As net4j does not support java.sql.Clob, values of this type should be converted to String before sending them to the client.
This is needed in case a map query is executed where the DB may return a CLOB.
Comment 1 Erdal Karaca CLA 2011-06-22 07:48:36 EDT 
Created attachment 198387 [details]
Conversion of java.sql.Clob to String

There should be better way to handle type conversion at this point...
Comment 2 Eike Stepper CLA 2011-06-23 03:58:51 EDT 
Moving all open enhancement requests to 4.1
Comment 3 Eike Stepper CLA 2011-07-06 03:40:15 EDT 
Created attachment 199166 [details]
Patch v2

I enhanced your patch so that the CLOB conversion also hapens for mapQuery==false.

Can you please test if this is good for your use case?
Comment 4 Eike Stepper CLA 2011-07-06 03:44:46 EDT 
Committed revision 8611
Comment 5 Eike Stepper CLA 2012-09-21 07:18:19 EDT 
Closing.