Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 350036 - [DB] Convert CLOB to String in SQLQueryHandler
Summary: [DB] Convert CLOB to String in SQLQueryHandler
Status: CLOSED FIXED
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.db (show other bugs)
Version: 4.1   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Eike Stepper CLA
QA Contact: Eike Stepper CLA
URL:
Whiteboard: Lighter, Faster and Better
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-22 07:46 EDT by Erdal Karaca CLA
Modified: 2012-09-21 07:18 EDT (History)
0 users

See Also:

Attachments
Conversion of java.sql.Clob to String (1.28 KB, patch)
2011-06-22 07:48 EDT, Erdal Karaca CLA 		no flags Details | Diff
Patch v2 (2.08 KB, patch)
2011-07-06 03:40 EDT, Eike Stepper CLA 		no flags Details | Diff
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.