Skip to Content

Hi everybody the main intention presenting this blog is to guide the SUP basic learners as how to create the Data Source using Oracle. The Steps that Explained below have been tested in SDK 2.1.3.

Apart from the default Database that comes by installing SDK, the EXTERNAL Database Oracle 11g has been installed in my laptop. While installing Oracle Database I have assigned Database id as MOB. Once after installing you need to check if Database is mounted or not.

My system Environment is 

Operating System – Windows – 7 64bit 

SDK 2.1.3

Oracle 11g 64bit

Once you open the Workspace, you need t right click on the Database Connection in the Enterprise Explorer, then select the New Icon in the Connection
Profile Types wizard

/wp-content/uploads/2012/07/1_116862.png

you need to select Oracle from the list of defined Operations. Select Connection Profile Type as Oracle and assign the Driver Name

/wp-content/uploads/2012/07/2_116863.png/wp-content/uploads/2012/07/3_116906.png

Next you need to select New Driver Definition icon. You may also have an option to select Oracle Thin Driver & System Version.

/wp-content/uploads/2012/07/4_116907.png

Next select JAR list tab and add oracle OJDBC14.jar.  Now you need to search .jar file In the Oracle Installation Directory. Now you need to delete the default .jar file.

/wp-content/uploads/2012/07/5_116908.png/wp-content/uploads/2012/07/6_116909.png

 

(Remove the ojdbc14.jar)

/wp-content/uploads/2012/07/7_116910.png

Next important thing click on Properties tab and add the Correct
Properties

Connection URL, Database name, Driver class, Password, User id

/wp-content/uploads/2012/07/8_116911.png

You may check the Database Details as below

E:\app\satyam\product\11.2.0\dbhome_1\NETWORK\ADMIN\ listener.1.ora

Next you need to click on ‘ok’ then Test Connection now you
will get a message as Ping Success.

/wp-content/uploads/2012/07/9_116915.png/wp-content/uploads/2012/07/10_116916.png

Once you get a Success Message, you have to create Mobile
Workflow Application.

While creating MBO, you have to  open diagram editor. Now Drag and Drop
ZEMPLOYEE table to the Diagram Editor. Once you have done that, a warning
message will be displayed, you need to click ok.

By default Generated Operation called Create will open.

/wp-content/uploads/2012/07/11_116917.png/wp-content/uploads/2012/07/12_116918.png

Finally we will get an Error Message.

/wp-content/uploads/2012/07/13_116920.png

There is a reason
behind this Error. You need to Configure the JAR file that is been defined in
the Database Connection needs to be pasted in two locations you may refer the Screenshot
below.

C:\Sybase\UnwiredPlatform\MobileSDK213\Unwired_WorkSpace\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.oracle_2.1.3.201205181305\lib

C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\lib\3rdparty

/wp-content/uploads/2012/07/14_116921.png

Once again try to create MBO.

/wp-content/uploads/2012/07/15_116922.png/wp-content/uploads/2012/07/16_116923.png

/wp-content/uploads/2012/07/17_116927.png

I hope this somehow useful to have an idea to how to crteate datasources.

thank you.

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Nishan Satharasinghe

    Hi SatyaMurthy ,

    I have a question with regrading the MBO being created.

    I can only see insert SQL in the MBO.

    So what would happend if we need to give command like delete , update from Client device?

    Do we have to have those SQLs defined in MBO?

    This is unclear as in sampledb all created automatically.

    Please share thoughts if you have gone through this situation.

    Many Thanks

    Nishan

    (0) 
    1. satya murthy Post author

      Hi Nishan,

      for non-sybase databases it cannot generate proper sql statements.

      manually we have to create operations for delete and update in mbo itself.

      Thanks&Regards

      SatyaMurthy

      (0) 
      1. Nishan Satharasinghe

        Hi SatyaMurthy,

        Many thanks for you reply.

        So load/select data operation would be generated automatically for non-syabase database?

        The point I am lost is the mapping between defined operations in MBO and how they used?

        For my understanding all operations defined in a MBO will available(and only) to Client API that uses to develop mobile side app . So literally when you call such an operation at client end (using the API lets say Object API)this will trigger the call to the MBO in Unwired server then to mapped data source SQL command.

        Please correct me if I have misunderstood the scenario.

        Many Thanks

        Nishan

        (0) 

Leave a Reply