ATTACH sqlite database in Android with SQLiteOpenHelper

Question

I'm in the process of creating a database that references keys in another database. Essentially, I have an import of data that I want to keep separate from one that will change, but if possible, I would like to reference the other keys via a `FOREIGN KEY`. So far as I know, I need to attach the database first to make that happen. Here's teh relevant code so far: ``` public class LogDatabaseHelper extends SQLiteOpenHelper { private static final String DATABASE_NAME = "log.db"; private static final int DATABASE_VERSION = 1; private String namesDb; public LogDatabaseHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); namesDb=getNamesDbPath(); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("ATTACH DATABASE ? AS names",new String[]{namesDb}); StringBuilder query=new StringBuilder(); query.append("CREATE TABLE log ("); } } ``` However, this doesn't seem to work, as I'm getting the following error: ``` 11-21 17:35:58.176: E/SQLiteLog(9984): (1)…

Accepted Answer

I figured out a way to make it work, that I'm not particularly proud of, but it does the job. If you can't be in a transaction when attaching a database, then end the transaction first.

```
db.setTransactionSuccessful();
db.endTransaction();
db.execSQL("ATTACH DATABASE ? AS names",new String[]{namesDb});
db.beginTransaction();
```

ATTACH sqlite database in Android with SQLiteOpenHelper

Solution

Problem