topic Re: Store object in Database in Application Development and Automation Discussions

Store object in Database

Former Member — Mon, 22 Mar 2010 09:52:57 GMT

Hi All,

Was wondering if its possible to store an object of data type any in a database field?? And if so how?

Thanks David

Re: Store object in Database

Former Member — Mon, 22 Mar 2010 14:09:17 GMT

Hi David,

You should take a look at how to persist classes in ABAP OO - SAP Help -> [The Persistence Service|http://help.sap.com/saphelp_nw04/helpdata/EN/f5/a36828bc6911d4b2e80050dadfb92b/frameset.htm].

Edited by: Ferenc Peter on Mar 22, 2010 3:09 PM

Re: Store object in Database

mvoros — Mon, 22 Mar 2010 22:47:24 GMT

Hi,

I am not sure what exactly you need. But if you want to be able to store a field of any type in DB then one way how to do it is to use XML. I use it in one of my tools and it works fine. Basically, I have a simple table with fields KEY and CONTENT. The field CONTENT has type STIRNG. There are two standard XSLTs: CONVERT_XML_INT_TO_EXT and CONVERT_XML_EXT_TO_INT. They convert data in any type to XML and back. It does not work for objects. Actually, it does not dump and it generates a valid XML but you can't use it for serialization/deserialization of objects.

Cheers

Re: Store object in Database

Sandra_Rossi — Mon, 22 Mar 2010 23:23:30 GMT

Or simply use ABAP statement CALL TRANSFORMATION 'ID' to transform variable to XML, or XML to variable (and define database field as STRING, to contain the XML string)

Re: Store object in Database

Former Member — Tue, 23 Mar 2010 09:03:03 GMT

Exactly what i was looking for Sandra.

Thanks David