topic Re: store an object into database table without using persistence class in Application Development and Automation Discussions

store an object into database table without using persistence class

Former Member — Mon, 17 Jun 2013 10:40:01 GMT

Hi,

I have a z class with some attributes and methods. I created an object to the class and now I want to store this object into database for future use. I mean, I want to dump the object that is in heap memory to database table as it is. and want to retrieve it whenever required with the help of a GUID or a unique identifier that I insert along with object. I am using a relational database.

I understand that I can do it with the help of persistent class but for that I will have to create so many custom tables, views etc., and also map.

want to hear from experts if there is any other alternative to do the same, just as we store a variety files in db by dumping them into index type tables by using export/import.?

Thanks & Regards,

Karthik

Re: store an object into database table without using persistence class

Former Member — Mon, 17 Jun 2013 12:25:40 GMT

Hi Karthik,

Check SHMA shared memory access.

You can download the document...

http://www.google.co.in/url?sa=t&rct=j&q=sdn%20shma&source=web&cd=2&cad=rja&ved=0CDMQFjAB&url=http%3A%2F%2Fwww.sdn.sap.com%2Firj%2Fscn%2Fgo%2Fportal%2Fprtroot%2Fdocs%2Flibrary%2Fuuid%2F307d791b-3343-2e10-f78a-e1d50c7cf89a%3Foverridelayout%3Dtrue&ei=BAC_UfH-KsKXrAe5yIGQAg&usg=AFQjCNG175IEjw_n5aOOryp8MJyc2FGY2g&bvm=bv.47883778,d.bmk

Re: store an object into database table without using persistence class

Former Member — Mon, 17 Jun 2013 17:16:13 GMT

Hi Yakub,

Thanks for your response. using this shared memory concept, The shared memory object now “lives” in SAP memory, and will remain there until the SAP instance goes down. But my objective is to store the object persistently. even when the server is restarted etc..,

In java, we can convert an object to bytearray using serialization and insert that byte array into database table. Using de-serialization, we can reconstruct the object. I want to know if we have any such feasibility in SAP to do the same.

Thanks & Regards,

Karthik

Re: store an object into database table without using persistence class

former_member219762 — Mon, 17 Jun 2013 17:34:56 GMT

Hi Karthik,

All good aspects of java are including in sap .I hope this will help you

http://help.sap.com/abapdocu_70/en/ABAPCALL_TRANSFORMATION.htm

http://scn.sap.com/people/patrick.baer/blog/2005/02/24/abap-serialization--part-i-quick-n-easy

Regards,

Sreenivas.

Re: store an object into database table without using persistence class

Former Member — Tue, 18 Jun 2013 12:55:58 GMT

Hi Karthik,

Sorry it took a little long on how to achieve your requirement here it is with code.

http://scn.sap.com/thread/876355

The thread discusses your exact requirement.

you can convert an instance into XML and store it and retrieve it again.

Cheers.

Re: store an object into database table without using persistence class

Former Member — Tue, 18 Jun 2013 17:25:05 GMT

Hi Yakub and Sreenivas,

Even I thought of doing the same. i.e., to convert object data to xml and then dump it into database.

And yes, I got my answer. Thank you.

Regards,

Karthik