Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?
Ok, hosed over by proguard once again. Needed to make sure the following was in my proguard-project.txt file: -keep class org.sqlite.** { *; } Oh man! I must be getting old. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?
Hi Dan and thanks again for your response. So far, I have heard this from only a single user. Silly Google no longer seems to produce ARM system images for the emulator so I cannot test as my computers are all AMD. So I cannot say about that. Wish I could. I have tried. Here is the device info from the device in question: This is some information about your device... Linux Version: 3.18.100-ga765425 Android SDK Version: 28 Maker: Google Brand: google Product: marlin Device: marlin Model: Pixel XL The device is rooted for sure - using Magisk. In looking at the callback trace it appears that the issue is happening in the GetField call and I see 3 of them in the source code for the register function. I don't see why any of them should fail unless, of course, the classes.jar is having troubles. I have it in my project under libs along with all of the pre-built .so files. That has always worked for me in the past. And the same thing happened on this device using a previous build of the bindings. Thanks for your time and help. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?
Dan, Please don't waste your time on this thread any more at this point. My last post made me think enough (what a concept!) to look at the classes.dex in my exported .apk and there is something not right. It is way too small. So I think something in my build is messed up. That would explain things. Sorry for the bother! On 9/19/2018 8:35 AM, David White wrote: Oops. Just sent this from the wrong email account. Sorry for any duplication. Hi Dan and thanks again for your response. So far, I have heard this from only a single user. Silly Google no longer seems to produce ARM system images for the emulator so I cannot test as my computers are all AMD. So I cannot say about that. Wish I could. I have tried. Here is the device info from the device in question: This is some information about your device... Linux Version: 3.18.100-ga765425 Android SDK Version: 28 Maker: Google Brand: google Product: marlin Device: marlin Model: Pixel XL The device is rooted for sure - using Magisk. In looking at the callback trace it appears that the issue is happening in the GetField call and I see 3 of them in the source code for the register function. I don't see why any of them should fail unless, of course, the classes.jar is having troubles. I have it in my project under libs along with all of the pre-built .so files. That has always worked for me in the past. And the same thing happened on this device using a previous build of the bindings. Thanks for your time and help. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?
Oops. Just sent this from the wrong email account. Sorry for any duplication. Hi Dan and thanks again for your response. So far, I have heard this from only a single user. Silly Google no longer seems to produce ARM system images for the emulator so I cannot test as my computers are all AMD. So I cannot say about that. Wish I could. I have tried. Here is the device info from the device in question: This is some information about your device... Linux Version: 3.18.100-ga765425 Android SDK Version: 28 Maker: Google Brand: google Product: marlin Device: marlin Model: Pixel XL The device is rooted for sure - using Magisk. In looking at the callback trace it appears that the issue is happening in the GetField call and I see 3 of them in the source code for the register function. I don't see why any of them should fail unless, of course, the classes.jar is having troubles. I have it in my project under libs along with all of the pre-built .so files. That has always worked for me in the past. And the same thing happened on this device using a previous build of the bindings. Thanks for your time and help. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?
On 09/19/2018 12:18 AM, David White wrote: >> I am stuck trying to use the precompiled binaries + Android bindings on >> Android 8. Does anyone know how to reach the maintainers for this stuff? >Posting here will work. >> I have posted a ticket on the wiki but no luck. >This one, correct? > https://sqlite.org/android/info/28d442a2c39bd546 >Thanks for reporting the problem. I actually didn't know you could post >tickets there - hence the lack of response. Sorry about that. > >Should now be fixed here: > > https://sqlite.org/android/info/a113b9be83987fb8 > >Dan. Hello Dan. I was actually referring to this ticket: https://sqlite.org/android/tktview?name=931fee2609 Thanks alot. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to contact Android Sqlite Bindings Maintainers?
I am stuck trying to use the precompiled binaries + Android bindings on Android 8. Does anyone know how to reach the maintainers for this stuff? I have posted a ticket on the wiki but no luck. Thanks --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Android Issue Loading Pre-compiled Binaries
I have someone with an Android 8, arm64-v8a device testing a new Android app which uses the precompiled Sqlite binaries for Android. It appears there is some issue in loading the library. In the Android app log I see: 08-29 15:27:49.006 F/DEBUG (9478): #07 pc 00334204 /system/lib64/libart.so (_ZN3art3JNI10GetFieldIDEP7_JNIEnvP7_jclassPKcS6_+1380) 08-29 15:27:49.006 F/DEBUG (9478): #08 pc 00014f6c /data/app/com.whitedavidp.cookiemanagerforsystemwebview-Cxs-JPhN3ibGfH785l-NDQ==/lib/arm64/libsqliteX.so (_ZN7android42register_android_database_SQLiteConnectionEP7_JNIEnv+100) 08-29 15:27:49.006 F/DEBUG (9478): #09 pc 000150e0 /data/app/com.whitedavidp.cookiemanagerforsystemwebview-Cxs-JPhN3ibGfH785l-NDQ==/lib/arm64/libsqliteX.so (JNI_OnLoad+68) 08-29 15:27:49.006 F/DEBUG (9478): #10 pc 002d83d4 /system/lib64/libart.so (_ZN3art9JavaVMExt17LoadNativeLibraryEP7_JNIEnvRKNSt3__112basic_stringIcNS3_11char_traitsIcEENS3_9allocatorIcP8_jobjectP8_jstringPS9_+2204) 08-29 15:27:49.006 F/DEBUG (9478): #11 pc 41d4 /system/lib64/libopenjdkjvm.so (JVM_NativeLoad+276) and 08-29 15:27:48.713 F/DEBUG (9478): pid: 9310, tid: 9473, name: AsyncTask #1 >>> com.whitedavidp.cookiemanagerforsystemwebview <<< 08-29 15:27:48.713 F/DEBUG (9478): signal 6 (SIGABRT), code -6 (SI_TKILL), fault addr 08-29 15:27:48.713 F/DEBUG (9478): Abort message: 'java_vm_ext.cc:504] JNI DETECTED ERROR IN APPLICATION: java_class == null' I know that my app included the appropriate pre-compiled .so file dated 10/25/17. But it seems like some needed class is missing? Could it be android_database_SQLiteConnection? I have since updated my app to use the pre-compiled binaries that are available now. But have not yet heard if that makes any difference. So really wondering: (a) What is going on? (b) How to interpret what I am seeing in the logs above? (c) How to avoid this? Thanks! --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Latest Pre-Compiled Android Binaries
Hello and thanks for any help with this. I have been using the pre-compiled Android binaries on the download page for some time. Recently one of my apps had a "missing class" problem and I thought it might be due to the Sqlite libraries I had been using. These were dated 12/9/2017 and I saw there was an updated download so I grabbed it yesterday. When I opened the .aar, I see that while the old download contained .so files for these abis: arm64-v8a,armeabi,armeabi-v7a,mips,mips64,x86,x86_64 the new one only contains .so files for these abis:arm64-v8a,armeabi-v7a,x86,x86_64. I am not worried too much by the absence of mips but I do wonder about armabi. I am not sure I fully understand all of this. But I presume armabi is for old processors. Is there something in the later code that has changed making armabi no longer supported? Thanks. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Multiple Match statements per query
Database abstraction, scope, multi-threading. A few stack layers out is my loop requesting each record by rowid. And there's no predicting which thread will make the request. Likely, there will be 50 threads making very similar requests at the same time. If I could clone the statement, then I could make one that remains static. And each time I need it, I clone it, use it, and throw it away. I'm sure I would need some thread synchronization while performing the clone, but it would be a much briefer period than if I were trying to share a single statement with all threads. If cloning isn't an option, I can create a statement pool; I would just prefer the simpler option. Thanks dw _ From: Igor Tandetnik [mailto:itandet...@mvps.org] To: sqlite-users@sqlite.org Sent: Tue, 19 Apr 2011 17:08:09 -0600 Subject: Re: [sqlite] Multiple Match statements per query On 4/19/2011 6:57 PM, Dave White wrote: > So, if I could prepare the statement once, then clone it every time I > need to use it, I may see a 4 fold speed increase when calling this > operation frequently. Why can't you just reuse the same statement every time? Are you aware of sqlite3_reset ? -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users