# SQlCipher Android DataBase

**URL:** <https://discuss.zetetic.net/t/sqlcipher-android-database/4905>\
**Category:** SQLCipher\
**Created:** [April 7, 2021, 4:54pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905 "2021-04-07T16:54:49Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 7, 2021, 4:54pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/1 "2021-04-07T16:54:49Z")

</div>

Si blocca su SQLiteDatabase.loadLibs(this);

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 7, 2021, 7:05pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/2 "2021-04-07T19:05:10Z")

</div>

Ciao @Marchesotti,

Riesci a eseguire SQLCipher per Android [suite di test](https://github.com/sqlcipher/sqlcipher-android-tests) sullo stesso dispositivo? Quali sono i tuoi risultati?

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 8, 2021, 8:35am UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/3 "2021-04-08T08:35:51Z")

</div>

non riesco a compilare il programma , ho Android Studio 4.1.1

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 8, 2021, 1:04pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/4 "2021-04-08T13:04:13Z")

</div>

Ciao @Marchesotti,

Android Studio aprirà direttamente la suite di test SQLCipher per Android. Se ricevi un errore del compilatore, condividi. Avremo bisogno di ulteriori informazioni per aiutarti a risolvere il tuo problema.

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 8, 2021, 1:08pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/5 "2021-04-08T13:08:22Z")

</div>

This version of the Android Support plugin for IntelliJ IDEA (or Android Studio) cannot open this project, please retry with version 4.2 or newer.

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 8, 2021, 4:13pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/6 "2021-04-08T16:13:30Z")

</div>

Hi @Marchesotti

Can you try modifying [this](https://github.com/sqlcipher/sqlcipher-android-tests/blob/master/build.gradle#L9) line to use the value `4.1.0`?

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 8, 2021, 4:48pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/7 "2021-04-08T16:48:55Z")

</div>

Grazie sono riuscito ad implementare nel mio programma SQLChipher e tutte le funzioni , solo che oh un problema nella creazione TABLE  
nel old programma uso SELECT\_SQL = "SELECT \* FROM "+TABLE\_NAME\_1;  
d2b.execSQL(TABLE1); e funziona  
con net.scqcipher non funziona ,  
oh provato d2b.execSQL(“create table users(TABLE\_NAME1)”);  
mi da errore

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 8, 2021, 6:39pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/8 "2021-04-08T18:39:51Z")

</div>

Ciao @Marchesotti,

Qual è l’errore che ricevi quando tenti di creare la tabella? Se il database esiste già con uno schema, sarà necessario utilizzare la funzione di convinenza SQLCipher [`sqlcipher_export()`](https://www.zetetic.net/sqlcipher/sqlcipher-api/#sqlcipher_export) per esportare il database da testo normale a crittografato. Sei riuscito a eseguire con successo [la suite di test SQLCipher per Android](https://github.com/sqlcipher/sqlcipher-android-tests)?

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 8, 2021, 6:57pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/9 "2021-04-08T18:57:01Z")

</div>

Ciao e grazie per le tue risposte  
sto provando a creare una Table in questo modo

d2b.execSQL(“create table if not exists codici( “ID integer primary key autoincrement,”+“descrizione text,”+”,utente text,"+“codice text)”);

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 8, 2021, 7:52pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/10 "2021-04-08T19:52:10Z")

</div>

Ciao @Marchesotti,

Che errore ricevi?

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 8, 2021, 10:10pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/11 "2021-04-08T22:10:53Z")

</div>

java.Lang.NullPointerException: Attempt to invoke virtul method ‘void net.sqlcipherdatabase.SQliteDatabase.exeSQL(java.Lang.String)’ on a null object reference

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 9, 2021, 9:48am UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/12 "2021-04-09T09:48:44Z")

</div>

I have a DataBase developed with SQLITE can I transfer it to SQLCipher?

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 9, 2021, 1:18pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/13 "2021-04-09T13:18:20Z")

</div>

Hi @Marchesotti

Yes, you can use [`sqlcipher_export(...)`](https://www.zetetic.net/sqlcipher/sqlcipher-api/#sqlcipher_export) to import a plaintext SQLite database into SQLCipher. We have an example within the test suite for Android [here](https://github.com/sqlcipher/sqlcipher-android-tests/blob/master/app/src/main/java/net/zetetic/tests/ImportUnencryptedDatabaseTest.java).

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 11, 2021, 10:05am UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/14 "2021-04-11T10:05:12Z")

</div>

Installation did not succeed. The application could not be installed: INSTALL\_FAILED\_MISSING\_SHARED\_LIBRARY

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 11, 2021, 8:12pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/15 "2021-04-11T20:12:38Z")

</div>

Create new SQLcipher DataBase  
Thank you

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 12, 2021, 3:57pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/16 "2021-04-12T15:57:21Z")

</div>

Hello @Marchesotti

Were you able to address the issue you were experiencing? It’s unclear from your latest response.

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 12, 2021, 5:24pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/17 "2021-04-12T17:24:38Z")

</div>

```auto
It was a problem related to AndroidManifest
Thanks for all the help

```

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 12, 2021, 6:47pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/18 "2021-04-12T18:47:26Z")

</div>

Hi @Marchesotti

Excellent, we are happy to hear everything is working now!

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 13, 2021, 7:13pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/19 "2021-04-13T19:13:29Z")

</div>

```auto
sqlcipher_export example Anroid program

```

---

<div class="post-metadata">

**Author:** ![Marchesotti](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Marchesotti](https://discuss.zetetic.net/u/Marchesotti)\
**Post date:** [April 13, 2021, 7:14pm UTC](https://discuss.zetetic.net/t/sqlcipher-android-database/4905/20 "2021-04-13T19:14:24Z")

</div>

sqlcipher\_export example Android programm

[Next page](https://discuss.zetetic.net/t/sqlcipher-android-database/4905.md?page=2)
