Ovidiu Zaharia
|
qdb: Failed to create the database file
|
Ovidiu Zaharia
07/23/2018 5:09 AM
post118988
|
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 --------------------------
|
|
|