MySQL and connection @ test environment?

[Former Member]

Hi,

I did install MySQL in 30 days trial environment and now I want to make a connection for my database .

I did download the JDBC driver and add to the server 3rdparty lib too.

Please refer to attached image.

Many Thanks

Nishan

[Former Member · Accepted solution]

Hi Nishan,

Pls click on Test Button, if you are getting the ping success msg then check your database startup mode.

Thanks&Regards

SatyaMurthy.

[Former Member · Accepted solution]

Hi SatyaMurthy,

MAny thanks for you reply .

As you can see above databse server instance is running (I beleive this is what you meant ) but still I do not see any tables in Enterprise Explorer

MAny Thanks

Nishan

[Former Member · Accepted solution]

Hi Nishan,

i dont have any idea on mysql server,mine is oracle 11g.

i feel same can be applied for mysql server also.

let me try with mysql, give me some time.

Thanks&Regards

SatayaMurthy

[Former Member · Accepted solution]

Hi Nishan,

could you please provide mysql details.

like version, and where to download.

Thanks&Regards

SatyaMurthy.

[Former Member · Accepted solution]

Hi SatyaMurti,  Much appriciate Your help.  Please find below link   http://www.mysql.com/downloads/  Many Thanks Nishan

[Former Member · Accepted solution]

Hi Nishan,

i have installed successfully, i am  getting schemas and  tables also but without columns.

something we need to configure in database level.

i am not having any idea on mysql server, i am confusing with navigation.

i am checking the same.

Thanks&Regards

SatyaMurthy

[Former Member · Accepted solution]

Hi SatyaMurthy,

Much appreciate your support.

For a change I tried DB2 too . Please refer below screen capture

The connection fine. And I can see tables and columns too. But when I drag to the area to create MBO , I am getting this error in image.

Do we have to do any other thing apart form making the connection to get MBOs form a source?

Many Thanks

Nishan

[Former Member · Accepted solution]

Hi Nishan,

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

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

after placing the jar files we should restart workspace.

Thanks&Regards

SatyaMurthy

[Former Member · Accepted solution]

Hi SatyaMurthy,

Thanks again for your support.

I copied the jar file to both locations and did restart the workspace , but still getting the same issue.

Just to double confirm when we make the connection to which location of jar we should point to ? I did my case to the location of C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\lib\3rdparty/db2jcc.jar

And it will be great if we could let me know from where did you find this info regarding placing jar files( a link to that source )

Many Thanks

Nishan

[Former Member · Accepted solution]

Hi Nishan,

i am sure nishan, above error was because of missing of jar files only. all the posible ways i have tested. In my case i have tested from both the locations.

my oracle installation path is in e drive.

it is pinging success.

did you copy all jar files from this db2JdbcJars.zip file.(db2jcc.jar and db2jcc_license_cu.jar etc..)

Thanks&Regards

SatyaMurthy

[Former Member · Accepted solution]

Hi SatyaMurthy,

Fantastic ! It resolved the issue. Many thanks , appreciate your help!

Could you please let me know the information resource you found this information.?

Many Thanks

Nishan

[Former Member · Accepted solution]

Hi Nishan,

Thank you very much.

my information resource is internet and sybase online help.

Thanks&Regards

SatyaMurthy

[Former Member · Accepted solution]

Hi Nishan Satharasinghe,

Can you post all the steps that you did in order to connect to the mySQL database and in order to be able to create a MBO (in a manual manner) after connecting with the database.

I would appreciate it.

Best Regards,

Ricardo

[Jitendra_Kansal · Accepted solution]

Ricardo Pires

you can check below link

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

Regrds,

Jitendra