Is it possible to write/read Blob/Text columns using DataServices
Is it possible to write/read Blob/Text columns using DataServices? If so, how is this done. Using a sqlType of Blob or Text does not work.
Bookmark/Search this post with:
- Login or register to post comments
- Printer friendly version
- 194 reads
Hi rmcfraz, This is not
Hi rmcfraz,
This is not possible as of current implementation. But this is in our todo list.
What is the database your using? Perhaps we can provide a quick fix for you.
/sumedha
How about Oracle 10g?
How about Oracle 10g?
Hi xdirewolfx, The overall
Hi xdirewolfx,
The overall plan is to provide BLOB support for popular databases. So it's definelty going to include Oracle as well. :-)
Thanks
/sumedha
I am using MySQL 5.0... I
I am using MySQL 5.0...
I think I found a work around...
What I wanted to do was to serialize a Java object to the database and use dataservices to perform CRUD operations on it. If I serialize the object and then Base64 it will work using dataservices.
In my DBS file I have a sqlType of..
<param name="listdata" sqlType="STRING"/>
and my table column is built like this...
`listdata` mediumtext NOT NULL
This seems to work, but I would still like to use a sqltype of TEXT or BLOB and avoid the workaround if possible.
Thanks,
Robert
Robert, Yes, the approach
Robert,
Yes, the approach you have taken works. I did not want to mention it as you specifically mentioned BLOB field.
I will keep you posted on the developments in this area & let you know when the patch becomes available.
Thanks
/sumedha