Connection with MySQL

[Former Member]

Hi,

I am having an application which is having MySQL as its database back end. I am trying to connect that database with Sybase Unwired Platform(SUP2.1).

How can i do that?

Do i need to make connection/synchronization through SQL Anywhere with MySQL as it is a default available database with SUP.

Please suggest.

Regards,

Shrikant.

[Former Member]

Hi Shrikant,

If you want to access other database you will have to create database connection using enterprise explorer.

here i  mention the way how we can create the connection. it is depends on the workspace version.

right click on Database Connections from Enterprise Explorer->from the list of connection profile types choose which one you want ( oracle, SQL Server)->provide name for the connection->click on the icon for new deiver definition->it will open new driver definition wizard -> here you select the type of database,jar list and properties(userid,password,connection url,drivername, driver class)->click ok->you can test here whether the connection is successful or not->next->finish.

finally you will see the database icon in the database connections.

Thansks&Regards

Murthy

[Former Member]

Thanks Satya for the reply.

But there used to be no driver definitions for MySQL database in the enterprise explorer.

It used to have the database connection types as Oracle, MS SQL Server, DB2 & SQL Anywhere.

How can i create the connection for MySQL Database. If i need to define the new driver for this, then which driver should i define for it?

Please suggest.

Regards,

Shrikant.

[Former Member]

Hi,

You can use Generic JDBC. Select Generic JDBC and add MySQL Jar files to connect.

[Removed by Moderator]

Message was edited by: Michael Appleby

[Former Member]

Thanks Erhan.

I am putting my MySQL jar file to C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\lib\3rdparty.

Is it fine or should i define it in another location also.

Please suggest.

Regards,

Shrikant

[Former Member]

Ok Shrikant,

A small guide for you. You will jars from Sybase Unwired Workspace. (As I said previous replies)

[Former Member]

Yes Erhan, i am doing the same. But the where the problem i am facing is that i am unable to specify the MySQL driver file. I have downloaded a MySQL driver for JDBC connection from MYSQL site, but when i import it into the workspace as you mentioned in your previous reply, it does find the driver.class file into it.

I guess i am not having the correct MySQl driver/jar file for this. Please suggest me on this. If you have done this before then provide me the link from where i can download the correct drivers for MySQL.

Regards,

Shrikant

[Former Member]

Sorry but I dont have a MySQL Server. I have connected to a MSSQL.

[Former Member]

Is it possible to connect to MySQL server?

Connection with MS SQL server is possible. But is it possible to connect with MySQL server from SUP.

Regards,

Shrikant

[Former Member]

Why not?

[Former Member]

Hi,

Now as i have defined the driver files, i am able to connect to the MySQL db.

This is my configurations for MySQL\

But now when i am trying to create MBO using that i gets following error.

I guess i have to define few more properties/settings for the DB connection.

Is there something which i am missing?

Regards,

Shrikant

[Former Member]

Hi Shrikanth,

did you resolve this issue or not.

if not please add the jar file into the below path, this path will be change according to your SDK version.

<SUP installation root>\UnwiredPlatform\Unwired_WorkSpace\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.sqlserver_<version>.<plugin version number>\lib

if it is 2.1.3

C:\Sybase\UnwiredPlatform\MobileSDK213\Unwired_WorkSpace\sybase_workspace\mobile\eclipse\plugins\com.sybase.upe.com.sqlserver_2.1.3.xxxxxxxx

after placing the jar file you should close your workspace and open it again.

Pls let me know whether the problem exactly the same or not.

Thanks&Regards

SatyaMurthy

[Former Member]

Hi Shrikanth,

paste the same jar file in the below specified location also.

<SUP Installation root>\UnwiredPlatform\Servers\UnwiredServer\lib\3rdparty

Thanks&Regards

SatyaMurthy

[Former Member]

I am getting the same issue.

I did install the MySQL in test environment and followed the same steps but no luck

[Former Member]

Hi Nishan,

Please Check your your SQL Database is startup(mounted)   or not.

i have installed oracle 11g successfully and i aam able to connect database, but while creating the mbo i got above error, after i did some workaround i got success.

though it is not showing tables then i mounted my databse.

now i am successfully created MBO's.

Thanks&Regards

SatyaMurthy

[Former Member]

Hi SatyaMurthy,

Many thanks for your reply.

The connection is fine as I got the "ping" successful.

And MySQL server is startup too.

But still I don not get what you meant by "mount" here.

As you can see in my screen capture it still shows database too but missing is tables within it .

Many Thanks

Nishan

[Former Member]

HI nishan,

i have read this blog and understood you are able to connect to you MySql from the SUP , so the connection job is done from SUP the only thing you are unable to access the table presents in your database, that is something to do with database,

i believe like in SAP until we will not set BAPI/RFC property as expose to the external world we will not be able to access them even though you are successfully connected the SAP.

check is there any access table property has been set in your database.

prem