Re: [android-developers] Re: Transactions in a ContentProvider
On Sat, Nov 5, 2011 at 10:29 AM, Kostya Vasilyev wrote: > The way it works is: > > getContentResolver().notifyChange(, null); > > Same as when the above line of code is inside CP.. :: smacks forehead :: Never thought of calling that outside the CP. Thanks! -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Warescription: Three Android Books, Plus Updates, One Low Price! -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Transactions in a ContentProvider
The way it works is: getContentResolver().notifyChange(, null); Same as when the above line of code is inside CP.. -- Kostya 05.11.2011 18:21, Mark Murphy пишет: Um, I'm not sure how that works. If you insert a row in the DB directly, the CP will not be notified via the ContentObserver. -- Kostya Vasilyev -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Transactions in a ContentProvider
On Sat, Nov 5, 2011 at 10:13 AM, Kostya Vasilyev wrote: > 2) Serve data to the UI via a CP, to leverage Android's notificaitons. > Nothing changes here, no need for broadcast receivers. Perform other > operations bypassing the CP, dealing directly with the DB. Um, I'm not sure how that works. If you insert a row in the DB directly, the CP will not be notified via the ContentObserver. > Another thought is this: a CP URI doesn't have to be mapped one to one to a > particular table. A CP implementation can work with multiple tables inside a > single ContentResolver.() call made by a client, > and can wrap them in a DB transaction. > > So that's another path to take, if you really want to always access all your > data through a CP: put the logic of mapping between logical entires and > tables inside the CP, treating CP operations as dealing with logical > entities rather than tables. In this respect, using a CP is not too dissimilar from creating a REST-based server. Just as the REST URL patterns may not line up 1-to-1 with tables, the CP Uri patterns do not have to line up 1-to-1 with tables. CPs are not as flexible, though, since you're stuck with a flat ContentValues as your data structure. Also, if you use content providers, be sure to mark your ContentProvider as *NOT EXPORTED* in the manifest (android:exported="false"), as it is exported by default, meaning your data is wide open for anyone to access and manipulate. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Warescription: Three Android Books, Plus Updates, One Low Price! -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Transactions in a ContentProvider
1) Yes, that's exactly what I'm talking about 2) Serve data to the UI via a CP, to leverage Android's notificaitons. Nothing changes here, no need for broadcast receivers. Perform other operations bypassing the CP, dealing directly with the DB. 3) Not sure what you mean - if threading, SQLiteDatabase is thread safe. 4) Is there a one to one mapping between your REST and data URIs to worry about this? I thought not, your prior messages explicitly mention multiple database operations per one logical entity. Another thought is this: a CP URI doesn't have to be mapped one to one to a particular table. A CP implementation can work with multiple tables inside a single ContentResolver.() call made by a client, and can wrap them in a DB transaction. So that's another path to take, if you really want to always access all your data through a CP: put the logic of mapping between logical entires and tables inside the CP, treating CP operations as dealing with logical entities rather than tables. -- Kostya 05.11.2011 17:36, Flávio Faria пишет: I prefer using ContentProviders for the following reasons: 1) I'll have my activities handling my cursors on their lifecycles themselves; 2) It's easier to implement an MVP pattern with the help of ContentObservers notifying the UI; 3) ContentProviders synchronize database accesses for me; 4) ContentProviders address resources by URI, as well as REST implementations do, so i can easily map them. If I take your suggestion: 1) will be OK if I have a simple CP exposing my entities by query(); 2) I'll have to use BroadcastReceivers to simulate ContentObservers (solves the problem, but looks messy); 3) I'll have to synchronize database accesses myself; 4) I'll have to implement all the local URI addressing logic for my solution. I thought that implementing this kind of architecture was a simple problem that many people had already gone through. On the other hand, I'm still looking for implementation examples or in-depth explanations complementing that IO talk. On Nov 4, 4:27 pm, Kostya Vasilyev wrote: Not sure what CP's have to do with REST... My recommendation still stands - implement your own data access classes that directly deal with a SQliteDatabase. Make them as simple or as complex as you wish - from calling SQLiteDatabase directly to an abstract object/database mapper. Then layer a CP on top of this database - if you need one. If you're not going to expose your data to other apps with a CP, then the only reason to use a CP, as far I'm concerned, is to leverage Android's built-in URI-based data change notification mechanism to more easily sync the UI, and first of all, list views, with data updates. It's still a good reason -- but it's much easier to implement a small CP with query() just for the URIs you need in the UI, than to bottleneck all your internal entity-changing logic through CP/CR interfaces. -- Kostya 04.11.2011 23:38, Flávio Faria пишет: Thanks Kostya, Actually, I don't need to expose my data. I'm using a ContentProvider because I'm trying to implement the REST architecture suggested by Virgil Dobjanschi on Google I/O: http://www.google.com/events/io/2010/sessions/developing-RESTful-andr... Though, I have complex entities in a normalized database, so I need transactions in order to insert parts of a single entity on their respective tables and do some data validation (say queries) between these insert operations. Is there a better solution for that? -- Kostya Vasilyev -- Kostya Vasilyev -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in a ContentProvider
I prefer using ContentProviders for the following reasons: 1) I'll have my activities handling my cursors on their lifecycles themselves; 2) It's easier to implement an MVP pattern with the help of ContentObservers notifying the UI; 3) ContentProviders synchronize database accesses for me; 4) ContentProviders address resources by URI, as well as REST implementations do, so i can easily map them. If I take your suggestion: 1) will be OK if I have a simple CP exposing my entities by query(); 2) I'll have to use BroadcastReceivers to simulate ContentObservers (solves the problem, but looks messy); 3) I'll have to synchronize database accesses myself; 4) I'll have to implement all the local URI addressing logic for my solution. I thought that implementing this kind of architecture was a simple problem that many people had already gone through. On the other hand, I'm still looking for implementation examples or in-depth explanations complementing that IO talk. On Nov 4, 4:27 pm, Kostya Vasilyev wrote: > Not sure what CP's have to do with REST... > > My recommendation still stands - implement your own data access classes > that directly deal with a SQliteDatabase. Make them as simple or as > complex as you wish - from calling SQLiteDatabase directly to an > abstract object/database mapper. > > Then layer a CP on top of this database - if you need one. > > If you're not going to expose your data to other apps with a CP, then > the only reason to use a CP, as far I'm concerned, is to leverage > Android's built-in URI-based data change notification mechanism to more > easily sync the UI, and first of all, list views, with data updates. > > It's still a good reason -- but it's much easier to implement a small CP > with query() just for the URIs you need in the UI, than to bottleneck > all your internal entity-changing logic through CP/CR interfaces. > > -- Kostya > > 04.11.2011 23:38, Flávio Faria пишет: > > > Thanks Kostya, > > > Actually, I don't need to expose my data. I'm using a ContentProvider > > because I'm trying to implement the REST architecture suggested by > > Virgil Dobjanschi on Google I/O: > > >http://www.google.com/events/io/2010/sessions/developing-RESTful-andr... > > > Though, I have complex entities in a normalized database, so I need > > transactions in order to insert parts of a single entity on their > > respective tables and do some data validation (say queries) between > > these insert operations. Is there a better solution for that? > > -- > Kostya Vasilyev -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Transactions in a ContentProvider
Not sure what CP's have to do with REST... My recommendation still stands - implement your own data access classes that directly deal with a SQliteDatabase. Make them as simple or as complex as you wish - from calling SQLiteDatabase directly to an abstract object/database mapper. Then layer a CP on top of this database - if you need one. If you're not going to expose your data to other apps with a CP, then the only reason to use a CP, as far I'm concerned, is to leverage Android's built-in URI-based data change notification mechanism to more easily sync the UI, and first of all, list views, with data updates. It's still a good reason -- but it's much easier to implement a small CP with query() just for the URIs you need in the UI, than to bottleneck all your internal entity-changing logic through CP/CR interfaces. -- Kostya 04.11.2011 23:38, Flávio Faria пишет: Thanks Kostya, Actually, I don't need to expose my data. I'm using a ContentProvider because I'm trying to implement the REST architecture suggested by Virgil Dobjanschi on Google I/O: http://www.google.com/events/io/2010/sessions/developing-RESTful-android-apps.html Though, I have complex entities in a normalized database, so I need transactions in order to insert parts of a single entity on their respective tables and do some data validation (say queries) between these insert operations. Is there a better solution for that? -- Kostya Vasilyev -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in a ContentProvider
Thanks Kostya,
Actually, I don't need to expose my data. I'm using a ContentProvider
because I'm trying to implement the REST architecture suggested by
Virgil Dobjanschi on Google I/O:
http://www.google.com/events/io/2010/sessions/developing-RESTful-android-apps.html
Though, I have complex entities in a normalized database, so I need
transactions in order to insert parts of a single entity on their
respective tables and do some data validation (say queries) between
these insert operations. Is there a better solution for that?
On Nov 4, 2:42 pm, Kostya Vasilyev wrote:
> My two cents: don't go through your own ContentProvider unless you need to.
>
> Use ContentProvider for exporting data to other apps, or, within the
> app, for very specific URIs that should trigger UI updates.
>
> For the rest of the data, that is, those db ops that don't need to
> trigger UI updates, going directly to the database APIs gives better
> flexibility, performance, and control (wrt. change notifications).
>
> -- Kostya
>
> 04.11.2011 20:36, Pepijn Van Eeckhoudt пишет:
>
>
>
>
>
>
>
>
>
> > Override ContentProvider#applyBatch, start a transaction on your
> > database, apply all the operations and then commit (or rollback) the
> > transaction. The default implementation delegates each operation to
> > the corresponding ContentProvider method so you can probably do this as:
>
> > startTransaction
> > try {
> > super.applyBatch
> > setTransactionSuccesful
> > } finally {
> > endTransaction
> > }
>
> > Pepijn
>
> > On 03/11/2011 20:59, Flávio Faria wrote:
> >> Hi guys,
>
> >> I have a ContentProvider in my app that wraps an SQLite database. I'm
> >> wondering what is the best way to call insert(), update(), delete()
> >> and query() inside a database transaction. Is it possible? Is there
> >> any workaround? bulkInsert() doesn't help since it only makes insert()
> >> calls.
>
> >> Thanks.
>
> --
> Kostya Vasilyev
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in a ContentProvider
Thanks Pepjin,
Unfortunately, Im targeting Android 1.6, so it's not possible to use
ContentProviderOperations...
On Nov 4, 2:36 pm, Pepijn Van Eeckhoudt
wrote:
> Override ContentProvider#applyBatch, start a transaction on your
> database, apply all the operations and then commit (or rollback) the
> transaction. The default implementation delegates each operation to the
> corresponding ContentProvider method so you can probably do this as:
>
> startTransaction
> try {
> super.applyBatch
> setTransactionSuccesful
>
> } finally {
> endTransaction
> }
>
> Pepijn
>
> On 03/11/2011 20:59, Fl vio Faria wrote:
>
>
>
>
>
>
>
> > Hi guys,
>
> > I have a ContentProvider in my app that wraps an SQLite database. I'm
> > wondering what is the best way to call insert(), update(), delete()
> > and query() inside a database transaction. Is it possible? Is there
> > any workaround? bulkInsert() doesn't help since it only makes insert()
> > calls.
>
> > Thanks.
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in a ContentProvider
On Nov 3, 3:59 pm, Flávio Faria wrote: > Hi guys, > > I have a ContentProvider in my app that wraps an SQLite database. I'm > wondering what is the best way to call insert(), update(), delete() > and query() inside a database transaction. Is it possible? Is there > any workaround? bulkInsert() doesn't help since it only makes insert() > calls. > > Thanks. Check out the beginTransaction(), setTransactionSuccessful(), and endTransaction() methods described at http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html. - Dave -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
I have some orders that are authorized but not charged. One goes back 10 days, and according to the notes on it, the authorization has expired by now. Do those of you who have experience with this know what this means? Did the customer get the app, but I/google don't get the payment? Haven't been in the market too long, but just want to get an idea what the deal is. thanks -- -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Yup, looks like its just a matter of catching up now. Seems like about 90% of my sales have cleared. -Gregg On Apr 26, 7:44 pm, Nathan Roy wrote: > About 50% of my transactions have now cleared. > > Looks like the problem may be resolved :) > > On Apr 26, 1:14 pm, Kostya Vasilyev wrote: > > > They started clearing again for me within the last 3-4 hours. So far > > it's only one in 20 or so, and not in any particular order, but it's > > starting to move. > > > -- Kostya > > > 26.04.2011 21:08, Nathan Roy пишет: > > > > Just for the record, sales are still going through, and people are > > > able to download the app, so Spiderfly's issue isn't pertaining to me, > > > but no transactions have cleared still since 2PM on the 24th of April. > > > > Not good. > > > > On Apr 25, 9:54 pm, Spiderfly Studios > > > wrote: > > >> Getting the same here. Sales have slowed. Users are giving my app 1 > > >> star and angry comments. This is ridiculous! If Google is going to > > >> do maintenance or if there is something going on that is preventing > > >> payment processing, then they should let us know. Now I have a bunch > > >> of users who want the app, but the payments won't process and the app > > >> won't install. > > > -- > > Kostya Vasilyev --http://kmansoft.wordpress.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
About 50% of my transactions have now cleared. Looks like the problem may be resolved :) On Apr 26, 1:14 pm, Kostya Vasilyev wrote: > They started clearing again for me within the last 3-4 hours. So far > it's only one in 20 or so, and not in any particular order, but it's > starting to move. > > -- Kostya > > 26.04.2011 21:08, Nathan Roy пишет: > > > Just for the record, sales are still going through, and people are > > able to download the app, so Spiderfly's issue isn't pertaining to me, > > but no transactions have cleared still since 2PM on the 24th of April. > > > Not good. > > > On Apr 25, 9:54 pm, Spiderfly Studios > > wrote: > >> Getting the same here. Sales have slowed. Users are giving my app 1 > >> star and angry comments. This is ridiculous! If Google is going to > >> do maintenance or if there is something going on that is preventing > >> payment processing, then they should let us know. Now I have a bunch > >> of users who want the app, but the payments won't process and the app > >> won't install. > > -- > Kostya Vasilyev --http://kmansoft.wordpress.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Transactions in android market not clearing?
They started clearing again for me within the last 3-4 hours. So far it's only one in 20 or so, and not in any particular order, but it's starting to move. -- Kostya 26.04.2011 21:08, Nathan Roy пишет: Just for the record, sales are still going through, and people are able to download the app, so Spiderfly's issue isn't pertaining to me, but no transactions have cleared still since 2PM on the 24th of April. Not good. On Apr 25, 9:54 pm, Spiderfly Studios wrote: Getting the same here. Sales have slowed. Users are giving my app 1 star and angry comments. This is ridiculous! If Google is going to do maintenance or if there is something going on that is preventing payment processing, then they should let us know. Now I have a bunch of users who want the app, but the payments won't process and the app won't install. -- Kostya Vasilyev -- http://kmansoft.wordpress.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Just for the record, sales are still going through, and people are able to download the app, so Spiderfly's issue isn't pertaining to me, but no transactions have cleared still since 2PM on the 24th of April. Not good. On Apr 25, 9:54 pm, Spiderfly Studios wrote: > Getting the same here. Sales have slowed. Users are giving my app 1 > star and angry comments. This is ridiculous! If Google is going to > do maintenance or if there is something going on that is preventing > payment processing, then they should let us know. Now I have a bunch > of users who want the app, but the payments won't process and the app > won't install. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Getting the same here. Sales have slowed. Users are giving my app 1 star and angry comments. This is ridiculous! If Google is going to do maintenance or if there is something going on that is preventing payment processing, then they should let us know. Now I have a bunch of users who want the app, but the payments won't process and the app won't install. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Same here. Nothing processed since yesterday. There is also a thread on Google Checkout Merchant help forum. http://www.google.com/support/forum/p/checkout-merchants/thread?tid=7bdc30064117bd02&hl=en On 25 abr, 16:17, Gregg Reno wrote: > I was wondering why the payout from 4/24 was lower than it should > based on the number of sales. But it looks like transactions since > about 9:00 pm EDT on 4/24 haven't cleared. Is anyone else noticing > this? (Grey circles in the charge and ship columns in the Orders tab) > > -Gregg -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Yep. Same here. Though, cancellations and rejected payments show up correctly. On Apr 26, 12:35 am, Kostya Vasilyev wrote: > Mine are just stuck. > > The last order to clear was from "Apr 25, 2011 1:33:52 AM GMT+01. > > The next order in line is from "Apr 25, 2011 2:38:35 AM GMT+01:00" - and > it and all the others after it are stuck. > > -- Kostya > > 26.04.2011 5:21, Zsolt Vasvari пишет: > > > Not only have they not cleared, the ones that had cleared earlier have > > been uncleared... > > > On Apr 26, 6:09 am, String wrote: > >> Hmmm, for me it's every transaction since about 1am GMT today (April 25). > >> Let's hope somebody at Google notices and plugs that server back in. > > >> String > > -- > Kostya Vasilyev --http://kmansoft.wordpress.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Transactions in android market not clearing?
Mine are just stuck. The last order to clear was from "Apr 25, 2011 1:33:52 AM GMT+01. The next order in line is from "Apr 25, 2011 2:38:35 AM GMT+01:00" - and it and all the others after it are stuck. -- Kostya 26.04.2011 5:21, Zsolt Vasvari пишет: Not only have they not cleared, the ones that had cleared earlier have been uncleared... On Apr 26, 6:09 am, String wrote: Hmmm, for me it's every transaction since about 1am GMT today (April 25). Let's hope somebody at Google notices and plugs that server back in. String -- Kostya Vasilyev -- http://kmansoft.wordpress.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
looks like I'm gonna have 0 sales for today, not good, not good. On Apr 25, 6:35 pm, Gregg Reno wrote: > Still no change. None of the purchases have cleared for me since last > night. > - Gregg > > On Apr 25, 9:21 pm, Zsolt Vasvari wrote: > > > > > > > > > Not only have they not cleared, the ones that had cleared earlier have > > been uncleared... > > > On Apr 26, 6:09 am, String wrote: > > > > Hmmm, for me it's every transaction since about 1am GMT today (April 25). > > > Let's hope somebody at Google notices and plugs that server back in. > > > > String -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Still no change. None of the purchases have cleared for me since last night. - Gregg On Apr 25, 9:21 pm, Zsolt Vasvari wrote: > Not only have they not cleared, the ones that had cleared earlier have > been uncleared... > > On Apr 26, 6:09 am, String wrote: > > > > > Hmmm, for me it's every transaction since about 1am GMT today (April 25). > > Let's hope somebody at Google notices and plugs that server back in. > > > String -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Not only have they not cleared, the ones that had cleared earlier have been uncleared... On Apr 26, 6:09 am, String wrote: > Hmmm, for me it's every transaction since about 1am GMT today (April 25). > Let's hope somebody at Google notices and plugs that server back in. > > String -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Hmmm, for me it's every transaction since about 1am GMT today (April 25). Let's hope somebody at Google notices and plugs that server back in. String -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Yup... not for every sale, but the frequency has increased a noticeable amount. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions in android market not clearing?
Yes I have noticed this as well. It's been happening to me since the 24'th On Apr 25, 10:17 am, Gregg Reno wrote: > I was wondering why the payout from 4/24 was lower than it should > based on the number of sales. But it looks like transactions since > about 9:00 pm EDT on 4/24 haven't cleared. Is anyone else noticing > this? (Grey circles in the charge and ship columns in the Orders tab) > > -Gregg -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions
Now it looks much easier for me, thx a lot
Honza
On 18 lis, 15:29, Daniel Drozdzewski
wrote:
> On Thu, Nov 18, 2010 at 2:13 PM, biokys wrote:
> > Hi Daniel,
> > thx for your post
> > my goal is to make data sharing among any users so they can store
> > their information locally in SQLite (in case of no network connection)
> > and when they want, they can synchronize these datas with central
> > datastore (Google app engine). so i assume, that transactional
> > behavior is not crucial in this case, but can be handy.
>
> > Honza
>
> Hey Honza,
>
> That is true, you don't need a transaction that would span both interactions.
> It would be 2 separate transactions, or to be precise 1 local
> transaction and server upload would be the best effort kind of thing,
> with the assumption that it will eventually work at some point in the
> future (could be quite distant future in terms of transactions).
>
> All you have to do is to have some sort of time stamp attached to the
> data in both places and the server routine will ask only mobile for
> the data since its latest time stamp.
>
> --
> Daniel
>
>
>
>
>
>
>
>
>
>
>
> > On 18 lis, 14:47, Daniel Drozdzewski
> > wrote:
> >> On Thu, Nov 18, 2010 at 1:05 PM, biokys wrote:
> >> > Hi, I am trying to find out, how to store data in a local DB and
> >> > remotely over HTTP in one transaction. Does exist any native mechanism
> >> > in Android phone for transactional behavior?
>
> >> > Thx Honza
>
> >> Honza,
>
> >> Short answer is: I don't think so.
> >> In order to achieve this, you would need to look at Distributed
> >> Transaction Coordinators, if you require full transactionality.
>
> >> Java EE has JTA (Java Transaction API) but it's not present on mobile
> >> platforms. To achieve this it relies on few very crucial things:
> >> - JDBC 2.0 drivers for each data source you need in your distributed
> >> transaction that actually implements XADataSource and XADataConnection
> >> - JEE Application Server
>
> >> Android API mentions XADataSource and XAConnection, just have a look
> >> at javax.sql.DataSource documentation, but there is nothing else. I am
> >> pretty sure that SQLite does not support such mechanisms, but I could
> >> be wrong.
>
> >> You can try doing it the garage way:
>
> >> db.beginTransaction();
> >> try {
> >> //send data to SQLite
> >> //send data to external service
> >> db.setTransactionSuccessful();
> >> } catch (SQLException) {
> >> //error in DB: contact the server to revert the commit and hope
> >> it will do it
> >> } catch (IOException) {
> >> //error with the external server, and you have no guarantee,
> >> whether it has been written or not
> >> } finally {
> >> db.endTransaction();
> >> }
>
> >> As you can see, you can have guarantees only about the internal SQLite
> >> database. As soon as you involve network in your transaction, things
> >> get orders of magnitude more complicated.
> >> I am not sure, how strict are your requirements on transactionality.
> >> You could also implement some timer on your server that is
> >> transactionally persisted to a DBMS on that server, so that crash +
> >> restart or network outage would not cause it disappear. They you would
> >> revert any uncommitted transactions after some timeout. That gets you
> >> somwhere, but I am pretty sure it will break in some scenarios.
>
> >> --
> >> Daniel Drozdzewski
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Android Developers" group.
> > To post to this group, send email to android-developers@googlegroups.com
> > To unsubscribe from this group, send email to
> > android-developers+unsubscr...@googlegroups.com
> > For more options, visit this group at
> >http://groups.google.com/group/android-developers?hl=en
>
> --
> Daniel Drozdzewski
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Transactions
On Thu, Nov 18, 2010 at 2:13 PM, biokys wrote:
> Hi Daniel,
> thx for your post
> my goal is to make data sharing among any users so they can store
> their information locally in SQLite (in case of no network connection)
> and when they want, they can synchronize these datas with central
> datastore (Google app engine). so i assume, that transactional
> behavior is not crucial in this case, but can be handy.
>
> Honza
Hey Honza,
That is true, you don't need a transaction that would span both interactions.
It would be 2 separate transactions, or to be precise 1 local
transaction and server upload would be the best effort kind of thing,
with the assumption that it will eventually work at some point in the
future (could be quite distant future in terms of transactions).
All you have to do is to have some sort of time stamp attached to the
data in both places and the server routine will ask only mobile for
the data since its latest time stamp.
--
Daniel
>
> On 18 lis, 14:47, Daniel Drozdzewski
> wrote:
>> On Thu, Nov 18, 2010 at 1:05 PM, biokys wrote:
>> > Hi, I am trying to find out, how to store data in a local DB and
>> > remotely over HTTP in one transaction. Does exist any native mechanism
>> > in Android phone for transactional behavior?
>>
>> > Thx Honza
>>
>> Honza,
>>
>> Short answer is: I don't think so.
>> In order to achieve this, you would need to look at Distributed
>> Transaction Coordinators, if you require full transactionality.
>>
>> Java EE has JTA (Java Transaction API) but it's not present on mobile
>> platforms. To achieve this it relies on few very crucial things:
>> - JDBC 2.0 drivers for each data source you need in your distributed
>> transaction that actually implements XADataSource and XADataConnection
>> - JEE Application Server
>>
>> Android API mentions XADataSource and XAConnection, just have a look
>> at javax.sql.DataSource documentation, but there is nothing else. I am
>> pretty sure that SQLite does not support such mechanisms, but I could
>> be wrong.
>>
>> You can try doing it the garage way:
>>
>> db.beginTransaction();
>> try {
>> //send data to SQLite
>> //send data to external service
>> db.setTransactionSuccessful();
>> } catch (SQLException) {
>> //error in DB: contact the server to revert the commit and hope
>> it will do it
>> } catch (IOException) {
>> //error with the external server, and you have no guarantee,
>> whether it has been written or not
>> } finally {
>> db.endTransaction();
>> }
>>
>> As you can see, you can have guarantees only about the internal SQLite
>> database. As soon as you involve network in your transaction, things
>> get orders of magnitude more complicated.
>> I am not sure, how strict are your requirements on transactionality.
>> You could also implement some timer on your server that is
>> transactionally persisted to a DBMS on that server, so that crash +
>> restart or network outage would not cause it disappear. They you would
>> revert any uncommitted transactions after some timeout. That gets you
>> somwhere, but I am pretty sure it will break in some scenarios.
>>
>> --
>> Daniel Drozdzewski
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to android-developers@googlegroups.com
> To unsubscribe from this group, send email to
> android-developers+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
--
Daniel Drozdzewski
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: Transactions
Hi Daniel,
thx for your post
my goal is to make data sharing among any users so they can store
their information locally in SQLite (in case of no network connection)
and when they want, they can synchronize these datas with central
datastore (Google app engine). so i assume, that transactional
behavior is not crucial in this case, but can be handy.
Honza
On 18 lis, 14:47, Daniel Drozdzewski
wrote:
> On Thu, Nov 18, 2010 at 1:05 PM, biokys wrote:
> > Hi, I am trying to find out, how to store data in a local DB and
> > remotely over HTTP in one transaction. Does exist any native mechanism
> > in Android phone for transactional behavior?
>
> > Thx Honza
>
> Honza,
>
> Short answer is: I don't think so.
> In order to achieve this, you would need to look at Distributed
> Transaction Coordinators, if you require full transactionality.
>
> Java EE has JTA (Java Transaction API) but it's not present on mobile
> platforms. To achieve this it relies on few very crucial things:
> - JDBC 2.0 drivers for each data source you need in your distributed
> transaction that actually implements XADataSource and XADataConnection
> - JEE Application Server
>
> Android API mentions XADataSource and XAConnection, just have a look
> at javax.sql.DataSource documentation, but there is nothing else. I am
> pretty sure that SQLite does not support such mechanisms, but I could
> be wrong.
>
> You can try doing it the garage way:
>
> db.beginTransaction();
> try {
> //send data to SQLite
> //send data to external service
> db.setTransactionSuccessful();
> } catch (SQLException) {
> //error in DB: contact the server to revert the commit and hope
> it will do it
> } catch (IOException) {
> //error with the external server, and you have no guarantee,
> whether it has been written or not
> } finally {
> db.endTransaction();
> }
>
> As you can see, you can have guarantees only about the internal SQLite
> database. As soon as you involve network in your transaction, things
> get orders of magnitude more complicated.
> I am not sure, how strict are your requirements on transactionality.
> You could also implement some timer on your server that is
> transactionally persisted to a DBMS on that server, so that crash +
> restart or network outage would not cause it disappear. They you would
> revert any uncommitted transactions after some timeout. That gets you
> somwhere, but I am pretty sure it will break in some scenarios.
>
> --
> Daniel Drozdzewski
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
