Web and WebWorks Development

[diego2k]

Hello,

following problem: A Blackberry App have to get Data(1) from a SQL Server, when the Blackbery get new Data it should ring(2) or someding ....

On the Blackberry some of the Data will be selected(3), this Data should come back(4) to the SQL Server.

What is the best technique to do this?

With a WebApp, it is not possible to meet point 3? In addition, thise function should only on the intranet reachable....

With a normal JAVA App how can i connect a SQL Server?

WebServices are the solution?

Whith the Blackberry Enterprise Server is it possible to lock functions?

These are many questions at once, but once I need a push in the right direction..

Thanks

[Xandrex]

do I understand your need correctly ?

you are developing an application for BlackBerry, that will interact between the BlackBerry device and a server in the intranet, that can be reached through the BES.

on the BlackBerry side, you want some kind of storage place (like a database)
the application will be able to read & write in that storage place
the application will be able to have SQL queries executed on an SQL server on the intranet

can you develop on server-side an application that will dialog with the application on the BlackBerry device ? That way you will have a regular communication client/server, and the server will then process all the dialog with the SQL server ?

[diego2k]

(SQLDB)-->ServerApp-->send Data(String) -->Blackberry

the user will see the data and confirm.
The confirmation will be sent back to the SQL Server.

(SqlDB)<--ServerAPP<--send Data(String) <--Blackberry

[Xandrex]

the easiest way is through a web server then. no need for a dedicated application on BlackBerry device side.