database trouble

[liafail]

I'm trying to use this code to create a database:

void CDatabaseHandler::CreateDatabase(const TDesC& aDatabaseFileName) {
	// construct a file store object - the file to contain the
	// database replaces any existing file of the same name.
	CFileStore* store = CPermanentFileStore::ReplaceLC(fsSession,aDatabaseFileName,EFileRead|EFileWrite);
	// Complete file store creation
	store->SetTypeL(store->Layout());
	// Create a database in the store
	RDbStoreDatabase database;
	TStreamId id=database.CreateL(store);
	// NB. The database won't be closed on failure
	//     Cleanup can be done; more usually database objects
	//     are not automatic variables.

	// Keep database id as root of store
	store->SetRootL(id);
	// Complete database creation by commiting the store
	store->CommitL();
	
	// create the tables
	CreatePhoneTable(database);
	
	// create an index
	//doCreateIndexL(database);
	// close the database
	database.Close();
	// Do not commit store: database has taken control of commit
	CleanupStack::PopAndDestroy();
}

void CDatabaseHandler::CreatePhoneTable(RDbStoreDatabase database){
	
	_LIT(KCol1Imei, "IMEI");
	_LIT(KCol2Imsi, "IMSI");
	_LIT(KPhoneT, "Phone");

	CDbColSet* columns=CDbColSet::NewLC();
	// add the columns
	// text columns default to 15 characters (variable length)

	//imei column
	TDbCol imei(KCol1Imei,EDbColText,15);
	imei.iAttributes=TDbCol::ENotNull;
	columns->AddL(imei);

	//imsi column
	TDbCol imsi(KCol2Imsi,EDbColText,15);
	imsi.iAttributes=TDbCol::ENotNull;
	columns->AddL(imsi);

	// Create Phone table
	User::LeaveIfError(database.CreateTable(KPhoneT,*columns));
				
	// cleanup the column set
	CleanupStack::PopAndDestroy();
}

when I call this function:

_LIT(appFile6, "c:\\System\\Data\\Test\\test.db");
cbDatabaseHandler.CreateDatabase(appFile6);

my app gets a System error... Compilation is ok, but when i try to run it i get this error....

What's wrong? This is my first time with database in symbian..any tips??

:mrgreen:

[symbianyucca]

what sort of error note do you get ?

Anyway, have you made sure that the emulators c-drive has all of the fodlers defined in the path.

yucca

[liafail]

The error is "System Error", that what it says in the phone and emulator...

Oh yeah, i forgot to put it in the .pkg file....

so if in my code, I have this:

_LIT(appFile6, "c:\\System\\Data\\Test\\test.db");
cbDatabaseHandler.CreateDatabase(appFile6);


then in my .pkg i should have something like this:

"test.db"-"C:\system\test.db"

right? But how will I create test.db???? from notepad or something? Sorry for this dumb question, I'm not familiar with db in symbian.


thanks! I'll be waiting..

[liafail]

I did what I said.. now i'm getting KERN-EXEC 0 error...
waht is the prob? pleasessseeeee

[liafail]

vacation is over... my question remains unanswered.. anyone?
how to set up database in symbian?

[symbianyucca]

"KERN-EXEC 0" is a bad handle, so either you forgot to connect or open a R-class object before using it. So put a breakpoint into your code, run it in a emulator and see what happens and which line is giving you this error, then check the variables used in that line, thatn they are initialized correctly, and that nthe initilization is not returning any errors.

yucca

[liafail]

thanks.

I tried debugging it in the phone using Logs....
Everything seems fine, but then my app closes... what is the matter..
Or should i start from scratch... can you please post some sample on how to set up or create a database...