Search Unity

  1. Megacity Metro Demo now available. Download now.
    Dismiss Notice
  2. Unity support for visionOS is now available. Learn more in our blog post.
    Dismiss Notice

Unable to load DLL - SQLite3

Discussion in 'Android' started by siddharth3322, Jun 24, 2020.

  1. siddharth3322

    siddharth3322

    Joined:
    Nov 29, 2013
    Posts:
    1,049
    I want to set up a local database for my Unity-based application. Up to now, I have followed this tutorial post to setup all things:
    https://medium.com/@rizasif92/sqlite-and-unity-how-to-do-it-right-31991712190

    Within my Unity Editor, all things working properly without any problem but when I execute the game build within Android device, it was giving me this kind of error message:
    unable to load dll.png

    With a similar error message, I read many posts and tried different approaches but nothing worked for me so I have decided to post the question here.

    At present, this kind of setup I have for sqlite3:
    so file inspector details.png
    To give me some suggestion still if you require some details then let me know.
     
  2. Tomas1856

    Tomas1856

    Unity Technologies

    Joined:
    Sep 21, 2012
    Posts:
    3,875
    Maybe you're running ARM64 app, in that case you need ARM64 lib, right now you're using ARMv7 libsqlite
     
    siddharth3322 likes this.
  3. siddharth3322

    siddharth3322

    Joined:
    Nov 29, 2013
    Posts:
    1,049
    I am happy to get your reply :)
    I understand what you are trying to say but for the solution what exactly I require to do?
    Can you give me the proper steps for this?
     
  4. Tomas1856

    Tomas1856

    Unity Technologies

    Joined:
    Sep 21, 2012
    Posts:
    3,875
    Get full log from your app first. It will contain entries saying which CPU architecture you're using
     
    siddharth3322 likes this.
  5. siddharth3322

    siddharth3322

    Joined:
    Nov 29, 2013
    Posts:
    1,049
    Basically I was developing a small application using the SQLite database and I want to release on Android and iOS platforms.
    So definitely I need support for a 64-bit version.
    I have attached a log file for all the log details.

    Also here I have attached database demo project too for you if it becomes useful to you:
    https://drive.google.com/file/d/170GIe_j9rYt-VT4Mey7EQ1730Y9vjK8h/view?usp=sharing

    I don't know why but just one script demo scene and project size become 350mb in a zip file.
    Please guide me into this, I will wait for your next reply :)
     

    Attached Files:

  6. Tomas1856

    Tomas1856

    Unity Technologies

    Joined:
    Sep 21, 2012
    Posts:
    3,875
    Well, it's obvious if your app is for ARM64, you need libsqlite3 which is also for ARM64, from your screenshot you seem to have only x86 & armv7 libsqlite3 variantas, there's no arm64 libsqlite3 variant, you need to provide one
     
  7. siddharth3322

    siddharth3322

    Joined:
    Nov 29, 2013
    Posts:
    1,049
    does this correct place to download a 64-bit libsqlite3 file?
    https://sqlite.org/download.html

    shall I require to create an x64 folder within the Android folder? to place the libsqlite3 file.
     
  8. Tomas1856

    Tomas1856

    Unity Technologies

    Joined:
    Sep 21, 2012
    Posts:
    3,875
    Regarding the website, not sure, you would need to try it out.

    You don't need x64 folder, since you won't be exporting for x64 CPU, only for ARMv7 and ARM64
     
  9. wechat_os_Qy09gD_rlWbab6DfJS4_nutiU

    wechat_os_Qy09gD_rlWbab6DfJS4_nutiU

    Joined:
    Dec 2, 2021
    Posts:
    1
    That's not work for me.The Unity version is 2020.3.23f1c1.I have tried all the solutions that I can find.finally.I find the solution by myself.Check the Load on startup in the libsqlite.so's inspector! It tooks me the whole day to sovel it. But I still don't know why. The Unity version 2018.4.21 no need to do this.

    That's not a real solution.Check the Load on Startup just work with the unknow specific version of libsqlite.so. I have to find another on Github.I found it finally! I still don't know the version of these files.
     
    Last edited: Dec 3, 2021
  10. phuongvvvnhl

    phuongvvvnhl

    Joined:
    Mar 29, 2020
    Posts:
    3
    I also had the same problem. I wonder if anyone has solved this problem? Please help me.