Skip to Content

Creating a Oracle Data Source Connection

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.

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