BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 11-24-2009, 08:22 AM   #1 (permalink)
New Member
 
Join Date: Feb 2009
Model: 8820
PIN: N/A
Carrier: Airtel India
Posts: 10
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question can we use BES for data other than email, calendar etc

Please Login to Remove!

Hi,

I want to make an application which uses SQL Server Database. and I want to connect to database directly from Blackberry application with any middle-ware interfaces like HTTP pages processing for data transfer.

Can I use BES for this purpose.If yes how.

I have gone through some pages for BES but couldn't come to know , will it work with other data than email, calendar, backup etc.
Offline  
Old 11-24-2009, 08:28 AM   #2 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Post Thanks: 20
Thanked 77 Times in 68 Posts
Default

Yes it will. By default a Blackberry activated on a BES has access to the network that the BES resides on.

Code:
(StreamConnection) Connector.open("socket://<host>:<port>");
will open a socket connection the the host and port specified, the host will be resolved by the machine running the BES. This kind of communication constitutes the bulk of my development work and is what really sets the Blackberry platform completely apart from iPhone, Android, Windows Mobile, etc.
__________________
My other Blackberry is a PlayBook.
Offline  
Old 11-24-2009, 09:28 AM   #3 (permalink)
New Member
 
Join Date: Feb 2009
Model: 8820
PIN: N/A
Carrier: Airtel India
Posts: 10
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks hrbuckley for quick reply.

But now I have few more questions.

The streamconnection I can open from Java Midlet application also. And I think I can open for any server, not only BES.

It will be very wrong way if I use the steramconnection to SQL Server port and send all queries and receive resultset response.

I want secure and easy way to access the SQL Server directly from Blackberry.
Offline  
Old 11-24-2009, 09:49 AM   #4 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2008
Location: Austin, TX
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 1,644
Post Thanks: 0
Thanked 34 Times in 33 Posts
Default

You'll need to provide some middleware to accept the client request, make the SQL query, and return the result.

We do this with HTTP POST to a PHP script, returning an XML document with the data payload.

Others use KSOAP to make a SOAP web-service request.

It really all hinges on what server-side infrastructure you have.

Last edited by Dougsg38p : 11-24-2009 at 09:50 AM.
Offline  
Old 11-24-2009, 11:32 AM   #5 (permalink)
New Member
 
Join Date: Feb 2009
Model: 8820
PIN: N/A
Carrier: Airtel India
Posts: 10
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you Dougsg38p .

That is quite usual way to use database from any mobile application by adding middleware. I wanted to use BES instead of it, as BES can directly access the SQL server.

And as per my understanding , you can access BES directly from application.

The difference is I will get extra security feature provided by Blackberry.
Offline  
Old 11-24-2009, 01:08 PM   #6 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2008
Location: Austin, TX
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 1,644
Post Thanks: 0
Thanked 34 Times in 33 Posts
Default

I think you are referring to MDS, which is a different deal altogether.

MDS is a RAD tool that allows you to create quick & dirty client programs. This also requires the MDS runtime on your device.

I'm no expert on this, but I think you need to look at the MDS Studio development - not Java development. However, I believe I heard that this tool is being withdrawn from the market.


BlackBerry - End of life notice for BlackBerry MDS Runtime and BlackBerry MDS Studio
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.