Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Converting BLOB to different datatypes Expand / Collapse
Author
Message
Posted Friday, December 21, 2012 6:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799

Hi Experts,

Is it possible to convert a java object which is now stored as a BLOB field to character values.
The java object in BLOB contains parent and child values ,we need to differentiate those.The blob value contains
some numbers, some charcters, some object itself this level of child objects may be more than 4-5 level

Is it possible and if yes then how?

Thanks in Advance.
Post #1399361
Posted Friday, December 21, 2012 6:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:57 AM
Points: 7,081, Visits: 12,575
Not unless you can deserialize the object using a SQLCLR object to review its properties, which I highly doubt. There is no native Java capability in SQL Server that would allow you to inspect that BLOB inside the database as if it were an object again, that I know of. You might be able to shoehorn the instantiation of a Java object into the scope of a SQLCLR object somehow by making an external call. Maybe you could have a SQLCLR object pass the BLOB to an external web service or executable for deserialization and inspection, but that would be terribly slow I would venture, if its even technically feasible. What you might want to start doing is storing the parent-child indicators in a separate column(s) next to the BLOB but you still have the problem of inspecting the existing data to initialize the new column(s).

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1399377
Posted Thursday, January 31, 2013 4:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Thanks OPC
Post #1413982
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse