This topic introduces you to the SQL server.
SQL server performs the all SQL operations called from an application, including:
creating a SQL database,
opening an existing SQL database,
retrieving the last SQL error message,
executing 8-bit and 16-bit SQL statements,
setting the transaction isolation level,
retrieving the database security policy,
attaching additional SQL databases to the current connection,
detaching previously attached SQL database from current connection.
SQL server also manages all platform security related activities for secure databases including:
The SQL server is started when an application attempts to:
The SQLDB.dll class RSqlDatabase invokes a call to start the server as soon as an operation is initiated that requires the database server. Your application must include the sqldb.lib library, instantiate the RSqlDatabase object and perform one of the operations listed above to start the SQL server.
See the Basic SQL example application for an example.
Once started, the server manages the SQL session and all SQL commands and operations sent as part of that session.
Copyright ©2010 Nokia Corporation and/or its subsidiary(-ies).
All rights reserved. Unless otherwise stated, these materials are provided under the terms of the Eclipse Public License v1.0.