ADF Mobile - store image to Oracle entity, retrieve as SOAP WS to Mobile amx

Legacy

JDev(11.1.2.4.0)

Well I think the title says it all here.

Would like to store images (on external 12c DB)  taken with the mobile device via DataControl Update View Objects from the Web Service.     (where photo is taken, and table is updated along with other form data)

Read a few articles on how to store images on a local directory which the DB has access to, but could not make anything work.

Wondering if Data Control amx objects can simply render the blobs into form views, once retrieved.

dvohra21

ADF Mobile application has access to the native SQLite database.

ADF MOBILE: Storing images into sqlite DB

Images may be got with the getPicture method.

Using Bindings and Creating Data Controls - 11g Release 2 (11.1.2.3.0)

Legacy

So would it be possible to query my initial result set from an Oracle Business Component, modify,and save with image to internal SQLite.

What good is data when it's only available on the local device. Isn't that the whole purpose of having a mobile application, to send, retrieve, manipulate data from external sources?

Also, I'm using 11.1.2.4, not 11.1.2.3

dvohra21

A web service may be used to access Oracle Database from ADF Mobile.

Legacy

I'm lost. First you tell me to store it locally, now a WS.

dvohra21

The default support for the native SQLite is provided, but if a remote Oracle Database is required a web service would be required to access the database.

Some references:

Oracle JDeveloper 11g Release 2 Tutorials - Building Mobile Applications with Oracle ADF Mobile

Database Web Services

dvohra21

Would like to store images (on external 12c DB)

Does the database have to be 12c?

Another option is to use the Oracle Database Lite Mobile Server (Mobile Server), which provides integration with ADF Mobile.

References:

http://www.appservgrid.com/documentation/docs/fmw11g1115documentation/doc.1111/e14826/sync.htm#BCGJHJBG

http://www.oracle.com/technetwork/database/database-technologies/database-mobile-server/overview/index.html

Legacy

Im just trying to get a feel for what I should do.

Basically, when the button is pressed, form data will be updated to 12c, at the same time, the picture I have taken could be added to a POJO class object, with attributes of the entity data, and adding the image.

        Store that locally,

        But when fetched next run, would still only retrieve 12c form data, without the image.

Could you explain the steps I need to perform in order to coordinate the POJO object image with the 12c WS form data?

Shay Shmeltzer-Oracle

Frank has a sample of getting images from the mobile device to the server - http://www.oracle.com/technetwork/developer-tools/adf/learnmore/m01-image-server-upload-1906763.pdf

Legacy

Yeah I read that Shay, I will have to go over it again. Thank you.

Legacy

His service is done from a web.XML file. Also, the sample application he provides is different than the code corner example, although it does execute and run as presented.

I'm not familiar with XML services, basically I've been doing all the tutorials on basic Business Components taken from an Oracle Database.

I've got a nice application going, with several queried screens of form data which can be updated and saved to the via web service.

The roadblock is storing an image along with a specific queried record.

I'm thinking that I could query the record and getPicture() , save the queried record and image to the local SQLite Database.

When the record is retrieved, it would use the external identifier as source of new amx page record, which showed the saved data and image.

Sound good?

I guess I really need to learn the basics of web services and how to write java classes which implement them. There are so many Developers Guides out there. Mostly I've worked with Eclipse and NetBeans to make GUI's with Oracle DB's , web side server is all new to me. Could you recommend where I should start reading on how to create the xml services needed to interact with the web logic server? There are so many Developers Guides I don't know where to begin.

Thank you - Jeff