Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
Contributor
mnarinsky
Posts: 14
Registered: ‎11-11-2010
My Device: Not Specified
Accepted Solution

Attach an SQLite database to another

[ Edited ]

Hi,

 

I'm trying to attach one SQLite database to another using SQLite ATTACH DATABASE command.

 

 

Database d1, d2;

URI dbURI1 = URI.create("file:///SDCard/Databases/SQLiteExample/MyTestDatabase1.db");

Statement st;
if (DatabaseFactory.exists(dbURI1)) {
	d1 = DatabaseFactory.open(dbURI1);
} else {
	d1 = DatabaseFactory.create(dbURI1); 
	st = d1.createStatement("CREATE TABLE 'People' ( 'Name' TEXT, 'Age' INTEGER )");

	st.prepare();
	st.execute();
	st.close();
}

URI dbURI2 = URI.create("file:///SDCard/Databases/SQLiteExample/MyTestDatabase2.db");

if (DatabaseFactory.exists(dbURI2)) {
	d2 = DatabaseFactory.open(dbURI2);
} else {
	d2 = DatabaseFactory.create(dbURI2);
	st = d2.createStatement("CREATE TABLE 'People2' ('Name2' TEXT, 'Age2' INTEGER )");
	
	st.prepare();
	st.execute();
	st.close();
	d2.close();
}

st = d1.createStatement("ATTACH DATABASE '/SDCard/Databases/SQLiteExample/MyTestDatabase2.db' as SECOND_TABLE");
st.prepare(); //THROWS AN EXCEPTION "SQL logic error or missing database"
st.execute();
st.close();

 

 

 

I'm getting a Exception "ATTACH DATABASE /SDCard/Databases/SQLiteExample/MyTestDatabase2.db' as SECOND_TABLE: SQLlogic error or missing database"

when it tries to prepare statement for "Attach Database" command.

 

Is it possible to use the ATTACH DATABASE command with BlackBerry SQLite API?

 

Thanks.

Please use plain text.
Administrator
MSohm
Posts: 14,521
Registered: ‎07-09-2008
My Device: BlackBerry Z30, BlackBerry PlayBook
My Carrier: Bell

Re: Attach an SQLite database to another

The ATTACH DATABASE command is not supported by the implementation of SQLite on BlackBerry Smartphones.

Mark Sohm
BlackBerry Development Advisor

Please refrain from posting new questions in solved threads.
Problem solved? Click the Accept As Solution button.
Found a bug? Report it using Issue Tracker
Please use plain text.
Trusted Contributor
milanvishal
Posts: 201
Registered: ‎12-17-2010
My Device: Not Specified

Re: Attach an SQLite database to another

Can you please give its aternate Option that I use to create/copy table from other database...

 

Thanks,

Milan

Please use plain text.