Re: Data Transfer Between Android and MySQL

[Dave Newton]

(Slightly more-complete answers.)

On Wed, Mar 2, 2016 at 3:07 PM, Paul Romero  wrote:

> One more important detail: The Android app. is not a browser.
>

That doesn't matter a whole lot.


> My general question is what is the best and most commonly deployed way
>>> to transfer data between a mobile Android based platform and a
>>> MySQL database on a Linux server ?
>>
>>
There is no "most-commonly deployed way". You could write it in pure Java,
use a framework, use NodeJS, use Rails, use Elixir/Phoenix, PHP, Perl,
whatever. Essentially endless.


> More specifically, is Struts a
>>> good choice or am I barking up the wrong tree ?
>>
>>
Depends. Do you have a lot of Java experience? Don't already have another
Java framework deployed (e.g., SpringMVC, Play, Grails)? Have the hardware
necessary to run it at the loads you're expecting?


> Also, it would be
>>> highly desirable to address the issue of binary data.
>>>
>>
Do you want to talk via sockets, or a web service?


> The aforementioned framework requires a "web service" to be implemented
>>> on the Linux server. My understanding is that such a "web service"
>>> executes PHP code, embedded in HTML, to perform MySQL operations, and
>>> converts MySQL responses to JSON format.
>>>
>>
Web services can be implemented in anything.

Dave

Re: Data Transfer Between Android and MySQL

[Paul Romero]

Hi Paul:

One more important detail: The Android app. is not a browser.

Best Regards,

Paul R.


On 03/02/2016 11:40 AM, Paul Benedict wrote:

Android is a remote client, and a web service is the common solution to
transfer data back to the host.

You are free to use whatever technology you want to implement the web
service. You have (1) message standard and (2) technology standard to
consider. The first are things like XML, SOAP, JSON, etc. The second are
products like Axis, Struts 2, JAX-WS, JAX-RS, etc. As David said, there are
no "best" answers in general; it's based on the best fit of your
requirements.

Cheers,
Paul

On Wed, Mar 2, 2016 at 1:29 PM, Paul Romero  wrote:


Dear Stuts Community:

My general question is what is the best and most commonly deployed way
to transfer data between a mobile Android based platform and a
MySQL database on a Linux server ?  More specifically, is Struts a
good choice or am I barking up the wrong tree ? Note that authentication
and security are essential in my case and my Android platform
uses SSL sockets for Internet connections. Also, it would be
highly desirable to address the issue of binary data.

It appears that the  RESTful/JSON framework is fairly common
way to achieve the functionality I described but I am not really
sure it is the best way and am certainly open to alternatives.

The aforementioned framework requires a "web service" to be implemented
on the Linux server. My understanding is that such a "web service"
executes PHP code, embedded in HTML, to perform MySQL operations, and
converts MySQL responses to JSON format.

I presume the "web service" can be implemented as a stand-alone module or
using Apache functionality.  (i.e. Examples are the Axis framework.) Is
this correct and which option can best achieve the functionality I have
described ?
Are there widely deployed modules or software that have this functionality
?
If not, what would be the easiest way to achieve this functionality ?

Best Regards,

Paul Romero

--


Paul Romero
---
RCOM Communications Software
EMAIL: pa...@rcom-software.com
PHONE: (510)482-2769







--


Paul Romero
---
RCOM Communications Software
EMAIL: pa...@rcom-software.com
PHONE: (510)482-2769

Re: Data Transfer Between Android and MySQL

[Paul Benedict]

Android is a remote client, and a web service is the common solution to
transfer data back to the host.

You are free to use whatever technology you want to implement the web
service. You have (1) message standard and (2) technology standard to
consider. The first are things like XML, SOAP, JSON, etc. The second are
products like Axis, Struts 2, JAX-WS, JAX-RS, etc. As David said, there are
no "best" answers in general; it's based on the best fit of your
requirements.

Cheers,
Paul

On Wed, Mar 2, 2016 at 1:29 PM, Paul Romero  wrote:

> Dear Stuts Community:
>
> My general question is what is the best and most commonly deployed way
> to transfer data between a mobile Android based platform and a
> MySQL database on a Linux server ?  More specifically, is Struts a
> good choice or am I barking up the wrong tree ? Note that authentication
> and security are essential in my case and my Android platform
> uses SSL sockets for Internet connections. Also, it would be
> highly desirable to address the issue of binary data.
>
> It appears that the  RESTful/JSON framework is fairly common
> way to achieve the functionality I described but I am not really
> sure it is the best way and am certainly open to alternatives.
>
> The aforementioned framework requires a "web service" to be implemented
> on the Linux server. My understanding is that such a "web service"
> executes PHP code, embedded in HTML, to perform MySQL operations, and
> converts MySQL responses to JSON format.
>
> I presume the "web service" can be implemented as a stand-alone module or
> using Apache functionality.  (i.e. Examples are the Axis framework.) Is
> this correct and which option can best achieve the functionality I have
> described ?
> Are there widely deployed modules or software that have this functionality
> ?
> If not, what would be the easiest way to achieve this functionality ?
>
> Best Regards,
>
> Paul Romero
>
> --
>
>
> Paul Romero
> ---
> RCOM Communications Software
> EMAIL: pa...@rcom-software.com
> PHONE: (510)482-2769
>
>
>
>
>

Re: Data Transfer Between Android and MySQL

[Dave Newton]

The options are essentially unlimited, both in and out of the JVM ecosystem.

What's "best" is more likely to be determined by the support resources you
have available.

On Wed, Mar 2, 2016 at 2:29 PM, Paul Romero  wrote:

> Dear Stuts Community:
>
> My general question is what is the best and most commonly deployed way
> to transfer data between a mobile Android based platform and a
> MySQL database on a Linux server ?  More specifically, is Struts a
> good choice or am I barking up the wrong tree ? Note that authentication
> and security are essential in my case and my Android platform
> uses SSL sockets for Internet connections. Also, it would be
> highly desirable to address the issue of binary data.
>
> It appears that the  RESTful/JSON framework is fairly common
> way to achieve the functionality I described but I am not really
> sure it is the best way and am certainly open to alternatives.
>
> The aforementioned framework requires a "web service" to be implemented
> on the Linux server. My understanding is that such a "web service"
> executes PHP code, embedded in HTML, to perform MySQL operations, and
> converts MySQL responses to JSON format.
>
> I presume the "web service" can be implemented as a stand-alone module or
> using Apache functionality.  (i.e. Examples are the Axis framework.) Is
> this correct and which option can best achieve the functionality I have
> described ?
> Are there widely deployed modules or software that have this functionality
> ?
> If not, what would be the easiest way to achieve this functionality ?
>
> Best Regards,
>
> Paul Romero
>
> --
>
>
> Paul Romero
> ---
> RCOM Communications Software
> EMAIL: pa...@rcom-software.com
> PHONE: (510)482-2769
>
>
>
>
>


-- 
e: davelnew...@gmail.com
m: 908-380-8699
s: davelnewton_skype
t: @dave_newton 
b: Bucky Bits 
g: davelnewton 
so: Dave Newton 

Data Transfer Between Android and MySQL

[Paul Romero]

Dear Stuts Community:

My general question is what is the best and most commonly deployed way
to transfer data between a mobile Android based platform and a
MySQL database on a Linux server ?  More specifically, is Struts a
good choice or am I barking up the wrong tree ? Note that authentication
and security are essential in my case and my Android platform
uses SSL sockets for Internet connections. Also, it would be
highly desirable to address the issue of binary data.

It appears that the  RESTful/JSON framework is fairly common
way to achieve the functionality I described but I am not really
sure it is the best way and am certainly open to alternatives.

The aforementioned framework requires a "web service" to be implemented
on the Linux server. My understanding is that such a "web service"
executes PHP code, embedded in HTML, to perform MySQL operations, and
converts MySQL responses to JSON format.

I presume the "web service" can be implemented as a stand-alone module or
using Apache functionality.  (i.e. Examples are the Axis framework.) Is
this correct and which option can best achieve the functionality I have 
described ?

Are there widely deployed modules or software that have this functionality ?
If not, what would be the easiest way to achieve this functionality ?

Best Regards,

Paul Romero

--


Paul Romero
---
RCOM Communications Software
EMAIL: pa...@rcom-software.com
PHONE: (510)482-2769

Re: Change ACCEPTED_PATTERN in CookieInterceptor

[Lukasz Lenart]

There is still few issues to resolve but it should be soon
https://issues.apache.org/jira/issues/?jql=project%20%3D%20WW%20AND%20fixVersion%20%3D%202.3.25%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%20due%20ASC%2C%20priority%20DESC%2C%20created%20ASC

2016-03-02 8:46 GMT+01:00 JOSE L MARTINEZ-AVIAL :
> Ah!!!, perfect, thanks. Any idea when that version will be available?
>
> thanks
>
> JL
>
> 2016-03-02 2:19 GMT-05:00 Lukasz Lenart :
>
>> Ah... it's resolved ;-)
>>
>> See https://issues.apache.org/jira/browse/WW-4563
>> and https://issues.apache.org/jira/browse/WW-4560
>>
>> basically you must wait for 2.3.25
>>
>> 2016-03-02 8:17 GMT+01:00 JOSE L MARTINEZ-AVIAL :
>> > Hello Lukasz,
>> >Actually, the issue I have is with isAcceptableValue for the cookie
>> > value, not with the name. For reasons the name of the cookie I'm
>> interested
>> > in is variable, so I use CookieAware, and then lookup in the map for the
>> > cookie I'm interested in. The name of the cookie is plain, and it goes
>> > through isAcceptableName without issue, but the value does not pass the
>> > isAcceptableValue, since the regular expression does not allow for %.
>> And I
>> > would like to change that behaviour, but without affecting
>> > ParametersInterceptor.
>> >
>> >   So far, what I've done is to extend the interceptor and change the
>> > regular expression by doing:
>> >
>> > private static final String ACCEPTED_PATTERN =
>> > "[a-zA-Z0-9\\.\\]\\[_'\\s%]+";
>> > @Inject
>> > public void setAcceptedPatternsChecker(AcceptedPatternsChecker
>> > acceptedPatternsChecker) {
>> > super.setAcceptedPatternsChecker(acceptedPatternsChecker);
>> > acceptedPatternsChecker.setAcceptedPatterns(ACCEPTED_PATTERN);
>> > }
>> >
>> > So I override the default ACCEPTED_PATTERN with my own. But I really
>> would
>> > like to be able to do the override by configuration, and not have to
>> extend
>> > the class. And would be great to be able to do it separately for names
>> and
>> > values.
>> >
>> > JL
>> >
>> > 2016-03-02 1:28 GMT-05:00 Lukasz Lenart :
>> >
>> >> 2016-03-01 20:14 GMT+01:00 JOSE L MARTINEZ-AVIAL :
>> >> > Hello,
>> >> >I have an issue with Strus 2.3.24.1 where my cookies are not being
>> >> > accepted and populated to the action because the regular expression
>> for
>> >> the
>> >> > values does not admit the character %. I'm trying to override the
>> regular
>> >> > expression, but is not clear how that can be done thorugh the
>> >> configuration
>> >> > file. The only option seems to be extending the interceptor. Is that
>> >> > correct?
>> >>
>> >> You are right, it isn't documented but you must investigate the code :\
>> >>
>> >> You have two options, use the below constants (the naming is obvious),
>> >> they accept comma separated RegExs
>> >>
>> >> struts.override.excludedPatterns
>> >> struts.override.acceptedPatterns
>> >>
>> >> struts.additional.excludedPatterns
>> >> struts.additional.acceptedPatterns
>> >>
>> >> but setting these constants will also affect ParametersInterceptor
>> >> which can be dangerous as you want to allow %.
>> >>
>> >> Second option is to use 'acceptCookieNames' parameter (as well comma
>> >> separated RegExs) but this probably won't be enough as you cannot
>> >> override excluded patterns in the same way. What about defining
>> >> 'excludeCookieNames' parameter to override exclude patterns? Then it
>> >> will be available in 2.3.25
>> >>
>> >>
>> >> Regards
>> >> --
>> >> Łukasz
>> >> + 48 606 323 122 http://www.lenart.org.pl/
>> >>
>> >> -
>> >> To unsubscribe, e-mail: user-unsubscr...@struts.apache.org
>> >> For additional commands, e-mail: user-h...@struts.apache.org
>> >>
>> >>
>>
>> -
>> To unsubscribe, e-mail: user-unsubscr...@struts.apache.org
>> For additional commands, e-mail: user-h...@struts.apache.org
>>
>>

-
To unsubscribe, e-mail: user-unsubscr...@struts.apache.org
For additional commands, e-mail: user-h...@struts.apache.org