Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Native Development

Reply
New Contributor
gbelen
Posts: 2
Registered: ‎09-03-2012
My Device: Blackberry Bold 9700
My Carrier: Orange

How I connect my app to mysql database

Hi,

I trying to dev a blackberry app, but I need connect my app with an mysql database.

 

I have looked on all sides and I could not find how to develop an application for BlackBerry connected to a mysql database.

 

Can anyone help?

Thanks

Please use plain text.
Developer
obone
Posts: 162
Registered: ‎01-11-2012
My Device: BlackBerry 9790, BlackBerry PlayBook 64Gb, BlackBerry 10 Dev Alpha
My Carrier: MTS

Re: How I connect my app to mysql database

Hi gbelen,

Look at sqlite or qdb.
Respectfully,
Oleg

Developer, QNX RTOS, BlackBerry 10 and PlayBook
Follow me on Twitter (in Russian)
St.Petersburg BlackBerry Dev. Group
Please use plain text.
New Contributor
gbelen
Posts: 2
Registered: ‎09-03-2012
My Device: Blackberry Bold 9700
My Carrier: Orange

Re: How I connect my app to mysql database

Ok, I understand that sqlite is a solution but only local. I need connect a remote database. I read I need develop a web service.

 

I'll  try with it.

 

Thanks

Please use plain text.
Developer
obone
Posts: 162
Registered: ‎01-11-2012
My Device: BlackBerry 9790, BlackBerry PlayBook 64Gb, BlackBerry 10 Dev Alpha
My Carrier: MTS

Re: How I connect my app to mysql database

In this case you should use libmysqlclient or similar library.
Respectfully,
Oleg

Developer, QNX RTOS, BlackBerry 10 and PlayBook
Follow me on Twitter (in Russian)
St.Petersburg BlackBerry Dev. Group
Please use plain text.
BlackBerry Development Advisor (Retired)
mgoulet
Posts: 329
Registered: ‎05-07-2012
My Device: BB Alpha
My Carrier: N/A

Re: How I connect my app to mysql database

Hi there,

 

Welcome to the forums! Have you taken a look at the Quotes samples on the samples page?

It shows the use of a SQLDataAccess.

https://developer.blackberry.com/cascades/sampleapps/

 

Cheers,

 

Martin

 

Please use plain text.
Contributor
OzzyyzzO
Posts: 12
Registered: ‎09-10-2012
My Device: none
My Carrier: none

Where can be found libmysqlclient for BlackBerry 10 ?   A...

Where can be found libmysqlclient for BlackBerry 10 ?

 

Any precompiled library available ?

 

Did u succeed with your connection to a distant mySql server? 

Please use plain text.
Contributor
OzzyyzzO
Posts: 12
Registered: ‎09-10-2012
My Device: none
My Carrier: none

Re: How I connect my app to mysql database

This sample is for a local Db access not remote or i'm wrong?

 

Is it possible to use bb/data/SqlConnection for remote connections ?

 

doesn't seems to unfortunately. :-/

Please use plain text.
New Developer
MaxxJag
Posts: 78
Registered: ‎04-17-2011
My Device: BlackBerry Z10 LE
My Carrier: Bell

Re: How I connect my app to mysql database

You are correct, SqlDataAccess is for sqlite.

 

libmysqlclient doesn't have any precompiled version for BB10, you'd have to compile yourself a version and link it.

MaxxWares.com
Current apps:
-BBOS 10-
MaxxTransit - Coming soon
Please use plain text.