Question Re: Connection with MySQL in Technology Q&A

Connection with MySQL

Former Member — Mon, 11 Jun 2012 06:35:41 GMT

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.

Re: Connection with MySQL

Former Member — Mon, 11 Jun 2012 11:37:25 GMT

Hi,

You can create conntection to your MySQL db under Sybase Unwired Workspace -> Enterprise Explorer -> Database Connections. I think you should check documents about SUP.

[Removed by Moderator]

Message was edited by: Michael Appleby

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 04:58:29 GMT

Hi Erhan,

I have gone through the docs for SUP 2.1. But i didn't find any specific information regarding MySQL connection. I am assuming that i need to import some drivers for the MySQL database in the SUP installation directories. Is that all needed. Can you suggest me what else i am missing?

If you can provide me any reference link that will be really helpful.

Regards,

Shrikant.

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 05:06:19 GMT

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

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 05:22:52 GMT

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.

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 06:07:01 GMT

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

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 06:27:40 GMT

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

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 06:45:07 GMT

Ok Shrikant,

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

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 07:02:03 GMT

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

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 07:05:11 GMT

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

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 07:10:23 GMT

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

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 07:14:01 GMT

Why not?

Re: Connection with MySQL

Former Member — Tue, 12 Jun 2012 09:37:12 GMT

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

Re: Connection with MySQL

Former Member — Fri, 06 Jul 2012 11:17:27 GMT

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

Re: Connection with MySQL

Former Member — Fri, 06 Jul 2012 11:24:26 GMT

Hi Shrikanth,

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

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

Thanks&Regards

SatyaMurthy

Re: Connection with MySQL

Former Member — Fri, 06 Jul 2012 16:22:20 GMT

I am getting the same issue.

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

Re: Connection with MySQL

Former Member — Sat, 07 Jul 2012 12:20:20 GMT

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

Re: Connection with MySQL

Former Member — Sat, 07 Jul 2012 12:46:03 GMT

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

Re: Connection with MySQL

Former Member — Mon, 09 Jul 2012 13:07:53 GMT

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

Re: Connection with MySQL

Former Member — Fri, 26 Apr 2013 15:10:09 GMT

Hello All,

I created a connection profile to connect MySQL server and able to connect successfully. But I'm unable to see the existing tables. Can some one help me on this issue.

Thanks
Pavan