<?xml version="1.0" encoding="utf-8"?>

<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->

<!-- This component and the accompanying materials are made available under the terms of the License 

"Eclipse Public License v1.0" which accompanies this distribution, 

and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->

<!-- Initial Contributors:

    Nokia Corporation - initial contribution.

Contributors: 

-->

<!DOCTYPE concept

  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">

<concept xml:lang="en" id="GUID-78773BCA-ADF6-53E6-AC80-5CB2AE1F8BCC"><title>SQL Server Guide</title><prolog><metadata><keywords/></metadata></prolog><conbody><p>This document introduces you to the SQL server. </p> <section><title>Purpose</title> <p>THE SQL server is an implementation of SQLite v3.3.17. </p> </section> <section><title>SQL server services</title> <p>SQL server performs the all SQL operations called from an application, including: </p> <ul><li id="GUID-72549F9B-29DE-5D1A-9B5C-038E955A0E43"><p>creating a SQL database, </p> </li> <li id="GUID-5A393FBC-F11C-5D05-B6C0-67D726C4142B"><p>opening an existing SQL database, </p> </li> <li id="GUID-1C746D2A-DA53-5556-ACAC-F34ABE18A610"><p>retrieving the last SQL error message, </p> </li> <li id="GUID-F186886F-6693-5A5E-ABA0-A63D22ED1773"><p>executing 8-bit and 16-bit SQL statements, </p> </li> <li id="GUID-ECEAA082-2D8B-5636-9312-AC24657DC807"><p>setting the transaction isolation level, </p> </li> <li id="GUID-B495D60D-94DC-50AC-87E1-CC540AAD87D3"><p>retrieving the database security policy, </p> </li> <li id="GUID-74A2F188-EC6C-50D7-9D49-1B70C5D73BD9"><p>attaching additional SQL databases to the current connection, </p> </li> <li id="GUID-7DA02DFE-1ADE-5934-AD89-D1DDAC04DB38"><p>detaching previously attached SQL database from current connection. </p> </li> </ul> <p><b>Platform Security</b> </p> <p>SQL server also manages all platform security related activities for secure databases including: </p> <ul><li id="GUID-773DB200-FA32-5177-BC74-D1046B40B601"><p>loading/storing database security policies when creating/opening a database connection, </p> </li> <li id="GUID-7A2567DA-EDBC-5432-A80B-DF2AD4954F0A"><p>asserting client rights to perform a specific database operation, </p> </li> <li id="GUID-0BB93BC1-68C7-5D8E-A0DA-A9D090446C0F"><p>maintaining security related internal data structures. </p> </li> </ul> </section> <section><title>Using the SQL server</title> <p>The SQL server is started when an application attempts to: </p> <ul><li id="GUID-FE9131E5-5C6F-5151-A003-0AFF52B8B984"><p>create a database, </p> </li> <li id="GUID-83A297AD-26A4-5EBD-B669-779A26A64C47"><p>open a database, </p> </li> <li id="GUID-E946BD2D-37CE-5C88-B043-285D8177D021"><p>copy a database, </p> </li> <li id="GUID-B4661882-6F0F-52D0-89EF-12BE072AE666"><p>delete a database. </p> </li> </ul> <p>The <filepath>SQLDB.dll</filepath> class <xref href="GUID-4688F6B7-E1B0-37CF-BAA2-C6BD103D4FDF.dita"><apiname>RSqlDatabase</apiname></xref> invokes a call to start the server as soon as an operation is initiated that requires the database server. Your application must include the <filepath>sqldb.lib</filepath> library, instantiate the <xref href="GUID-4688F6B7-E1B0-37CF-BAA2-C6BD103D4FDF.dita"><apiname>RSqlDatabase</apiname></xref> object and perform one of the operations listed above to start the SQL server. </p> <p>See the <xref href="GUID-C2FCE726-FD87-52BF-8AF8-7F54FB6D6CB1.dita">Basic SQL example application</xref> for an example. </p> <p>Once started, the server manages the SQL session and all SQL commands and operations sent as part of that session. </p> </section> </conbody><related-links><link href="GUID-22844C28-AB5B-5A6F-8863-7269464684B4.dita"><linktext>SQL Overview</linktext> </link> <link href="GUID-582CAA4A-1240-5138-983D-D9C6EEAF5566.dita"><linktext>SQL Tutorials</linktext> </link> <link href="GUID-C2FCE726-FD87-52BF-8AF8-7F54FB6D6CB1.dita"><linktext>Basic SQL Example

                Application</linktext> </link> <link href="GUID-1F12E3F5-45B2-55EC-B021-00338277C608.dita"><linktext>SQL DB Overview</linktext> </link> </related-links></concept>