Project Home
Project Home
Documents
Documents
Wiki
Wiki
Discussion Forums
Discussions
Project Information
Project Info
BroadcastCommunity.qnx.com will be offline from May 31 6:00pm until June 2 12:00AM for upcoming system upgrades. For more information please go to https://community.qnx.com/sf/discussion/do/listPosts/projects.bazaar/discussion.bazaar.topc28418
Forum Topic - qdb: Failed to create the database file: Page 1 of 3 (3 Items)
   
qdb: Failed to create the database file  
Hello all,
I try to create and start a qdb database for QNX 7.00  with the following command:
# qdb -vvvvvv -otempstore=/opt/qdb_database/tmpstore/ -Rauto -A

Even if the qdb process is started correctly and even though I do not receive any error message, the file:
"/opt/qdb_database/qad_proc_database_file_db" 
is not created as I expect and as it is instructed to to in the " /pps/qnx/qdb/config/qdb.conf " file (see below)

Subsequently when I try to run my c application: 
" hdl = qdb_connect("/opt/qdb_database/qad_proc_database_file_db", 0);"

I get the error message: "Error connecting to database: No such file or directory"

Can anyone help me with this one?

For ref:
------- content/pps/qnx/qdb/config/qdb.conf ----------------------------
@qdb.conf
Filename::/opt/qdb_database/qad_proc_database_file_db
SchemaFile::/opt/qdb_database/qad_proc_main_schema.sql
DataSchemaFile::/opt/qdb_database/qad_proc_data_schema.sql
ClientSchemaFile::/opt/qdb_database/qad_proc_client_schema.sql
------------ end --------------------------

------- content of SchemaFile: /opt/qdb_database/qad_proc_main_schema.sql ----------------------------
CREATE TABLE customers(
  customerid INTEGER PRIMARY KEY AUTOINCREMENT,
  firstname  TEXT,
  lastname   TEXT,
  amount     INTEGER
);
------------ end --------------------------
 
------- content o fDataSchemaFile: /opt/qdb_database/qad_proc_data_schema.sql ----------------------------
INSERT INTO customers(firstname, lastname, amount)
  VALUES("Scipio", "Zetor", 898010);
------------ end --------------------------
 
------- content of:ClientSchemaFile: /opt/qdb_database/qad_proc_client_schema.sql----------------------------
PRAGMA journal_mode = PERSIST;
PRAGMA case_sensitive_like = true;
PRAGMA locking_mode = EXCLUSIVE
------------ end --------------------------