|
sl@0
|
1 |
// Copyright (c) 2005-2010 Nokia Corporation and/or its subsidiary(-ies).
|
|
sl@0
|
2 |
// All rights reserved.
|
|
sl@0
|
3 |
// This component and the accompanying materials are made available
|
|
sl@0
|
4 |
// under the terms of "Eclipse Public License v1.0"
|
|
sl@0
|
5 |
// which accompanies this distribution, and is available
|
|
sl@0
|
6 |
// at the URL "http://www.eclipse.org/legal/epl-v10.html".
|
|
sl@0
|
7 |
//
|
|
sl@0
|
8 |
// Initial Contributors:
|
|
sl@0
|
9 |
// Nokia Corporation - initial contribution.
|
|
sl@0
|
10 |
//
|
|
sl@0
|
11 |
// Contributors:
|
|
sl@0
|
12 |
// NTT DOCOMO, INC - Fix for Bug 1915 "SQL server panics when using long column type strings"
|
|
sl@0
|
13 |
//
|
|
sl@0
|
14 |
// Description:
|
|
sl@0
|
15 |
//
|
|
sl@0
|
16 |
|
|
sl@0
|
17 |
#include "SqlSrvMain.h" //CSqlServer
|
|
sl@0
|
18 |
#include "SqlSrvSession.h" //CSqlSrvSession
|
|
sl@0
|
19 |
#include "SqlSrvStatement.h" //CSqlSrvStatement, HSqlSrvStmtParamBuf
|
|
sl@0
|
20 |
#include "SqlSecurityImpl.h" //CSqlSecurityPolicy
|
|
sl@0
|
21 |
#include "SqlSrvUtil.h" //Global server functions
|
|
sl@0
|
22 |
#include "SqlUtil.h" // config length
|
|
sl@0
|
23 |
#include "SqlSrvDriveSpace.h" //CSqlDriveSpace, RSqlDriveSpaceCol
|
|
sl@0
|
24 |
#include "SqlSrvBlob.h"
|
|
sl@0
|
25 |
#include "SqlResourceProfiler.h"
|
|
sl@0
|
26 |
#include "SqlCompact.h"
|
|
sl@0
|
27 |
#include "OstTraceDefinitions.h"
|
|
sl@0
|
28 |
#ifdef OST_TRACE_COMPILER_IN_USE
|
|
sl@0
|
29 |
#include "SqlSrvSessionTraces.h"
|
|
sl@0
|
30 |
#endif
|
|
sl@0
|
31 |
#include "SqlTraceDef.h"
|
|
sl@0
|
32 |
|
|
sl@0
|
33 |
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
34 |
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
35 |
|
|
sl@0
|
36 |
#pragma BullseyeCoverage off
|
|
sl@0
|
37 |
|
|
sl@0
|
38 |
#ifdef _DEBUG
|
|
sl@0
|
39 |
|
|
sl@0
|
40 |
const TInt KDelayedDbHeapFailureMask = 0x1000;
|
|
sl@0
|
41 |
|
|
sl@0
|
42 |
//Puts the database connection in a test mode
|
|
sl@0
|
43 |
//Returns true if the heap failure simulation has to be delayed untill the database is opened
|
|
sl@0
|
44 |
//Initialises iDbResourceTestMode and iFailedAllocNumber (if delayed simulation) data members
|
|
sl@0
|
45 |
inline TBool CSqlSrvSession::ActivateDbTestMode(TInt aHeapFailureMode, TInt aFailedAllocNumber)
|
|
sl@0
|
46 |
{
|
|
sl@0
|
47 |
iDbResourceTestMode = aHeapFailureMode;
|
|
sl@0
|
48 |
if(aHeapFailureMode & KDelayedDbHeapFailureMask)
|
|
sl@0
|
49 |
{
|
|
sl@0
|
50 |
iFailedAllocNumber = aFailedAllocNumber;
|
|
sl@0
|
51 |
return ETrue;
|
|
sl@0
|
52 |
}
|
|
sl@0
|
53 |
return EFalse;
|
|
sl@0
|
54 |
}
|
|
sl@0
|
55 |
|
|
sl@0
|
56 |
//If the database connection is in a test mode then the macro will reset the heap allocation failure type.
|
|
sl@0
|
57 |
//and stop the test mode.
|
|
sl@0
|
58 |
inline void CSqlSrvSession::StopDbTestMode()
|
|
sl@0
|
59 |
{
|
|
sl@0
|
60 |
if(iDbResourceTestMode)
|
|
sl@0
|
61 |
{
|
|
sl@0
|
62 |
iDbResourceTestMode = 0;
|
|
sl@0
|
63 |
User::__DbgSetAllocFail(RHeap::EUser, RHeap::ENone, 0);
|
|
sl@0
|
64 |
}
|
|
sl@0
|
65 |
}
|
|
sl@0
|
66 |
|
|
sl@0
|
67 |
//If the database connection is in a test mode then the function will mark the allocated by the
|
|
sl@0
|
68 |
//server resources.
|
|
sl@0
|
69 |
inline void CSqlSrvSession::DbResourceMark()
|
|
sl@0
|
70 |
{
|
|
sl@0
|
71 |
if(iDbResourceTestMode)
|
|
sl@0
|
72 |
{
|
|
sl@0
|
73 |
ResourceCountMarkStart();
|
|
sl@0
|
74 |
}
|
|
sl@0
|
75 |
}
|
|
sl@0
|
76 |
|
|
sl@0
|
77 |
//If the database connection is in a test mode then the macro will check the allocated by the server resources,
|
|
sl@0
|
78 |
//comparing their count with the resource count at the moment DbResourceMark() has been called.
|
|
sl@0
|
79 |
//The client will be panicked if the resource count now is different.
|
|
sl@0
|
80 |
inline void CSqlSrvSession::DbResourceEnd(const RMessage2& aMessage)
|
|
sl@0
|
81 |
{
|
|
sl@0
|
82 |
if(iDbResourceTestMode)
|
|
sl@0
|
83 |
{
|
|
sl@0
|
84 |
ResourceCountMarkEnd(aMessage);
|
|
sl@0
|
85 |
}
|
|
sl@0
|
86 |
}
|
|
sl@0
|
87 |
|
|
sl@0
|
88 |
//Executes the heap simulation failure.
|
|
sl@0
|
89 |
inline void CSqlSrvSession::DbSetAllocFail(TInt aHeapFailureMode, TInt aFailedAllocNumber)
|
|
sl@0
|
90 |
{
|
|
sl@0
|
91 |
TInt mode = aHeapFailureMode & (KDelayedDbHeapFailureMask - 1);
|
|
sl@0
|
92 |
if(mode >= RAllocator::EBurstRandom && mode <= RAllocator::EBurstFailNext)
|
|
sl@0
|
93 |
{
|
|
sl@0
|
94 |
const TUint KBurst = 50;
|
|
sl@0
|
95 |
User::__DbgSetBurstAllocFail(RHeap::EUser, static_cast <RHeap::TAllocFail> (mode), aFailedAllocNumber, KBurst);
|
|
sl@0
|
96 |
}
|
|
sl@0
|
97 |
else
|
|
sl@0
|
98 |
{
|
|
sl@0
|
99 |
User::__DbgSetAllocFail(RHeap::EUser, static_cast <RHeap::TAllocFail> (mode), aFailedAllocNumber);
|
|
sl@0
|
100 |
}
|
|
sl@0
|
101 |
}
|
|
sl@0
|
102 |
|
|
sl@0
|
103 |
//Executes the delayed heap simulation failure, if the connection is in test mode
|
|
sl@0
|
104 |
inline void CSqlSrvSession::DbSetDelayedAllocFail()
|
|
sl@0
|
105 |
{
|
|
sl@0
|
106 |
if(iDbResourceTestMode & KDelayedDbHeapFailureMask)
|
|
sl@0
|
107 |
{
|
|
sl@0
|
108 |
TInt mode = iDbResourceTestMode & (KDelayedDbHeapFailureMask - 1);
|
|
sl@0
|
109 |
if(mode >= RAllocator::EBurstRandom && mode <= RAllocator::EBurstFailNext)
|
|
sl@0
|
110 |
{
|
|
sl@0
|
111 |
const TUint KBurst = 50;
|
|
sl@0
|
112 |
User::__DbgSetBurstAllocFail(RHeap::EUser, static_cast <RHeap::TAllocFail> (mode), iFailedAllocNumber, KBurst);
|
|
sl@0
|
113 |
}
|
|
sl@0
|
114 |
else
|
|
sl@0
|
115 |
{
|
|
sl@0
|
116 |
User::__DbgSetAllocFail(RHeap::EUser, static_cast <RHeap::TAllocFail> (mode), iFailedAllocNumber);
|
|
sl@0
|
117 |
}
|
|
sl@0
|
118 |
}
|
|
sl@0
|
119 |
}
|
|
sl@0
|
120 |
|
|
sl@0
|
121 |
#else //_DEBUG
|
|
sl@0
|
122 |
|
|
sl@0
|
123 |
inline TBool CSqlSrvSession::ActivateDbTestMode(TInt, TInt)
|
|
sl@0
|
124 |
{
|
|
sl@0
|
125 |
return EFalse;
|
|
sl@0
|
126 |
}
|
|
sl@0
|
127 |
|
|
sl@0
|
128 |
inline void CSqlSrvSession::StopDbTestMode()
|
|
sl@0
|
129 |
{
|
|
sl@0
|
130 |
}
|
|
sl@0
|
131 |
|
|
sl@0
|
132 |
inline void CSqlSrvSession::DbResourceMark()
|
|
sl@0
|
133 |
{
|
|
sl@0
|
134 |
}
|
|
sl@0
|
135 |
|
|
sl@0
|
136 |
inline void CSqlSrvSession::DbResourceEnd(const RMessage2&)
|
|
sl@0
|
137 |
{
|
|
sl@0
|
138 |
}
|
|
sl@0
|
139 |
|
|
sl@0
|
140 |
inline void CSqlSrvSession::DbSetAllocFail(TInt, TInt)
|
|
sl@0
|
141 |
{
|
|
sl@0
|
142 |
}
|
|
sl@0
|
143 |
|
|
sl@0
|
144 |
inline void CSqlSrvSession::DbSetDelayedAllocFail()
|
|
sl@0
|
145 |
{
|
|
sl@0
|
146 |
}
|
|
sl@0
|
147 |
|
|
sl@0
|
148 |
#endif//_DEBUG
|
|
sl@0
|
149 |
|
|
sl@0
|
150 |
#pragma BullseyeCoverage on
|
|
sl@0
|
151 |
|
|
sl@0
|
152 |
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
153 |
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
154 |
|
|
sl@0
|
155 |
/**
|
|
sl@0
|
156 |
Searches aContainer for an object identified by aHandle.
|
|
sl@0
|
157 |
If such object exists, a reference to it is returned.
|
|
sl@0
|
158 |
If there is no object, the client gets a panic.
|
|
sl@0
|
159 |
|
|
sl@0
|
160 |
@panic SqlDb 4 Client panic. Invalid aHandle parameter value (zero, negative or out of range).
|
|
sl@0
|
161 |
|
|
sl@0
|
162 |
@internalComponent
|
|
sl@0
|
163 |
*/
|
|
sl@0
|
164 |
template <class T> T& SqlSessObjFind(RDbObjContainer<T>& aContainer, TInt aHandle, const RMessage2& aMessage)
|
|
sl@0
|
165 |
{
|
|
sl@0
|
166 |
T* obj = aContainer.Find(aHandle);
|
|
sl@0
|
167 |
__SQLPANIC_CLIENT2(obj != NULL, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
168 |
return *obj;
|
|
sl@0
|
169 |
}
|
|
sl@0
|
170 |
|
|
sl@0
|
171 |
//This function return true, if there is free disk space on drive where the main database file is.
|
|
sl@0
|
172 |
static TBool HasFreeDiskSpace(RFs& aFs, TDriveNumber aDrive)
|
|
sl@0
|
173 |
{
|
|
sl@0
|
174 |
TVolumeInfo volInfo;
|
|
sl@0
|
175 |
TInt err = aFs.Volume(volInfo, aDrive);
|
|
sl@0
|
176 |
if(err == KErrNone)
|
|
sl@0
|
177 |
{
|
|
sl@0
|
178 |
const TInt64 KDiskSpaceThreshold = 1024 * 4;
|
|
sl@0
|
179 |
return volInfo.iFree > KDiskSpaceThreshold;
|
|
sl@0
|
180 |
}
|
|
sl@0
|
181 |
return ETrue;
|
|
sl@0
|
182 |
}
|
|
sl@0
|
183 |
|
|
sl@0
|
184 |
//If aError is KSqlErrFull and there is no free disk space, then KSqlErrFull is converted to KErrDiskFull
|
|
sl@0
|
185 |
//and returned.
|
|
sl@0
|
186 |
static TInt ConvertSqlFull2DiskFullErr(TInt aError, RFs& aFs, TDriveNumber aDrive)
|
|
sl@0
|
187 |
{
|
|
sl@0
|
188 |
if(aError == KSqlErrFull && !HasFreeDiskSpace(aFs, aDrive))
|
|
sl@0
|
189 |
{
|
|
sl@0
|
190 |
aError = KErrDiskFull;
|
|
sl@0
|
191 |
SQL_TRACE_SESSION(OstTrace1(TRACE_INTERNALS, CONVERTSQLFULL2DISKFULLERRROR, "0;ConvertSqlFull2DiskFullErr;aError=KSqlErrFull;!HasFreeDiskSpace();aDrive=%d", (TInt)aDrive));
|
|
sl@0
|
192 |
}
|
|
sl@0
|
193 |
return aError;
|
|
sl@0
|
194 |
}
|
|
sl@0
|
195 |
|
|
sl@0
|
196 |
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
197 |
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
198 |
|
|
sl@0
|
199 |
/**
|
|
sl@0
|
200 |
Creates a new instance of CSqlSrvSession class.
|
|
sl@0
|
201 |
|
|
sl@0
|
202 |
This function shall never be called directly.
|
|
sl@0
|
203 |
It is CSqlServer responsibility to create a new server side session object as a responce to the criation of a
|
|
sl@0
|
204 |
client side session instance.
|
|
sl@0
|
205 |
|
|
sl@0
|
206 |
@return A pointer to the created CSqlSrvSession instance.
|
|
sl@0
|
207 |
|
|
sl@0
|
208 |
@leave KErrNoMemory, an out of memory condition has occurred;
|
|
sl@0
|
209 |
|
|
sl@0
|
210 |
@see CSqlServer
|
|
sl@0
|
211 |
@see CSqlServer::NewSessionL()
|
|
sl@0
|
212 |
*/
|
|
sl@0
|
213 |
CSqlSrvSession* CSqlSrvSession::NewL()
|
|
sl@0
|
214 |
{
|
|
sl@0
|
215 |
SQL_TRACE_SESSION(OstTrace0(TRACE_INTERNALS, CSQLSRVSESSION_NEWL_ENTRY, "Entry;0;CSqlSrvSession::NewL"));
|
|
sl@0
|
216 |
CSqlSrvSession* self = new (ELeave) CSqlSrvSession;
|
|
sl@0
|
217 |
CleanupStack::PushL(self);
|
|
sl@0
|
218 |
self->ConstructL();
|
|
sl@0
|
219 |
CleanupStack::Pop(self);
|
|
sl@0
|
220 |
SQL_TRACE_SESSION(OstTrace1(TRACE_INTERNALS, CSQLSRVSESSION_NEWL_EXIT, "Exit;0x%X;CSqlSrvSession::NewL", (TUint)self));
|
|
sl@0
|
221 |
return self;
|
|
sl@0
|
222 |
}
|
|
sl@0
|
223 |
|
|
sl@0
|
224 |
/**
|
|
sl@0
|
225 |
Frees the allocated by CSqlSrvSession instance resources and memory.
|
|
sl@0
|
226 |
*/
|
|
sl@0
|
227 |
CSqlSrvSession::~CSqlSrvSession()
|
|
sl@0
|
228 |
{
|
|
sl@0
|
229 |
SQL_TRACE_SESSION(OstTraceExt2(TRACE_INTERNALS, CSQLSRVSESSION_CSQLSRVSESSION2_ENTRY, "Entry;0x%X;CSqlSrvSession::~CSqlSrvSession;iDatabase=0x%X", (TUint)this, (TUint)iDatabase));
|
|
sl@0
|
230 |
StopDbTestMode();
|
|
sl@0
|
231 |
DbFreeReservedSpace();
|
|
sl@0
|
232 |
iIpcStreams.Close();
|
|
sl@0
|
233 |
iStatements.Close();
|
|
sl@0
|
234 |
delete iDatabase;
|
|
sl@0
|
235 |
SQL_TRACE_SESSION(OstTrace1(TRACE_INTERNALS, CSQLSRVSESSION_CSQLSRVSESSION2_EXIT, "Exit;0x%X;CSqlSrvSession::~CSqlSrvSession", (TUint)this));
|
|
sl@0
|
236 |
}
|
|
sl@0
|
237 |
|
|
sl@0
|
238 |
/**
|
|
sl@0
|
239 |
Receives and dispatches all client side requests.
|
|
sl@0
|
240 |
|
|
sl@0
|
241 |
CSession2::ServiceL() implementation.
|
|
sl@0
|
242 |
|
|
sl@0
|
243 |
@param aMessage Client message containing the request (function code and data)
|
|
sl@0
|
244 |
|
|
sl@0
|
245 |
@leave The function may leave with some database specific
|
|
sl@0
|
246 |
errors categorised as ESqlDbError or system-wide error codes.
|
|
sl@0
|
247 |
|
|
sl@0
|
248 |
@see CSession2::ServiceL()
|
|
sl@0
|
249 |
*/
|
|
sl@0
|
250 |
void CSqlSrvSession::ServiceL(const RMessage2& aMessage)
|
|
sl@0
|
251 |
{
|
|
sl@0
|
252 |
TSqlSrvFunction funcCode = ESqlSrvTestBase;
|
|
sl@0
|
253 |
TInt handle = 0;
|
|
sl@0
|
254 |
Extract(aMessage, funcCode, handle);
|
|
sl@0
|
255 |
TInt retCode = KErrNone;
|
|
sl@0
|
256 |
if(funcCode >= ESqlSrvDbBase)
|
|
sl@0
|
257 |
{
|
|
sl@0
|
258 |
SQLPROFILER_REPORT_IPC(ESqlIpcRq, 0);
|
|
sl@0
|
259 |
}
|
|
sl@0
|
260 |
__SQLTRACE_SESSIONEXPR(++iIpcCallCounter);
|
|
sl@0
|
261 |
SQL_TRACE_SESSION(OstTraceExt4(TRACE_INTERNALS, CSQLSRVSESSION_SERVICEL_ENTRY, "Entry;0x%X;CSqlSrvSession::ServiceL;aMessage.Handle()=0x%X;funcCode=0x%X;iIpcCallCounter=%u", (TUint)this, (TUint)aMessage.Handle(), (TUint)funcCode, iIpcCallCounter));
|
|
sl@0
|
262 |
SQLPROFILER_IPC_START(iIpcCallCounter, iDatabase ? (TUint)iDatabase->RawDbHandle() : 0);
|
|
sl@0
|
263 |
switch(funcCode)
|
|
sl@0
|
264 |
{
|
|
sl@0
|
265 |
////////////////////// resource check operations ///////////////////////////
|
|
sl@0
|
266 |
case ESqlSrvResourceMark:
|
|
sl@0
|
267 |
ResourceCountMarkStart();
|
|
sl@0
|
268 |
break;
|
|
sl@0
|
269 |
case ESqlSrvResourceCheck:
|
|
sl@0
|
270 |
ResourceCountMarkEnd(aMessage);
|
|
sl@0
|
271 |
break;
|
|
sl@0
|
272 |
case ESqlSrvResourceCount:
|
|
sl@0
|
273 |
retCode = CountResources(); //Returns the recourse count
|
|
sl@0
|
274 |
break;
|
|
sl@0
|
275 |
case ESqlSrvSetDbHeapFailure:
|
|
sl@0
|
276 |
if(ActivateDbTestMode(aMessage.Int0(), aMessage.Int1()))
|
|
sl@0
|
277 |
{
|
|
sl@0
|
278 |
break;
|
|
sl@0
|
279 |
}
|
|
sl@0
|
280 |
case ESqlSrvSetHeapFailure:
|
|
sl@0
|
281 |
DbSetAllocFail(aMessage.Int0(), aMessage.Int1());
|
|
sl@0
|
282 |
break;
|
|
sl@0
|
283 |
////////////////////// profiling operations //////////////////////////////////
|
|
sl@0
|
284 |
case ESqlSrvProfilerStart:
|
|
sl@0
|
285 |
TSqlSrvResourceProfiler::StartL(aMessage);
|
|
sl@0
|
286 |
break;
|
|
sl@0
|
287 |
case ESqlSrvProfilerStop:
|
|
sl@0
|
288 |
TSqlSrvResourceProfiler::StopL(aMessage);
|
|
sl@0
|
289 |
break;
|
|
sl@0
|
290 |
case ESqlSrvProfilerReset:
|
|
sl@0
|
291 |
TSqlSrvResourceProfiler::ResetL(aMessage);
|
|
sl@0
|
292 |
break;
|
|
sl@0
|
293 |
case ESqlSrvProfilerQuery:
|
|
sl@0
|
294 |
ProfilerQueryL(aMessage);
|
|
sl@0
|
295 |
break;
|
|
sl@0
|
296 |
////////////////////// database operations //////////////////////////////////
|
|
sl@0
|
297 |
case ESqlSrvDbCreate:
|
|
sl@0
|
298 |
case ESqlSrvDbCreateSecure:
|
|
sl@0
|
299 |
case ESqlSrvDbOpen:
|
|
sl@0
|
300 |
DbResourceMark();
|
|
sl@0
|
301 |
DbCreateObjectL(aMessage, funcCode);
|
|
sl@0
|
302 |
DbSetDelayedAllocFail();
|
|
sl@0
|
303 |
break;
|
|
sl@0
|
304 |
case ESqlSrvDbOpenFromHandle:
|
|
sl@0
|
305 |
DbResourceMark();
|
|
sl@0
|
306 |
DbCreateObjectFromHandleL(aMessage);
|
|
sl@0
|
307 |
DbSetDelayedAllocFail();
|
|
sl@0
|
308 |
break;
|
|
sl@0
|
309 |
case ESqlSrvDbAttach:
|
|
sl@0
|
310 |
DbAttachL(aMessage);
|
|
sl@0
|
311 |
break;
|
|
sl@0
|
312 |
case ESqlSrvDbAttachFromHandle:
|
|
sl@0
|
313 |
DbAttachFromHandleL(aMessage);
|
|
sl@0
|
314 |
break;
|
|
sl@0
|
315 |
case ESqlSrvDbDetach:
|
|
sl@0
|
316 |
DbDetachL(aMessage);
|
|
sl@0
|
317 |
break;
|
|
sl@0
|
318 |
case ESqlSrvDbClose:
|
|
sl@0
|
319 |
DbDestroyObject();
|
|
sl@0
|
320 |
DbResourceEnd(aMessage);
|
|
sl@0
|
321 |
StopDbTestMode();
|
|
sl@0
|
322 |
break;
|
|
sl@0
|
323 |
case ESqlSrvDbCopy:
|
|
sl@0
|
324 |
DbResourceMark();
|
|
sl@0
|
325 |
DbCopyFileL(aMessage);
|
|
sl@0
|
326 |
break;
|
|
sl@0
|
327 |
case ESqlSrvDbDelete:
|
|
sl@0
|
328 |
DbResourceMark();
|
|
sl@0
|
329 |
DbDeleteFileL(aMessage);
|
|
sl@0
|
330 |
break;
|
|
sl@0
|
331 |
case ESqlSrvLastErrorMsg:
|
|
sl@0
|
332 |
retCode = DbLastErrorMessageL(aMessage);//may return that the client buffer is not big enough for the message
|
|
sl@0
|
333 |
break;
|
|
sl@0
|
334 |
case ESqlSrvDbLastInsertedRowId:
|
|
sl@0
|
335 |
DbLastInsertedRowIdL(aMessage);
|
|
sl@0
|
336 |
break;
|
|
sl@0
|
337 |
case ESqlSrvDbExec8:
|
|
sl@0
|
338 |
retCode = DbExecSql8L(aMessage); //returns the count of affected records
|
|
sl@0
|
339 |
break;
|
|
sl@0
|
340 |
case ESqlSrvDbExec16:
|
|
sl@0
|
341 |
retCode = DbExecSql16L(aMessage); //returns the count of affected records
|
|
sl@0
|
342 |
break;
|
|
sl@0
|
343 |
case ESqlSrvDbSetIsolationLevel:
|
|
sl@0
|
344 |
DbSetIsolationLevelL(aMessage);
|
|
sl@0
|
345 |
break;
|
|
sl@0
|
346 |
case ESqlSrvDbGetSecurityPolicy:
|
|
sl@0
|
347 |
retCode = DbGetSecurityPolicyL(aMessage);//may return that the client buffer is not big enough for the security policy
|
|
sl@0
|
348 |
break;
|
|
sl@0
|
349 |
case ESqlSrvDbScalarFullSelect8:
|
|
sl@0
|
350 |
retCode = DbScalarFullSelectL(aMessage, EFalse);//may return that the client buffer is not big enough for the column value
|
|
sl@0
|
351 |
break;
|
|
sl@0
|
352 |
case ESqlSrvDbScalarFullSelect16:
|
|
sl@0
|
353 |
retCode = DbScalarFullSelectL(aMessage, ETrue);//may return that the client buffer is not big enough for the column value
|
|
sl@0
|
354 |
break;
|
|
sl@0
|
355 |
case ESqlSrvDbInTransaction:
|
|
sl@0
|
356 |
retCode = DbInTransaction(aMessage); //Returns whether the database in in transaction or not - true/false
|
|
sl@0
|
357 |
break;
|
|
sl@0
|
358 |
case ESqlSrvDbSize:
|
|
sl@0
|
359 |
retCode = DbSizeL(aMessage); //Returns the database size
|
|
sl@0
|
360 |
break;
|
|
sl@0
|
361 |
case ESqlSrvDbSize2:
|
|
sl@0
|
362 |
DbSize2L(aMessage);
|
|
sl@0
|
363 |
break;
|
|
sl@0
|
364 |
case ESqlSrvDbCompact:
|
|
sl@0
|
365 |
retCode = DbCompactL(aMessage); //Returns the amount of the removed free database space
|
|
sl@0
|
366 |
break;
|
|
sl@0
|
367 |
////////////////////// reserved drive space management ////////////////////////
|
|
sl@0
|
368 |
case ESqlSrvDbReserveDriveSpace:
|
|
sl@0
|
369 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
370 |
DbReserveDriveSpaceL();
|
|
sl@0
|
371 |
break;
|
|
sl@0
|
372 |
case ESqlSrvDbFreeReservedSpace:
|
|
sl@0
|
373 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
374 |
DbFreeReservedSpace();
|
|
sl@0
|
375 |
break;
|
|
sl@0
|
376 |
case ESqlSrvDbGetReserveAccess:
|
|
sl@0
|
377 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
378 |
DbGetReserveAccessL();
|
|
sl@0
|
379 |
break;
|
|
sl@0
|
380 |
case ESqlSrvDbReleaseReserveAccess:
|
|
sl@0
|
381 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
382 |
DbReleaseReserveAccess();
|
|
sl@0
|
383 |
break;
|
|
sl@0
|
384 |
////////////////////// BLOB source ///////////////////////////////////////////
|
|
sl@0
|
385 |
case ESqlSrvDbBlobSource:
|
|
sl@0
|
386 |
retCode = DbBlobSourceL(aMessage); //Returns the BLOB handle
|
|
sl@0
|
387 |
break;
|
|
sl@0
|
388 |
////////////////////// statement operations //////////////////////////////////
|
|
sl@0
|
389 |
case ESqlSrvStmtPrepare8:
|
|
sl@0
|
390 |
retCode = StmtPrepareL(aMessage, EFalse);//returns the statement handle
|
|
sl@0
|
391 |
break;
|
|
sl@0
|
392 |
case ESqlSrvStmtPrepare16:
|
|
sl@0
|
393 |
retCode = StmtPrepareL(aMessage, ETrue);//returns the statement handle
|
|
sl@0
|
394 |
break;
|
|
sl@0
|
395 |
case ESqlSrvStmtClose:
|
|
sl@0
|
396 |
iStatements.Remove(handle);
|
|
sl@0
|
397 |
break;
|
|
sl@0
|
398 |
case ESqlSrvStmtReset:
|
|
sl@0
|
399 |
retCode = ::SqlSessObjFind(iStatements, handle, aMessage).Reset();//May return that the statement has expired
|
|
sl@0
|
400 |
break;
|
|
sl@0
|
401 |
case ESqlSrvStmtExec:
|
|
sl@0
|
402 |
case ESqlSrvStmtAsyncExec:
|
|
sl@0
|
403 |
case ESqlSrvStmtBindExec:
|
|
sl@0
|
404 |
case ESqlSrvStmtAsyncBindExec:
|
|
sl@0
|
405 |
retCode = StmtExecL(aMessage, handle, funcCode);//returns the count of affected records
|
|
sl@0
|
406 |
break;
|
|
sl@0
|
407 |
case ESqlSrvStmtNext:
|
|
sl@0
|
408 |
case ESqlSrvStmtBindNext:
|
|
sl@0
|
409 |
retCode = StmtNextL(aMessage, handle, funcCode);//returns a non-negative number if the client side buffer is too small
|
|
sl@0
|
410 |
break;
|
|
sl@0
|
411 |
case ESqlSrvStmtColumnNames:
|
|
sl@0
|
412 |
case ESqlSrvStmtParamNames:
|
|
sl@0
|
413 |
retCode = StmtNamesL(aMessage, handle, funcCode);//returns a non-negative number if the client side buffer is too small
|
|
sl@0
|
414 |
break;
|
|
sl@0
|
415 |
case ESqlSrvStmtColumnSource:
|
|
sl@0
|
416 |
retCode = StmtColumnSourceL(aMessage, handle);//returns an IPC stream handle
|
|
sl@0
|
417 |
break;
|
|
sl@0
|
418 |
case ESqlSrvStmtBinParamSink:
|
|
sl@0
|
419 |
case ESqlSrvStmtTxtParamSink16:
|
|
sl@0
|
420 |
retCode = StmtParamSinkL(aMessage, handle, funcCode);//returns an IPC stream handle
|
|
sl@0
|
421 |
break;
|
|
sl@0
|
422 |
case ESqlSrvStmtBufFlat:
|
|
sl@0
|
423 |
StmtGetBufFlatL(aMessage, handle);
|
|
sl@0
|
424 |
break;
|
|
sl@0
|
425 |
case ESqlSrvStmtColumnValue:
|
|
sl@0
|
426 |
StmtColumnValueL(aMessage, handle);
|
|
sl@0
|
427 |
break;
|
|
sl@0
|
428 |
case ESqlSrvStmtDeclColumnTypes:
|
|
sl@0
|
429 |
retCode = StmtDeclColumnTypesL(aMessage, handle);
|
|
sl@0
|
430 |
break;
|
|
sl@0
|
431 |
////////////////////// stream operations //////////////////////////////////
|
|
sl@0
|
432 |
case ESqlSrvStreamRead:
|
|
sl@0
|
433 |
retCode = ::SqlSessObjFind(iIpcStreams, handle, aMessage).ReadL(aMessage);
|
|
sl@0
|
434 |
break;
|
|
sl@0
|
435 |
case ESqlSrvStreamWrite:
|
|
sl@0
|
436 |
::SqlSessObjFind(iIpcStreams, handle, aMessage).WriteL(aMessage);
|
|
sl@0
|
437 |
break;
|
|
sl@0
|
438 |
case ESqlSrvStreamSize:
|
|
sl@0
|
439 |
retCode = ::SqlSessObjFind(iIpcStreams, handle, aMessage).SizeL();
|
|
sl@0
|
440 |
break;
|
|
sl@0
|
441 |
case ESqlSrvStreamSynch:
|
|
sl@0
|
442 |
::SqlSessObjFind(iIpcStreams, handle, aMessage).SynchL();
|
|
sl@0
|
443 |
break;
|
|
sl@0
|
444 |
case ESqlSrvStreamClose:
|
|
sl@0
|
445 |
iIpcStreams.Remove(handle);
|
|
sl@0
|
446 |
break;
|
|
sl@0
|
447 |
////////////////////// //////////////////////////////////
|
|
sl@0
|
448 |
default:
|
|
sl@0
|
449 |
retCode = KErrNotSupported;
|
|
sl@0
|
450 |
break;
|
|
sl@0
|
451 |
}
|
|
sl@0
|
452 |
Server().Compactor().RestartTimer();
|
|
sl@0
|
453 |
Server().MinimizeBuffers();
|
|
sl@0
|
454 |
if(!aMessage.IsNull())
|
|
sl@0
|
455 |
{
|
|
sl@0
|
456 |
aMessage.Complete(retCode);
|
|
sl@0
|
457 |
}
|
|
sl@0
|
458 |
SQL_TRACE_SESSION(OstTraceExt4(TRACE_INTERNALS, CSQLSRVSESSION_SERVICEL_EXIT, "Exit;0x%X;CSqlSrvSession::ServiceL;funcCode=0x%X;retCode=%d;iIpcCallCounter=%u", (TUint)this, (TUint)funcCode, retCode, iIpcCallCounter));
|
|
sl@0
|
459 |
}
|
|
sl@0
|
460 |
|
|
sl@0
|
461 |
/**
|
|
sl@0
|
462 |
If aError is KErrBadDescriptor, then panic the client, else - default error handling.
|
|
sl@0
|
463 |
KErrBadDescriptor error may be thrown from "message write" operations, if the client supplied a bad
|
|
sl@0
|
464 |
descriptor to the server.
|
|
sl@0
|
465 |
*/
|
|
sl@0
|
466 |
void CSqlSrvSession::ServiceError(const RMessage2& aMessage, TInt aError)
|
|
sl@0
|
467 |
{
|
|
sl@0
|
468 |
SQL_TRACE_SESSION(OstTraceExt4(TRACE_INTERNALS, CSQLSRVSESSION_SERVICEERROR_ENTRY, "Entry;0x%X;CSqlSrvSession::ServiceError;aMessage.Function()=0x%X;aError=%d;iIpcCallCounter=%u", (TUint)this, (TUint)aMessage.Function(), aError, iIpcCallCounter));
|
|
sl@0
|
469 |
Server().MinimizeBuffers();
|
|
sl@0
|
470 |
aError = ::ConvertSqlFull2DiskFullErr(aError, Server().FileData().Fs(), iDrive);
|
|
sl@0
|
471 |
if(aError == KErrBadDescriptor)
|
|
sl@0
|
472 |
{
|
|
sl@0
|
473 |
//The __SQLPANIC_CLIENT() macro cannot be used here because it calls a leaving function. A leaving call
|
|
sl@0
|
474 |
//from a leaving call will terminate the server.
|
|
sl@0
|
475 |
_LIT(KPanicCategory, "SqlDb");
|
|
sl@0
|
476 |
aMessage.Panic(KPanicCategory, ESqlPanicBadDescriptor);
|
|
sl@0
|
477 |
}
|
|
sl@0
|
478 |
SQLPROFILER_IPC_ERROR(iIpcCallCounter, static_cast <TSqlSrvFunction> (KSqlSrvFunctionMask & aMessage.Function()),
|
|
sl@0
|
479 |
iDatabase ? (TUint)iDatabase->RawDbHandle() : 0, aError);
|
|
sl@0
|
480 |
CSession2::ServiceError(aMessage, aError);
|
|
sl@0
|
481 |
SQL_TRACE_SESSION(OstTraceExt3(TRACE_INTERNALS, CSQLSRVSESSION_SERVICEERROR_EXIT, "Exit;0x%X;CSqlSrvSession::ServiceError;aMessage.Function()=0x%X;iIpcCallCounter=%u", (TUint)this, (TUint)aMessage.Function(), iIpcCallCounter));
|
|
sl@0
|
482 |
}
|
|
sl@0
|
483 |
|
|
sl@0
|
484 |
///////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
485 |
//////////////////////////// Profiler operations ///////////////////////////////////
|
|
sl@0
|
486 |
///////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
487 |
|
|
sl@0
|
488 |
#pragma BullseyeCoverage off
|
|
sl@0
|
489 |
|
|
sl@0
|
490 |
/**
|
|
sl@0
|
491 |
Retrieves the counter values for the specified profiling counter.
|
|
sl@0
|
492 |
|
|
sl@0
|
493 |
@leave KErrNone, the operation completed successfully,
|
|
sl@0
|
494 |
KErrOverflow, the receiving buffer size is too small;
|
|
sl@0
|
495 |
One of the other system-wide error codes may also be returned.
|
|
sl@0
|
496 |
|
|
sl@0
|
497 |
@see TSqlResourceProfiler
|
|
sl@0
|
498 |
|
|
sl@0
|
499 |
Usage of the IPC call arguments:
|
|
sl@0
|
500 |
- Arg 0: [in] profiling counter type, one of the TSqlResourceProfiler::TSqlCounter enum item values.
|
|
sl@0
|
501 |
- Arg 1: [in] the size of the buffer for the profiling counter values.
|
|
sl@0
|
502 |
- Arg 2: [out] the buffer for the profiling counter values.
|
|
sl@0
|
503 |
|
|
sl@0
|
504 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
505 |
*/
|
|
sl@0
|
506 |
void CSqlSrvSession::ProfilerQueryL(const RMessage2& aMessage)
|
|
sl@0
|
507 |
{
|
|
sl@0
|
508 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
509 |
if(aMessage.Int0() == TSqlResourceProfiler::ESqlCounterConfig)
|
|
sl@0
|
510 |
{
|
|
sl@0
|
511 |
const TInt KConfigBufLen = 128;
|
|
sl@0
|
512 |
if(aMessage.Int1() < KConfigBufLen)
|
|
sl@0
|
513 |
{
|
|
sl@0
|
514 |
__SQLLEAVE(KErrOverflow);
|
|
sl@0
|
515 |
}
|
|
sl@0
|
516 |
TBuf8<KConfigBufLen> res;
|
|
sl@0
|
517 |
iDatabase->QueryConfigL(res);
|
|
sl@0
|
518 |
aMessage.WriteL(2, res);
|
|
sl@0
|
519 |
}
|
|
sl@0
|
520 |
else
|
|
sl@0
|
521 |
{
|
|
sl@0
|
522 |
TSqlSrvResourceProfiler::QueryL(aMessage);
|
|
sl@0
|
523 |
}
|
|
sl@0
|
524 |
}
|
|
sl@0
|
525 |
|
|
sl@0
|
526 |
#pragma BullseyeCoverage on
|
|
sl@0
|
527 |
|
|
sl@0
|
528 |
///////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
529 |
//////////////////////////// Database operations ///////////////////////////////////
|
|
sl@0
|
530 |
///////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
531 |
|
|
sl@0
|
532 |
/**
|
|
sl@0
|
533 |
Processes the request for creating/opening a database.
|
|
sl@0
|
534 |
|
|
sl@0
|
535 |
The function initializes iDatabase and iDrive data members.
|
|
sl@0
|
536 |
|
|
sl@0
|
537 |
Usage of the IPC call arguments:
|
|
sl@0
|
538 |
Arg 0: [in] database file name length in 16-bit characters
|
|
sl@0
|
539 |
Arg 1: [in] database file name
|
|
sl@0
|
540 |
Arg 2: [in] PPPPCCCC, where PPPP is the security policy length, CCCC is the config string length.
|
|
sl@0
|
541 |
Arg 3: [in] security policies buffer | config string
|
|
sl@0
|
542 |
|
|
sl@0
|
543 |
@panic SqlDb 1 Client panic. iDatabase is not NULL (it has been created already)
|
|
sl@0
|
544 |
@panic SqlDb 4 Client panic. Negative or too big config string length
|
|
sl@0
|
545 |
@panic SqlDb 4 Client panic. Negative security policy length, or zero length if the request is to create a secure database
|
|
sl@0
|
546 |
*/
|
|
sl@0
|
547 |
void CSqlSrvSession::DbCreateObjectL(const RMessage2& aMessage, TSqlSrvFunction aFunction)
|
|
sl@0
|
548 |
{
|
|
sl@0
|
549 |
__SQLPANIC_CLIENT(!iDatabase, aMessage, ESqlPanicObjExists);
|
|
sl@0
|
550 |
const TInt KSecurityPolicyLen = (aMessage.Int2() & 0x7fff0000) >> 16;
|
|
sl@0
|
551 |
//If the security policy length is negative then this is a programming error.
|
|
sl@0
|
552 |
__SQLPANIC_CLIENT(KSecurityPolicyLen >= 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
553 |
const TInt KConfigStringLen = aMessage.Int2() & 0xffff;
|
|
sl@0
|
554 |
//If KConfigStringLen is invalid then this is a programming error.
|
|
sl@0
|
555 |
//If the client sends a too big config string - this is handled in the client side session.
|
|
sl@0
|
556 |
__SQLPANIC_CLIENT((TUint)KConfigStringLen <= KSqlSrvMaxConfigStrLen, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
557 |
RBuf8 securityAndConfigBuf;
|
|
sl@0
|
558 |
CleanupClosePushL(securityAndConfigBuf);
|
|
sl@0
|
559 |
if((KSecurityPolicyLen + KConfigStringLen) > 0)
|
|
sl@0
|
560 |
{
|
|
sl@0
|
561 |
securityAndConfigBuf.CreateL(KSecurityPolicyLen + KConfigStringLen);
|
|
sl@0
|
562 |
aMessage.ReadL(3, securityAndConfigBuf);
|
|
sl@0
|
563 |
SQLPROFILER_REPORT_IPC(ESqlIpcRead, (KSecurityPolicyLen + KConfigStringLen));
|
|
sl@0
|
564 |
}
|
|
sl@0
|
565 |
TSqlSrvFileData& fileData = Server().FileData();
|
|
sl@0
|
566 |
TPtrC8 configStr(KNullDesC8);
|
|
sl@0
|
567 |
if(KConfigStringLen > 0)
|
|
sl@0
|
568 |
{
|
|
sl@0
|
569 |
configStr.Set(securityAndConfigBuf.Mid(KSecurityPolicyLen));//the first part of the buffer is for the security policies
|
|
sl@0
|
570 |
}
|
|
sl@0
|
571 |
fileData.SetL(aMessage, aMessage.Int0(), 1, &configStr);
|
|
sl@0
|
572 |
iDrive = fileData.Drive();
|
|
sl@0
|
573 |
switch(aFunction)
|
|
sl@0
|
574 |
{
|
|
sl@0
|
575 |
case ESqlSrvDbCreate:
|
|
sl@0
|
576 |
if(fileData.IsSecureFileNameFmt())
|
|
sl@0
|
577 |
{
|
|
sl@0
|
578 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
579 |
}
|
|
sl@0
|
580 |
iDatabase = CSqlSrvDatabase::CreateL(fileData);
|
|
sl@0
|
581 |
break;
|
|
sl@0
|
582 |
case ESqlSrvDbCreateSecure:
|
|
sl@0
|
583 |
{
|
|
sl@0
|
584 |
__SQLPANIC_CLIENT(KSecurityPolicyLen > 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
585 |
if(!fileData.IsSecureFileNameFmt())
|
|
sl@0
|
586 |
{
|
|
sl@0
|
587 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
588 |
}
|
|
sl@0
|
589 |
//The caller can create a secure database which secure UID matches his secure UID.
|
|
sl@0
|
590 |
if(fileData.SecureUid() != aMessage.SecureId())
|
|
sl@0
|
591 |
{
|
|
sl@0
|
592 |
__SQLLEAVE(KErrPermissionDenied);
|
|
sl@0
|
593 |
}
|
|
sl@0
|
594 |
CSqlSecurityPolicy* policy = CreateSecurityPolicyL(securityAndConfigBuf.Left(KSecurityPolicyLen));
|
|
sl@0
|
595 |
iDatabase = CSqlSrvDatabase::CreateSecureL(fileData, policy);
|
|
sl@0
|
596 |
}
|
|
sl@0
|
597 |
break;
|
|
sl@0
|
598 |
case ESqlSrvDbOpen:
|
|
sl@0
|
599 |
iDatabase = CSqlSrvDatabase::OpenL(fileData);
|
|
sl@0
|
600 |
break;
|
|
sl@0
|
601 |
default:
|
|
sl@0
|
602 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
603 |
break;
|
|
sl@0
|
604 |
}
|
|
sl@0
|
605 |
CleanupStack::PopAndDestroy(&securityAndConfigBuf);
|
|
sl@0
|
606 |
}
|
|
sl@0
|
607 |
|
|
sl@0
|
608 |
/**
|
|
sl@0
|
609 |
Processes the request for opening a database from file handle.
|
|
sl@0
|
610 |
The server expects that the database to be opened/created is in the applicatio's private data cage.
|
|
sl@0
|
611 |
|
|
sl@0
|
612 |
Usage of the IPC call arguments:
|
|
sl@0
|
613 |
- Arg 0: [in] The 32 bits of the argument are used as follow:
|
|
sl@0
|
614 |
@code
|
|
sl@0
|
615 |
MSB LSB
|
|
sl@0
|
616 |
31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
|
|
sl@0
|
617 |
Ro Cr C C C C C C C C C C C C C C F F F F F F F F F F F F F F F F
|
|
sl@0
|
618 |
@endcode
|
|
sl@0
|
619 |
Where:
|
|
sl@0
|
620 |
@code
|
|
sl@0
|
621 |
- "Ro" - read-only flag, true if the file is read-only;
|
|
sl@0
|
622 |
- "Cr" - create/open flag, true if the file was created, false if the file was opened;
|
|
sl@0
|
623 |
- "C" - config string length in 16-bit characters;
|
|
sl@0
|
624 |
- "F" - database file name length in 16-bit characters;
|
|
sl@0
|
625 |
@endcode
|
|
sl@0
|
626 |
- Arg 1: [in] database file name | config string
|
|
sl@0
|
627 |
- Arg 2: [in] file session handle
|
|
sl@0
|
628 |
- Arg 3: [in] database file handle
|
|
sl@0
|
629 |
|
|
sl@0
|
630 |
@panic SqlDb 1 Client panic. iDatabase is not NULL (it has been created already)
|
|
sl@0
|
631 |
*/
|
|
sl@0
|
632 |
void CSqlSrvSession::DbCreateObjectFromHandleL(const RMessage2& aMessage)
|
|
sl@0
|
633 |
{
|
|
sl@0
|
634 |
__SQLPANIC_CLIENT(!iDatabase, aMessage, ESqlPanicObjExists);
|
|
sl@0
|
635 |
const TBool KReadOnly = (aMessage.Int0() & 0x80000000) != 0;
|
|
sl@0
|
636 |
const TBool KCreated = (aMessage.Int0() & 0x40000000) != 0;
|
|
sl@0
|
637 |
const TInt KDbFileNameLen = aMessage.Int0() & 0x0000FFFF;
|
|
sl@0
|
638 |
const TInt KConfigStringLen = (aMessage.Int0() & 0x3FFF0000) >> 16;
|
|
sl@0
|
639 |
__SQLPANIC_CLIENT((TUint)KConfigStringLen <= KSqlSrvMaxConfigStrLen, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
640 |
__SQLPANIC_CLIENT((TUint)KDbFileNameLen <= KMaxFileName, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
641 |
TDes16& buffer = Server().GetBuf16L(KDbFileNameLen + KConfigStringLen);
|
|
sl@0
|
642 |
aMessage.ReadL(1, buffer);
|
|
sl@0
|
643 |
SQLPROFILER_REPORT_IPC(ESqlIpcRead, ((KDbFileNameLen + KConfigStringLen) * sizeof(TText)));
|
|
sl@0
|
644 |
TFileName dbFileName;
|
|
sl@0
|
645 |
dbFileName.Copy(buffer.LeftTPtr(KDbFileNameLen));
|
|
sl@0
|
646 |
TBuf8<KSqlSrvMaxConfigStrLen> configStr;
|
|
sl@0
|
647 |
if(KConfigStringLen > 0)
|
|
sl@0
|
648 |
{
|
|
sl@0
|
649 |
configStr.Copy(buffer.MidTPtr(KDbFileNameLen, KConfigStringLen));
|
|
sl@0
|
650 |
}
|
|
sl@0
|
651 |
TSqlSrvFileData& fileData = Server().FileData();
|
|
sl@0
|
652 |
fileData.SetFromHandleL(aMessage, dbFileName, KCreated, KReadOnly, &configStr);
|
|
sl@0
|
653 |
iDrive = fileData.Drive();
|
|
sl@0
|
654 |
iDatabase = CSqlSrvDatabase::OpenL(fileData);
|
|
sl@0
|
655 |
}
|
|
sl@0
|
656 |
|
|
sl@0
|
657 |
/**
|
|
sl@0
|
658 |
Processes the request for copying a database.
|
|
sl@0
|
659 |
|
|
sl@0
|
660 |
Only the database creator can copy the database if the database is a secure database.
|
|
sl@0
|
661 |
|
|
sl@0
|
662 |
Usage of the IPC call arguments:
|
|
sl@0
|
663 |
Arg 0: [in] source database file name length
|
|
sl@0
|
664 |
Arg 1: [in] source database file name
|
|
sl@0
|
665 |
Arg 2: [in] destination database file name length
|
|
sl@0
|
666 |
Arg 3: [in] destination database file name
|
|
sl@0
|
667 |
*/
|
|
sl@0
|
668 |
void CSqlSrvSession::DbCopyFileL(const RMessage2& aMessage)
|
|
sl@0
|
669 |
{
|
|
sl@0
|
670 |
const TInt KDbCnt = 2; //"2" - because we have 2 dbases: src and dest
|
|
sl@0
|
671 |
const TInt KSrcDbIdx = 0;
|
|
sl@0
|
672 |
const TInt KDestDbIdx = 1;
|
|
sl@0
|
673 |
TInt fileNameLen[KDbCnt] = {aMessage.Int0(), aMessage.Int2()};
|
|
sl@0
|
674 |
TSqlSrvFileData& fileData = Server().FileData();
|
|
sl@0
|
675 |
TUint dbSecureFlag[KDbCnt];
|
|
sl@0
|
676 |
TUid dbSID[KDbCnt] = {KNullUid, KNullUid};
|
|
sl@0
|
677 |
TFileName dbFileName[KDbCnt];
|
|
sl@0
|
678 |
//Initialize dbSecureFlag[], dbSID[] and dbFileName[] array elements
|
|
sl@0
|
679 |
for(TInt i=0;i<KDbCnt;++i)
|
|
sl@0
|
680 |
{
|
|
sl@0
|
681 |
fileData.SetL(aMessage, fileNameLen[i], i * KDbCnt + 1); //"i * KDbCnt + 1" is the RMessage2 parameter number: 1 for src db, 3 for dest db
|
|
sl@0
|
682 |
dbSecureFlag[i] = fileData.IsSecureFileNameFmt() ? 1 : 0;
|
|
sl@0
|
683 |
if(dbSecureFlag[i])
|
|
sl@0
|
684 |
{
|
|
sl@0
|
685 |
dbSID[i] = fileData.SecureUid();
|
|
sl@0
|
686 |
}
|
|
sl@0
|
687 |
dbFileName[i].Copy(fileData.FileName());
|
|
sl@0
|
688 |
}
|
|
sl@0
|
689 |
//It is not allowed to copy non-secure to a secure or secure to a non-secure database.
|
|
sl@0
|
690 |
if(dbSecureFlag[KSrcDbIdx] ^ dbSecureFlag[KDestDbIdx])
|
|
sl@0
|
691 |
{
|
|
sl@0
|
692 |
__SQLLEAVE(KErrPermissionDenied);
|
|
sl@0
|
693 |
}
|
|
sl@0
|
694 |
//If this is a secure database "copy" operation, then...
|
|
sl@0
|
695 |
if(dbSecureFlag[KSrcDbIdx])
|
|
sl@0
|
696 |
{
|
|
sl@0
|
697 |
TUid callerSid = aMessage.SecureId();
|
|
sl@0
|
698 |
//A secure database can be copied only by its owner (database SID matches caller SID).
|
|
sl@0
|
699 |
if(callerSid != dbSID[KSrcDbIdx] || callerSid != dbSID[KDestDbIdx])
|
|
sl@0
|
700 |
{
|
|
sl@0
|
701 |
__SQLLEAVE(KErrPermissionDenied);
|
|
sl@0
|
702 |
}
|
|
sl@0
|
703 |
}
|
|
sl@0
|
704 |
//Copy the database
|
|
sl@0
|
705 |
CFileMan* fileMan = CFileMan::NewL(fileData.Fs());
|
|
sl@0
|
706 |
CleanupStack::PushL(fileMan);
|
|
sl@0
|
707 |
__SQLLEAVE_IF_ERROR(fileMan->Copy(dbFileName[KSrcDbIdx], dbFileName[KDestDbIdx]));
|
|
sl@0
|
708 |
//"Copy" operation executed without errors. Now it is a time to turn off the read-only
|
|
sl@0
|
709 |
//flag of the target file (which may be on if the source file is on a read-only drive)
|
|
sl@0
|
710 |
__SQLLEAVE_IF_ERROR(fileData.Fs().SetAtt(dbFileName[KDestDbIdx], 0, KEntryAttReadOnly));
|
|
sl@0
|
711 |
CleanupStack::PopAndDestroy(fileMan);
|
|
sl@0
|
712 |
}
|
|
sl@0
|
713 |
|
|
sl@0
|
714 |
/**
|
|
sl@0
|
715 |
Processes the request for deleting a database.
|
|
sl@0
|
716 |
|
|
sl@0
|
717 |
Only the database creator can delete the database if the database is a secure database.
|
|
sl@0
|
718 |
|
|
sl@0
|
719 |
Usage of the IPC call arguments:
|
|
sl@0
|
720 |
Arg 0: [in] database file name length
|
|
sl@0
|
721 |
Arg 1: [in] database file name
|
|
sl@0
|
722 |
*/
|
|
sl@0
|
723 |
void CSqlSrvSession::DbDeleteFileL(const RMessage2& aMessage)
|
|
sl@0
|
724 |
{
|
|
sl@0
|
725 |
TSqlSrvFileData& fileData = Server().FileData();
|
|
sl@0
|
726 |
fileData.SetL(aMessage, aMessage.Int0(), 1);
|
|
sl@0
|
727 |
if(fileData.IsSecureFileNameFmt())
|
|
sl@0
|
728 |
{
|
|
sl@0
|
729 |
//A secure database can be deleted only by its owner (database SID matches caller SID).
|
|
sl@0
|
730 |
if(fileData.SecureUid() != aMessage.SecureId())
|
|
sl@0
|
731 |
{
|
|
sl@0
|
732 |
__SQLLEAVE(KErrPermissionDenied);
|
|
sl@0
|
733 |
}
|
|
sl@0
|
734 |
}
|
|
sl@0
|
735 |
__SQLTRACE_SESSIONVAR(TPtrC fname(fileData.FileName()));
|
|
sl@0
|
736 |
SQL_TRACE_SESSION(OstTraceExt2(TRACE_INTERNALS, CSQLSRVSESSION_DBDELETEFILEL, "0x%X;CSqlSrvSession::DbDeleteFileL;file='%S'", (TUint)this, __SQLPRNSTR(fname)));
|
|
sl@0
|
737 |
__SQLLEAVE_IF_ERROR(fileData.Fs().Delete(fileData.FileName()));
|
|
sl@0
|
738 |
}
|
|
sl@0
|
739 |
|
|
sl@0
|
740 |
/**
|
|
sl@0
|
741 |
Processes the request for retrieving the last error message.
|
|
sl@0
|
742 |
|
|
sl@0
|
743 |
If the client side buffer size is not big enough, the function returns the needed
|
|
sl@0
|
744 |
buffer size + KSqlClientBufOverflowCode.
|
|
sl@0
|
745 |
In this case the client must increase the buffer and try again to get the message.
|
|
sl@0
|
746 |
|
|
sl@0
|
747 |
Usage of the IPC call arguments:
|
|
sl@0
|
748 |
Arg 0: [in] Message buffer length in 16-bit characters
|
|
sl@0
|
749 |
Arg 1: [in/out] Message buffer
|
|
sl@0
|
750 |
|
|
sl@0
|
751 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
752 |
@panic SqlDb 4 Client panic. Negative client message buffer length (Arg 0).
|
|
sl@0
|
753 |
*/
|
|
sl@0
|
754 |
TInt CSqlSrvSession::DbLastErrorMessageL(const RMessage2& aMessage)
|
|
sl@0
|
755 |
{
|
|
sl@0
|
756 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
757 |
TPtrC msg = iDatabase->LastErrorMessage();
|
|
sl@0
|
758 |
TInt msgLen = msg.Length();
|
|
sl@0
|
759 |
TInt bufSize = aMessage.Int0();
|
|
sl@0
|
760 |
__SQLPANIC_CLIENT(bufSize >= 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
761 |
if(msgLen <= bufSize)
|
|
sl@0
|
762 |
{
|
|
sl@0
|
763 |
aMessage.WriteL(1, msg);
|
|
sl@0
|
764 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, (msgLen * sizeof(TText)));
|
|
sl@0
|
765 |
return 0;
|
|
sl@0
|
766 |
}
|
|
sl@0
|
767 |
return msgLen + KSqlClientBufOverflowCode;
|
|
sl@0
|
768 |
}
|
|
sl@0
|
769 |
|
|
sl@0
|
770 |
/**
|
|
sl@0
|
771 |
Processes the request for retrieving the last inserted ROWID of this database connection.
|
|
sl@0
|
772 |
|
|
sl@0
|
773 |
Usage of the IPC call arguments:
|
|
sl@0
|
774 |
Arg 0: [in/out] Receiving buffer
|
|
sl@0
|
775 |
|
|
sl@0
|
776 |
@panic SqlDb 2 Client panic. The database object is not yet created yet (iDatabase is NULL).
|
|
sl@0
|
777 |
*/
|
|
sl@0
|
778 |
void CSqlSrvSession::DbLastInsertedRowIdL(const RMessage2& aMessage)
|
|
sl@0
|
779 |
{
|
|
sl@0
|
780 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
781 |
TInt64 rowid = iDatabase->LastInsertedRowId();
|
|
sl@0
|
782 |
aMessage.WriteL(0, TPtrC8(reinterpret_cast <const TUint8*> (&rowid), sizeof(rowid)));
|
|
sl@0
|
783 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, sizeof(rowid));
|
|
sl@0
|
784 |
}
|
|
sl@0
|
785 |
|
|
sl@0
|
786 |
/**
|
|
sl@0
|
787 |
Processes the request for retrieving the database security policies.
|
|
sl@0
|
788 |
|
|
sl@0
|
789 |
The method leaves with KErrNotSupported if the database is not a secure database.
|
|
sl@0
|
790 |
|
|
sl@0
|
791 |
If the client side buffer size is not big enough, the function returns the needed
|
|
sl@0
|
792 |
buffer size + KSqlClientBufOverflowCode.
|
|
sl@0
|
793 |
In this case the client must increase the buffer and try again to get the database security policy.
|
|
sl@0
|
794 |
|
|
sl@0
|
795 |
Usage of the IPC call arguments:
|
|
sl@0
|
796 |
Arg 0: [in] security policy buffer length in bytes
|
|
sl@0
|
797 |
Arg 1: [in/out] buffer for the database security policies
|
|
sl@0
|
798 |
|
|
sl@0
|
799 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
800 |
*/
|
|
sl@0
|
801 |
TInt CSqlSrvSession::DbGetSecurityPolicyL(const RMessage2& aMessage)
|
|
sl@0
|
802 |
{
|
|
sl@0
|
803 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
804 |
const CSqlSecurityPolicy* securityPolicy = iDatabase->SecurityPolicy();
|
|
sl@0
|
805 |
if(!securityPolicy)
|
|
sl@0
|
806 |
{
|
|
sl@0
|
807 |
__SQLLEAVE(KErrNotSupported);
|
|
sl@0
|
808 |
}
|
|
sl@0
|
809 |
const RSqlBufFlat& bufFlat = securityPolicy->BufFlat();
|
|
sl@0
|
810 |
TInt size = bufFlat.Size();
|
|
sl@0
|
811 |
if(size <= aMessage.Int0())
|
|
sl@0
|
812 |
{
|
|
sl@0
|
813 |
aMessage.WriteL(1, bufFlat.BufDes());
|
|
sl@0
|
814 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, size);
|
|
sl@0
|
815 |
return 0;
|
|
sl@0
|
816 |
}
|
|
sl@0
|
817 |
return size + KSqlClientBufOverflowCode;
|
|
sl@0
|
818 |
}
|
|
sl@0
|
819 |
|
|
sl@0
|
820 |
/**
|
|
sl@0
|
821 |
If an error occurs during the execution the function leaves with the error code.
|
|
sl@0
|
822 |
Possible non-leaving return values:
|
|
sl@0
|
823 |
- KErrNone - the function has completed successfully;
|
|
sl@0
|
824 |
- Positive return value - the length of the column, which means - the destination buffer is too small.
|
|
sl@0
|
825 |
This return value is possible only with text or binary columns.
|
|
sl@0
|
826 |
|
|
sl@0
|
827 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
828 |
|
|
sl@0
|
829 |
Usage of the IPC call arguments:
|
|
sl@0
|
830 |
Arg 0: [in] (8/16-bit character length of SQL statement) | (expected column value type << 24).
|
|
sl@0
|
831 |
Arg 1: [in] SQL statement.
|
|
sl@0
|
832 |
Arg 2: [in] Byte max length of the receiving buffer
|
|
sl@0
|
833 |
Arg 3: [in/out] The receiving buffer
|
|
sl@0
|
834 |
*/
|
|
sl@0
|
835 |
TInt CSqlSrvSession::DbScalarFullSelectL(const RMessage2& aMessage, TBool aIsText16)
|
|
sl@0
|
836 |
{
|
|
sl@0
|
837 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
838 |
TUint sqlLen = static_cast <TUint> (aMessage.Int0()) & 0x00FFFFFF;
|
|
sl@0
|
839 |
TSqlColumnType colType = static_cast <TSqlColumnType> ((static_cast <TUint> (aMessage.Int0()) & 0xFF000000) >> 24);
|
|
sl@0
|
840 |
TInt columnCount = -1;
|
|
sl@0
|
841 |
TInt paramCount = -1;
|
|
sl@0
|
842 |
CSqlSrvStatement* stmt = aIsText16 ?
|
|
sl@0
|
843 |
CSqlSrvStatement::NewLC(iDatabase->RawDbHandle(), ReadString16ZL(aMessage, 1, sqlLen), columnCount, paramCount) :
|
|
sl@0
|
844 |
CSqlSrvStatement::NewLC(iDatabase->RawDbHandle(), ReadString8ZL(aMessage, 1, sqlLen), columnCount, paramCount);
|
|
sl@0
|
845 |
if(columnCount != 1 || paramCount != 0)
|
|
sl@0
|
846 |
{
|
|
sl@0
|
847 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
848 |
}
|
|
sl@0
|
849 |
TInt err = stmt->Next();
|
|
sl@0
|
850 |
if(err == KSqlAtRow)
|
|
sl@0
|
851 |
{
|
|
sl@0
|
852 |
err = GetColumnValueL(aMessage, *stmt, colType);
|
|
sl@0
|
853 |
}
|
|
sl@0
|
854 |
else
|
|
sl@0
|
855 |
{
|
|
sl@0
|
856 |
__SQLLEAVE(err == KSqlAtEnd ? KErrNotFound : err);
|
|
sl@0
|
857 |
}
|
|
sl@0
|
858 |
CleanupStack::PopAndDestroy(stmt);
|
|
sl@0
|
859 |
return err;
|
|
sl@0
|
860 |
}
|
|
sl@0
|
861 |
|
|
sl@0
|
862 |
/**
|
|
sl@0
|
863 |
@return True, if the database is in transaction, false otherwise.
|
|
sl@0
|
864 |
|
|
sl@0
|
865 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
866 |
*/
|
|
sl@0
|
867 |
TBool CSqlSrvSession::DbInTransaction(const RMessage2& aMessage)
|
|
sl@0
|
868 |
{
|
|
sl@0
|
869 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
870 |
return iDatabase->InTransaction();
|
|
sl@0
|
871 |
}
|
|
sl@0
|
872 |
|
|
sl@0
|
873 |
/**
|
|
sl@0
|
874 |
Main database size in bytes.
|
|
sl@0
|
875 |
|
|
sl@0
|
876 |
@return Main database size in bytes.
|
|
sl@0
|
877 |
|
|
sl@0
|
878 |
@leave KErrNoMemory, an out of memory condition has occurred,
|
|
sl@0
|
879 |
Note that the function may also leave with some other system wide errors or
|
|
sl@0
|
880 |
database specific errors categorised as ESqlDbError,
|
|
sl@0
|
881 |
KErrTooBig, The database is very big and the size cannot fit in a 32-bit signed integer.
|
|
sl@0
|
882 |
|
|
sl@0
|
883 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
884 |
*/
|
|
sl@0
|
885 |
TInt CSqlSrvSession::DbSizeL(const RMessage2& aMessage)
|
|
sl@0
|
886 |
{
|
|
sl@0
|
887 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
888 |
TInt64 size = iDatabase->SizeL();
|
|
sl@0
|
889 |
if(size > KMaxTInt)
|
|
sl@0
|
890 |
{
|
|
sl@0
|
891 |
__SQLLEAVE(KErrTooBig);
|
|
sl@0
|
892 |
}
|
|
sl@0
|
893 |
return size;
|
|
sl@0
|
894 |
}
|
|
sl@0
|
895 |
|
|
sl@0
|
896 |
/**
|
|
sl@0
|
897 |
Retrieves the database size and free space.
|
|
sl@0
|
898 |
|
|
sl@0
|
899 |
Usage of the IPC call arguments:
|
|
sl@0
|
900 |
Arg 0: [in/out] Points to a RSqlDatabase::TSize object, where the database size and free space values
|
|
sl@0
|
901 |
will be copied.
|
|
sl@0
|
902 |
Arg 1: [in] The database name length in 16-bit characters
|
|
sl@0
|
903 |
Arg 2: [in] The attached database name or KNullDesC for the main database
|
|
sl@0
|
904 |
|
|
sl@0
|
905 |
@leave KErrNoMemory, an out of memory condition has occurred,
|
|
sl@0
|
906 |
Note that the function may also leave with some other system wide errors or
|
|
sl@0
|
907 |
database specific errors categorised as ESqlDbError.
|
|
sl@0
|
908 |
KErrBadName, Invalid database name
|
|
sl@0
|
909 |
|
|
sl@0
|
910 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
911 |
*/
|
|
sl@0
|
912 |
void CSqlSrvSession::DbSize2L(const RMessage2& aMessage)
|
|
sl@0
|
913 |
{
|
|
sl@0
|
914 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
915 |
const TInt KDbNameLen = aMessage.Int1();
|
|
sl@0
|
916 |
if((TUint)KDbNameLen > KMaxFileName)
|
|
sl@0
|
917 |
{
|
|
sl@0
|
918 |
__SQLLEAVE(KErrBadName);
|
|
sl@0
|
919 |
}
|
|
sl@0
|
920 |
TPtrC dbName(KNullDesC);
|
|
sl@0
|
921 |
if(KDbNameLen > 0)
|
|
sl@0
|
922 |
{
|
|
sl@0
|
923 |
dbName.Set(ReadString16L(aMessage, 2, KDbNameLen));
|
|
sl@0
|
924 |
}
|
|
sl@0
|
925 |
TPckgBuf<RSqlDatabase::TSize> data;
|
|
sl@0
|
926 |
data().iSize = iDatabase->SizeL(dbName);
|
|
sl@0
|
927 |
data().iFree = iDatabase->FreeSpaceL(dbName);
|
|
sl@0
|
928 |
aMessage.WriteL(0, data);
|
|
sl@0
|
929 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, sizeof(RSqlDatabase::TSize));
|
|
sl@0
|
930 |
}
|
|
sl@0
|
931 |
|
|
sl@0
|
932 |
/**
|
|
sl@0
|
933 |
Runs database compaction.
|
|
sl@0
|
934 |
|
|
sl@0
|
935 |
Usage of the IPC call arguments:
|
|
sl@0
|
936 |
Arg 0: [in] How much space in bytes should be compacted, all free pages should be removed if the
|
|
sl@0
|
937 |
parameter value is RSqlDatabase::EMaxCompaction.
|
|
sl@0
|
938 |
Note that the requested space to be compacted will be rounded up to the nearest page count,
|
|
sl@0
|
939 |
e.g. request for removing 1 byte will remove one free page from the database file.
|
|
sl@0
|
940 |
Arg 1: [in] The database name length in characters
|
|
sl@0
|
941 |
Arg 2: [in] The attached database name or KNullDesC for the main database
|
|
sl@0
|
942 |
|
|
sl@0
|
943 |
@return The size of the removed free space
|
|
sl@0
|
944 |
|
|
sl@0
|
945 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
946 |
*/
|
|
sl@0
|
947 |
TInt CSqlSrvSession::DbCompactL(const RMessage2& aMessage)
|
|
sl@0
|
948 |
{
|
|
sl@0
|
949 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
950 |
const TInt KSize = aMessage.Int0();
|
|
sl@0
|
951 |
if(KSize < 0)
|
|
sl@0
|
952 |
{
|
|
sl@0
|
953 |
if(KSize != RSqlDatabase::EMaxCompaction)
|
|
sl@0
|
954 |
{
|
|
sl@0
|
955 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
956 |
}
|
|
sl@0
|
957 |
}
|
|
sl@0
|
958 |
if(KSize == 0)
|
|
sl@0
|
959 |
{
|
|
sl@0
|
960 |
return 0;
|
|
sl@0
|
961 |
}
|
|
sl@0
|
962 |
const TInt KDbNameLen = aMessage.Int1();
|
|
sl@0
|
963 |
if((TUint)KDbNameLen > KMaxFileName)
|
|
sl@0
|
964 |
{
|
|
sl@0
|
965 |
__SQLLEAVE(KErrBadName);
|
|
sl@0
|
966 |
}
|
|
sl@0
|
967 |
TPtrC dbName(KNullDesC);
|
|
sl@0
|
968 |
if(KDbNameLen > 0)
|
|
sl@0
|
969 |
{
|
|
sl@0
|
970 |
dbName.Set(ReadString16L(aMessage, 2, KDbNameLen));
|
|
sl@0
|
971 |
}
|
|
sl@0
|
972 |
return iDatabase->CompactL(KSize, dbName);
|
|
sl@0
|
973 |
}
|
|
sl@0
|
974 |
|
|
sl@0
|
975 |
/**
|
|
sl@0
|
976 |
Usage of the IPC call arguments:
|
|
sl@0
|
977 |
Arg 0: [in] requested size of the space to be reserved - not used
|
|
sl@0
|
978 |
|
|
sl@0
|
979 |
The function leaves with KErrAlreadyExists if a drive space has been reserved already by this session.
|
|
sl@0
|
980 |
*/
|
|
sl@0
|
981 |
void CSqlSrvSession::DbReserveDriveSpaceL()
|
|
sl@0
|
982 |
{
|
|
sl@0
|
983 |
if(iDriveSpaceReserved)
|
|
sl@0
|
984 |
{
|
|
sl@0
|
985 |
__SQLLEAVE(KErrAlreadyExists);
|
|
sl@0
|
986 |
}
|
|
sl@0
|
987 |
RSqlDriveSpaceCol& driveSpaceCol = Server().DriveSpaceCol();
|
|
sl@0
|
988 |
if(!driveSpaceCol.Find(iDrive))
|
|
sl@0
|
989 |
{
|
|
sl@0
|
990 |
(void)driveSpaceCol.AddL(iDrive);
|
|
sl@0
|
991 |
}
|
|
sl@0
|
992 |
|
|
sl@0
|
993 |
iDriveSpaceReserved = ETrue;
|
|
sl@0
|
994 |
//Only iDriveSpaceReserved is set, nothing more needs to be done, because RSqlDriveSpaceCol::AddL() will
|
|
sl@0
|
995 |
//reserve a drive space on the specified drive.
|
|
sl@0
|
996 |
//Although it looks like that the implementation can ommit "iDriveSpaceReserved" flag, this flag plays important
|
|
sl@0
|
997 |
//role, because it is used to ensure that every "reserve drive space" request is matched by a "free drive space"
|
|
sl@0
|
998 |
//call.
|
|
sl@0
|
999 |
}
|
|
sl@0
|
1000 |
|
|
sl@0
|
1001 |
/**
|
|
sl@0
|
1002 |
If the client has been given an access to the reserved drive space, that access will be released.
|
|
sl@0
|
1003 |
*/
|
|
sl@0
|
1004 |
void CSqlSrvSession::DbFreeReservedSpace()
|
|
sl@0
|
1005 |
{
|
|
sl@0
|
1006 |
DbReleaseReserveAccess();
|
|
sl@0
|
1007 |
iDriveSpaceReserved = EFalse;
|
|
sl@0
|
1008 |
}
|
|
sl@0
|
1009 |
|
|
sl@0
|
1010 |
/**
|
|
sl@0
|
1011 |
The function leaves with KErrInUse if an access to the reserved drive space has been given to the client.
|
|
sl@0
|
1012 |
The function leaves with KErrNotFound if no drive space has been reserved for the drive, where the database file is.
|
|
sl@0
|
1013 |
*/
|
|
sl@0
|
1014 |
void CSqlSrvSession::DbGetReserveAccessL()
|
|
sl@0
|
1015 |
{
|
|
sl@0
|
1016 |
if(iDriveSpaceInUse)
|
|
sl@0
|
1017 |
{
|
|
sl@0
|
1018 |
__SQLLEAVE(KErrInUse);
|
|
sl@0
|
1019 |
}
|
|
sl@0
|
1020 |
if(!iDriveSpaceReserved)
|
|
sl@0
|
1021 |
{
|
|
sl@0
|
1022 |
__SQLLEAVE(KErrNotFound);
|
|
sl@0
|
1023 |
}
|
|
sl@0
|
1024 |
CSqlDriveSpace* driveSpace = Server().DriveSpaceCol().Find(iDrive);
|
|
sl@0
|
1025 |
if(!driveSpace)
|
|
sl@0
|
1026 |
{
|
|
sl@0
|
1027 |
__SQLLEAVE(KErrNotFound);
|
|
sl@0
|
1028 |
}
|
|
sl@0
|
1029 |
driveSpace->GetAccessL();
|
|
sl@0
|
1030 |
iDriveSpaceInUse = ETrue;
|
|
sl@0
|
1031 |
}
|
|
sl@0
|
1032 |
|
|
sl@0
|
1033 |
/**
|
|
sl@0
|
1034 |
Releases the drive space reserve if it has been in use by this session (resp. client).
|
|
sl@0
|
1035 |
*/
|
|
sl@0
|
1036 |
void CSqlSrvSession::DbReleaseReserveAccess()
|
|
sl@0
|
1037 |
{
|
|
sl@0
|
1038 |
if(iDriveSpaceInUse)
|
|
sl@0
|
1039 |
{
|
|
sl@0
|
1040 |
CSqlDriveSpace* driveSpace = Server().DriveSpaceCol().Find(iDrive);
|
|
sl@0
|
1041 |
if(driveSpace)
|
|
sl@0
|
1042 |
{
|
|
sl@0
|
1043 |
driveSpace->ReleaseAccess();
|
|
sl@0
|
1044 |
}
|
|
sl@0
|
1045 |
iDriveSpaceInUse = EFalse;
|
|
sl@0
|
1046 |
}
|
|
sl@0
|
1047 |
}
|
|
sl@0
|
1048 |
|
|
sl@0
|
1049 |
/**
|
|
sl@0
|
1050 |
Processes the request for attaching a secure or non-secure database.
|
|
sl@0
|
1051 |
|
|
sl@0
|
1052 |
Usage of the IPC call arguments:
|
|
sl@0
|
1053 |
Arg 0: [in] Database file name length (counted in 16-bit characters).
|
|
sl@0
|
1054 |
Arg 1: [in] Database file name.
|
|
sl@0
|
1055 |
Arg 2: [in] Logical database name length (counted in 16-bit characters).
|
|
sl@0
|
1056 |
Arg 3: [in] Logical database name.
|
|
sl@0
|
1057 |
|
|
sl@0
|
1058 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
1059 |
*/
|
|
sl@0
|
1060 |
void CSqlSrvSession::DbAttachL(const RMessage2& aMessage)
|
|
sl@0
|
1061 |
{
|
|
sl@0
|
1062 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
1063 |
TSqlSrvFileData& fileData = Server().FileData();
|
|
sl@0
|
1064 |
fileData.SetL(aMessage, aMessage.Int0(), 1);
|
|
sl@0
|
1065 |
TInt logicalDbNameLen = aMessage.Int2();
|
|
sl@0
|
1066 |
if(logicalDbNameLen < 1 || logicalDbNameLen > KMaxFileName)
|
|
sl@0
|
1067 |
{
|
|
sl@0
|
1068 |
__SQLLEAVE(KErrBadName);
|
|
sl@0
|
1069 |
}
|
|
sl@0
|
1070 |
iDatabase->AttachDbL(fileData, ReadString16L(aMessage, 3, logicalDbNameLen));
|
|
sl@0
|
1071 |
}
|
|
sl@0
|
1072 |
|
|
sl@0
|
1073 |
/**
|
|
sl@0
|
1074 |
Processes the request for attaching a database using file session and file handles sent by the client.
|
|
sl@0
|
1075 |
|
|
sl@0
|
1076 |
Usage of the IPC call arguments:
|
|
sl@0
|
1077 |
- Arg 0: [in] The 32 bits of the argument are used as follow:
|
|
sl@0
|
1078 |
@code
|
|
sl@0
|
1079 |
MSB LSB
|
|
sl@0
|
1080 |
31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
|
|
sl@0
|
1081 |
Ro F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
|
|
sl@0
|
1082 |
@endcode
|
|
sl@0
|
1083 |
Where:
|
|
sl@0
|
1084 |
@code
|
|
sl@0
|
1085 |
- "Ro" - read-only flag, true if the file is read-only;
|
|
sl@0
|
1086 |
- "F" - database file name length in 16-bit characters;
|
|
sl@0
|
1087 |
@endcode
|
|
sl@0
|
1088 |
Arg 1: [in] db names buffer
|
|
sl@0
|
1089 |
Arg 2: [in] file session handle
|
|
sl@0
|
1090 |
Arg 3: [in] database file handle
|
|
sl@0
|
1091 |
|
|
sl@0
|
1092 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
1093 |
@panic SqlDb 4 Client panic. Invalid IPC data, an indication of a problme in client side sql library.
|
|
sl@0
|
1094 |
*/
|
|
sl@0
|
1095 |
void CSqlSrvSession::DbAttachFromHandleL(const RMessage2& aMessage)
|
|
sl@0
|
1096 |
{
|
|
sl@0
|
1097 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
1098 |
//Read-only flag, buffer length, buffer allocation
|
|
sl@0
|
1099 |
TBool readOnly = (aMessage.Int0() & 0x80000000) != 0;
|
|
sl@0
|
1100 |
const TInt KBufLen = aMessage.Int0() & 0x7FFFFFFF;
|
|
sl@0
|
1101 |
__SQLPANIC_CLIENT(KBufLen > 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1102 |
HBufC8* buf = HBufC8::NewLC(KBufLen);
|
|
sl@0
|
1103 |
TPtr8 bufPtr = buf->Des();
|
|
sl@0
|
1104 |
aMessage.ReadL(1, bufPtr);
|
|
sl@0
|
1105 |
SQLPROFILER_REPORT_IPC(ESqlIpcRead, KBufLen);
|
|
sl@0
|
1106 |
if(KBufLen != bufPtr.Length())
|
|
sl@0
|
1107 |
{
|
|
sl@0
|
1108 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
1109 |
}
|
|
sl@0
|
1110 |
RDesReadStream in(bufPtr);
|
|
sl@0
|
1111 |
TDes& dbFileName = Server().FileNameBuf();
|
|
sl@0
|
1112 |
TDes16& dbName = Server().GetBuf16L(KMaxFileName);
|
|
sl@0
|
1113 |
in >> dbFileName;
|
|
sl@0
|
1114 |
in >> dbName;
|
|
sl@0
|
1115 |
CleanupStack::PopAndDestroy(buf);
|
|
sl@0
|
1116 |
TSqlSrvFileData& fileData = Server().FileData();
|
|
sl@0
|
1117 |
fileData.SetFromHandleL(aMessage, dbFileName, EFalse, readOnly);
|
|
sl@0
|
1118 |
iDatabase->AttachDbL(fileData, dbName);
|
|
sl@0
|
1119 |
}
|
|
sl@0
|
1120 |
|
|
sl@0
|
1121 |
/**
|
|
sl@0
|
1122 |
Processes the request for detaching a secure or non-secure database.
|
|
sl@0
|
1123 |
|
|
sl@0
|
1124 |
Usage of the IPC call arguments:
|
|
sl@0
|
1125 |
Arg 0: [in] Logical database name length (counted in 16-bit characters).
|
|
sl@0
|
1126 |
Arg 1: [in] Logical database name.
|
|
sl@0
|
1127 |
|
|
sl@0
|
1128 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
1129 |
*/
|
|
sl@0
|
1130 |
void CSqlSrvSession::DbDetachL(const RMessage2& aMessage)
|
|
sl@0
|
1131 |
{
|
|
sl@0
|
1132 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
1133 |
TInt logicalDbNameLen = aMessage.Int0();
|
|
sl@0
|
1134 |
if(logicalDbNameLen < 1 || logicalDbNameLen > KMaxFileName)
|
|
sl@0
|
1135 |
{
|
|
sl@0
|
1136 |
__SQLLEAVE(KErrBadName);
|
|
sl@0
|
1137 |
}
|
|
sl@0
|
1138 |
iDatabase->DetachDbL(ReadString16L(aMessage, 1, logicalDbNameLen));
|
|
sl@0
|
1139 |
}
|
|
sl@0
|
1140 |
|
|
sl@0
|
1141 |
/**
|
|
sl@0
|
1142 |
Reads a 16-bit string from the specified stream and returns it in zero-terminated
|
|
sl@0
|
1143 |
8-bit format in aNameOut.
|
|
sl@0
|
1144 |
If the string is of zero length then the substitute string provided will be used instead.
|
|
sl@0
|
1145 |
|
|
sl@0
|
1146 |
@param aStrm The read stream
|
|
sl@0
|
1147 |
@param aNameOut The output parameter that will contain the string read
|
|
sl@0
|
1148 |
@param aEmptyNameSubstitute The substitute string to use if the string to be read from
|
|
sl@0
|
1149 |
the stream is zero length
|
|
sl@0
|
1150 |
|
|
sl@0
|
1151 |
@leave KErrNoMemory, An out of memory condition has occurred;
|
|
sl@0
|
1152 |
KErrArgument, The UTF-16 to UTF-8 string conversion failed;
|
|
sl@0
|
1153 |
KErrBadName, The string has an invalid length;
|
|
sl@0
|
1154 |
*/
|
|
sl@0
|
1155 |
void CSqlSrvSession::ExtractNameL(RDesReadStream& aStrm, TDes8& aNameOut, const TDesC& aEmptyNameSubstitute)
|
|
sl@0
|
1156 |
{
|
|
sl@0
|
1157 |
TBool replace = EFalse;
|
|
sl@0
|
1158 |
TInt32 len;
|
|
sl@0
|
1159 |
aStrm >> len;
|
|
sl@0
|
1160 |
|
|
sl@0
|
1161 |
if(len == 0)
|
|
sl@0
|
1162 |
{
|
|
sl@0
|
1163 |
if(aEmptyNameSubstitute.Length() > 0)
|
|
sl@0
|
1164 |
{
|
|
sl@0
|
1165 |
len = aEmptyNameSubstitute.Length();
|
|
sl@0
|
1166 |
replace = ETrue;
|
|
sl@0
|
1167 |
}
|
|
sl@0
|
1168 |
else
|
|
sl@0
|
1169 |
{
|
|
sl@0
|
1170 |
__SQLLEAVE(KErrBadName);
|
|
sl@0
|
1171 |
}
|
|
sl@0
|
1172 |
}
|
|
sl@0
|
1173 |
__ASSERT_DEBUG(len > 0, __SQLPANIC2(ESqlPanicInternalError));//The "if" above should have hanled the case with "len == 0"
|
|
sl@0
|
1174 |
if((TUint)len > KMaxFileName)
|
|
sl@0
|
1175 |
{
|
|
sl@0
|
1176 |
__SQLLEAVE(KErrBadName);
|
|
sl@0
|
1177 |
}
|
|
sl@0
|
1178 |
|
|
sl@0
|
1179 |
HBufC* buf = HBufC::NewLC(len + 1);
|
|
sl@0
|
1180 |
TPtr ptr = buf->Des();
|
|
sl@0
|
1181 |
if(replace)
|
|
sl@0
|
1182 |
{
|
|
sl@0
|
1183 |
ptr.Copy(aEmptyNameSubstitute);
|
|
sl@0
|
1184 |
}
|
|
sl@0
|
1185 |
else
|
|
sl@0
|
1186 |
{
|
|
sl@0
|
1187 |
aStrm >> ptr;
|
|
sl@0
|
1188 |
}
|
|
sl@0
|
1189 |
ptr.Append(0);
|
|
sl@0
|
1190 |
|
|
sl@0
|
1191 |
if(!::UTF16ZToUTF8Z(ptr, aNameOut))
|
|
sl@0
|
1192 |
{
|
|
sl@0
|
1193 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
1194 |
}
|
|
sl@0
|
1195 |
|
|
sl@0
|
1196 |
CleanupStack::PopAndDestroy(buf);
|
|
sl@0
|
1197 |
}
|
|
sl@0
|
1198 |
|
|
sl@0
|
1199 |
/**
|
|
sl@0
|
1200 |
Processes the request for creating an IPC stream for accessing the content of a blob column.
|
|
sl@0
|
1201 |
|
|
sl@0
|
1202 |
@param aMessage The client request wrapped in an IPC message
|
|
sl@0
|
1203 |
|
|
sl@0
|
1204 |
@return The blob stream handle
|
|
sl@0
|
1205 |
|
|
sl@0
|
1206 |
@leave KErrNoMemory, An out of memory condition has occurred;
|
|
sl@0
|
1207 |
KErrArgument, The ROWID is invalid or UTF-16 to UTF-8 string conversion failed;
|
|
sl@0
|
1208 |
KErrBadDescriptor The transferred data is bigger than the specified length;
|
|
sl@0
|
1209 |
KErrBadName, The table name, column name or database name has an invalid length;
|
|
sl@0
|
1210 |
KErrPermissionDenied, The client does not have the required security capabilites for this operation;
|
|
sl@0
|
1211 |
Note that the function may also leave with some other system wide errors or
|
|
sl@0
|
1212 |
database specific errors categorised as ESqlDbError.
|
|
sl@0
|
1213 |
|
|
sl@0
|
1214 |
@panic SqlDb 2 Client panic. The database object is not yet created (iDatabase is NULL).
|
|
sl@0
|
1215 |
@panic SqlDb 3 Client panic. Failed to create a blob stream handle.
|
|
sl@0
|
1216 |
@panic SqlDb 4 Client panic. IPC buffer length is 0.
|
|
sl@0
|
1217 |
|
|
sl@0
|
1218 |
Usage of the IPC call arguments:
|
|
sl@0
|
1219 |
Arg 0: [in] The length of the IPC data buffer
|
|
sl@0
|
1220 |
Arg 1: [in] IPC data buffer containing blob parameters: table name, column name, rowid, mode, database name.
|
|
sl@0
|
1221 |
Arg 2: [out] IPC buffer containing the blob stream handle
|
|
sl@0
|
1222 |
*/
|
|
sl@0
|
1223 |
TInt CSqlSrvSession::DbBlobSourceL(const RMessage2& aMessage)
|
|
sl@0
|
1224 |
{
|
|
sl@0
|
1225 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
1226 |
|
|
sl@0
|
1227 |
TInt ipcPrmLen = aMessage.Int0();
|
|
sl@0
|
1228 |
__SQLPANIC_CLIENT(ipcPrmLen > 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1229 |
|
|
sl@0
|
1230 |
iIpcStreams.AllocL();
|
|
sl@0
|
1231 |
|
|
sl@0
|
1232 |
TDes8& ipcPrmDes = ReadString8ZL(aMessage, 1, ipcPrmLen);
|
|
sl@0
|
1233 |
RDesReadStream strm(ipcPrmDes);
|
|
sl@0
|
1234 |
|
|
sl@0
|
1235 |
TBuf8<KMaxFileName + 1> tblName;
|
|
sl@0
|
1236 |
ExtractNameL(strm, tblName);
|
|
sl@0
|
1237 |
|
|
sl@0
|
1238 |
TBuf8<KMaxFileName + 1> colName;
|
|
sl@0
|
1239 |
ExtractNameL(strm, colName);
|
|
sl@0
|
1240 |
|
|
sl@0
|
1241 |
TInt64 rowId;
|
|
sl@0
|
1242 |
strm >> rowId;
|
|
sl@0
|
1243 |
if(rowId == -1)
|
|
sl@0
|
1244 |
{
|
|
sl@0
|
1245 |
rowId = iDatabase->LastInsertedRowId();
|
|
sl@0
|
1246 |
}
|
|
sl@0
|
1247 |
if(rowId <= 0)
|
|
sl@0
|
1248 |
{
|
|
sl@0
|
1249 |
__SQLLEAVE(KErrArgument);
|
|
sl@0
|
1250 |
}
|
|
sl@0
|
1251 |
|
|
sl@0
|
1252 |
TInt32 tmp;
|
|
sl@0
|
1253 |
strm >> tmp;
|
|
sl@0
|
1254 |
TBool isReadOnly = tmp != 0;
|
|
sl@0
|
1255 |
|
|
sl@0
|
1256 |
TBuf8<KMaxFileName + 1> dbName;
|
|
sl@0
|
1257 |
ExtractNameL(strm, dbName, KMainDb16);
|
|
sl@0
|
1258 |
|
|
sl@0
|
1259 |
strm.Close();
|
|
sl@0
|
1260 |
|
|
sl@0
|
1261 |
// If the database is secure then check that the client has the required capabilities for the operation
|
|
sl@0
|
1262 |
TInt dbOpType = isReadOnly ? SQLITE_READ : SQLITE_UPDATE;
|
|
sl@0
|
1263 |
if(CSqlSrvDatabase::AuthorizeCallback(iDatabase, dbOpType, (char*)tblName.Ptr(), (char*)colName.Ptr(), (char*)dbName.Ptr(), '\0') != SQLITE_OK)
|
|
sl@0
|
1264 |
{
|
|
sl@0
|
1265 |
__SQLLEAVE(KErrPermissionDenied);
|
|
sl@0
|
1266 |
}
|
|
sl@0
|
1267 |
|
|
sl@0
|
1268 |
// Create the stream buffer
|
|
sl@0
|
1269 |
HBlobBuf* blobBuf = HBlobBuf::NewL(iDatabase->RawDbHandle(), dbName, tblName, colName, rowId, isReadOnly ? HBlobBuf::EReadOnly : HBlobBuf::EReadWrite);
|
|
sl@0
|
1270 |
blobBuf->PushL();
|
|
sl@0
|
1271 |
|
|
sl@0
|
1272 |
// Return the blob size to the client
|
|
sl@0
|
1273 |
TPckgBuf<TIpcStreamBuf> ipcBuf;
|
|
sl@0
|
1274 |
TInt size = blobBuf->SizeL();
|
|
sl@0
|
1275 |
ipcBuf().iExt = size;
|
|
sl@0
|
1276 |
|
|
sl@0
|
1277 |
// If this is a read stream then return the first client buffer-full of data
|
|
sl@0
|
1278 |
TInt len = 0;
|
|
sl@0
|
1279 |
if(isReadOnly && (size > 0))
|
|
sl@0
|
1280 |
{
|
|
sl@0
|
1281 |
len = Min(size, KIpcBufSize);
|
|
sl@0
|
1282 |
blobBuf->ReadL(ipcBuf().iData, len);
|
|
sl@0
|
1283 |
}
|
|
sl@0
|
1284 |
|
|
sl@0
|
1285 |
// Create the stream object
|
|
sl@0
|
1286 |
HIpcStream* ipcStream = new (ELeave) HIpcStream(blobBuf, len);
|
|
sl@0
|
1287 |
TInt strmHandle = iIpcStreams.Add(ipcStream);
|
|
sl@0
|
1288 |
__SQLPANIC_CLIENT(strmHandle > 0, aMessage, ESqlPanicBadHandle);
|
|
sl@0
|
1289 |
CleanupStack::Pop(blobBuf);
|
|
sl@0
|
1290 |
|
|
sl@0
|
1291 |
// Send the size and data to the client
|
|
sl@0
|
1292 |
aMessage.WriteL(2, ipcBuf);
|
|
sl@0
|
1293 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, size);
|
|
sl@0
|
1294 |
|
|
sl@0
|
1295 |
return strmHandle;
|
|
sl@0
|
1296 |
}
|
|
sl@0
|
1297 |
|
|
sl@0
|
1298 |
///////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
1299 |
//////////////////////////// Statement operations //////////////////////////////////
|
|
sl@0
|
1300 |
///////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
1301 |
|
|
sl@0
|
1302 |
/**
|
|
sl@0
|
1303 |
Processes the request for preparing a 8/16-bit SQL statement.
|
|
sl@0
|
1304 |
|
|
sl@0
|
1305 |
@panic SqlDb 2 Client panic. iDatabase is NULL (the database object is not created yet).
|
|
sl@0
|
1306 |
@panic SqlDb 3 Client panic. Internal error - invalid statement handle.
|
|
sl@0
|
1307 |
|
|
sl@0
|
1308 |
Usage of the IPC call arguments:
|
|
sl@0
|
1309 |
Arg 0: [out] Column count and parameter count
|
|
sl@0
|
1310 |
Arg 1: [in] 8/16-bit character length of SQL statement
|
|
sl@0
|
1311 |
Arg 2: [in] SQL statement
|
|
sl@0
|
1312 |
*/
|
|
sl@0
|
1313 |
TInt CSqlSrvSession::StmtPrepareL(const RMessage2& aMessage, TBool aIsText16)
|
|
sl@0
|
1314 |
{
|
|
sl@0
|
1315 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
1316 |
iStatements.AllocL();
|
|
sl@0
|
1317 |
TInt columnCount = -1;
|
|
sl@0
|
1318 |
TInt paramCount = -1;
|
|
sl@0
|
1319 |
TUint len = static_cast <TUint> (aMessage.Int1());
|
|
sl@0
|
1320 |
CSqlSrvStatement* stmt = aIsText16 ?
|
|
sl@0
|
1321 |
CSqlSrvStatement::NewLC(iDatabase->RawDbHandle(), ReadString16ZL(aMessage, 2, len), columnCount, paramCount) :
|
|
sl@0
|
1322 |
CSqlSrvStatement::NewLC(iDatabase->RawDbHandle(), ReadString8ZL(aMessage, 2, len), columnCount, paramCount);
|
|
sl@0
|
1323 |
TPckgBuf<TSqlIpcData> data;
|
|
sl@0
|
1324 |
data().iPrm1 = static_cast <TUint32> (columnCount);
|
|
sl@0
|
1325 |
data().iPrm2 = static_cast <TUint32> (paramCount);
|
|
sl@0
|
1326 |
aMessage.WriteL(0, data);
|
|
sl@0
|
1327 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, sizeof(TSqlIpcData));
|
|
sl@0
|
1328 |
TInt stmtHandle = iStatements.Add(stmt);
|
|
sl@0
|
1329 |
__SQLPANIC_CLIENT(stmtHandle > 0, aMessage, ESqlPanicBadHandle);
|
|
sl@0
|
1330 |
CleanupStack::Pop(stmt);
|
|
sl@0
|
1331 |
return stmtHandle;
|
|
sl@0
|
1332 |
}
|
|
sl@0
|
1333 |
|
|
sl@0
|
1334 |
/**
|
|
sl@0
|
1335 |
Processes the request for executing the SQL statement.
|
|
sl@0
|
1336 |
|
|
sl@0
|
1337 |
@param aFunction ESqlSrvStmtExec, ESqlSrvStmtAsyncExec, ESqlSrvStmtBindExec, ESqlSrvStmtBindExecRowId, ESqlSrvStmtAsyncBindExec
|
|
sl@0
|
1338 |
|
|
sl@0
|
1339 |
Usage of the IPC call arguments:
|
|
sl@0
|
1340 |
Arg 0: [in] parameter buffer length in bytes (if aFunction == ESqlSrvStmtBindExec || aFunction == ESqlSrvStmtAsyncBindExec)
|
|
sl@0
|
1341 |
Arg 1: [in] parameter buffer (if aFunction == ESqlSrvStmtBindExec || aFunction == ESqlSrvStmtAsyncBindExec)
|
|
sl@0
|
1342 |
*/
|
|
sl@0
|
1343 |
TInt CSqlSrvSession::StmtExecL(const RMessage2& aMessage, TInt aStmtHandle, TSqlSrvFunction aFunction)
|
|
sl@0
|
1344 |
{
|
|
sl@0
|
1345 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1346 |
if(aFunction == ESqlSrvStmtBindExec || aFunction == ESqlSrvStmtAsyncBindExec)
|
|
sl@0
|
1347 |
{
|
|
sl@0
|
1348 |
DoStmtBindL(aMessage, stmt);
|
|
sl@0
|
1349 |
}
|
|
sl@0
|
1350 |
__SQLLEAVE_IF_ERROR(stmt.Exec());
|
|
sl@0
|
1351 |
return iDatabase->LastChangesCount();
|
|
sl@0
|
1352 |
}
|
|
sl@0
|
1353 |
|
|
sl@0
|
1354 |
/**
|
|
sl@0
|
1355 |
Processes the request for moving the SQL statement on the next record.
|
|
sl@0
|
1356 |
|
|
sl@0
|
1357 |
If the call does not fail, the only valid acceptable return codes should be KSqlAtRow and KSqlAtEnd.
|
|
sl@0
|
1358 |
|
|
sl@0
|
1359 |
@panic SqlDb 7 In _DEBUG mode. The call completed with no error but the return code is not KSqlAtRow or KSqlAtEnd.
|
|
sl@0
|
1360 |
|
|
sl@0
|
1361 |
Usage of the IPC call arguments:
|
|
sl@0
|
1362 |
Arg 0: [in] parameter buffer length in bytes (if aFunction == ESqlSrvStmtBindNext)
|
|
sl@0
|
1363 |
Arg 1: [in] parameter buffer (if aFunction == ESqlSrvStmtBindNext)
|
|
sl@0
|
1364 |
Arg 2: [in] client side column buffer length in bytes
|
|
sl@0
|
1365 |
Arg 3: [out] column buffer
|
|
sl@0
|
1366 |
*/
|
|
sl@0
|
1367 |
TInt CSqlSrvSession::StmtNextL(const RMessage2& aMessage, TInt aStmtHandle, TSqlSrvFunction aFunction)
|
|
sl@0
|
1368 |
{
|
|
sl@0
|
1369 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1370 |
if(aFunction == ESqlSrvStmtBindNext)
|
|
sl@0
|
1371 |
{
|
|
sl@0
|
1372 |
DoStmtBindL(aMessage, stmt);
|
|
sl@0
|
1373 |
}
|
|
sl@0
|
1374 |
TInt err = stmt.Next();
|
|
sl@0
|
1375 |
if(err == KSqlAtRow)
|
|
sl@0
|
1376 |
{
|
|
sl@0
|
1377 |
const RSqlBufFlat& bufFlat = stmt.ColumnValuesL();
|
|
sl@0
|
1378 |
TInt size = bufFlat.Size();
|
|
sl@0
|
1379 |
if(size > aMessage.Int2())
|
|
sl@0
|
1380 |
{
|
|
sl@0
|
1381 |
return size + KSqlClientBufOverflowCode;
|
|
sl@0
|
1382 |
}
|
|
sl@0
|
1383 |
aMessage.WriteL(3, bufFlat.BufDes());
|
|
sl@0
|
1384 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, size);
|
|
sl@0
|
1385 |
}
|
|
sl@0
|
1386 |
__SQLLEAVE_IF_ERROR(err);
|
|
sl@0
|
1387 |
__ASSERT_DEBUG(err == KSqlAtRow || err == KSqlAtEnd, __SQLPANIC(ESqlPanicInternalError));
|
|
sl@0
|
1388 |
return err;
|
|
sl@0
|
1389 |
}
|
|
sl@0
|
1390 |
|
|
sl@0
|
1391 |
/**
|
|
sl@0
|
1392 |
Processes the request for retrieving the statement column or parameter names.
|
|
sl@0
|
1393 |
|
|
sl@0
|
1394 |
If the client side buffer size is not big enough, the function returns the size + KSqlClientBufOverflowCode.
|
|
sl@0
|
1395 |
In this case the client must increase the buffer and try again to get the buffer only.
|
|
sl@0
|
1396 |
|
|
sl@0
|
1397 |
Usage of the IPC call arguments:
|
|
sl@0
|
1398 |
Arg 0: [in] size of the client side buffer for the names (in bytes)
|
|
sl@0
|
1399 |
Arg 1: [out] ipc buffer, column or parameter names
|
|
sl@0
|
1400 |
*/
|
|
sl@0
|
1401 |
TInt CSqlSrvSession::StmtNamesL(const RMessage2& aMessage, TInt aStmtHandle, TSqlSrvFunction aFunction)
|
|
sl@0
|
1402 |
{
|
|
sl@0
|
1403 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1404 |
const RSqlBufFlat& namesBuf = aFunction == ESqlSrvStmtParamNames ? stmt.ParamNamesL() : stmt.ColumnNamesL();
|
|
sl@0
|
1405 |
TInt size = namesBuf.Size();
|
|
sl@0
|
1406 |
if(size <= aMessage.Int0())
|
|
sl@0
|
1407 |
{
|
|
sl@0
|
1408 |
aMessage.WriteL(1, namesBuf.BufDes());
|
|
sl@0
|
1409 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, size);
|
|
sl@0
|
1410 |
return 0;
|
|
sl@0
|
1411 |
}
|
|
sl@0
|
1412 |
return size + KSqlClientBufOverflowCode;
|
|
sl@0
|
1413 |
}
|
|
sl@0
|
1414 |
|
|
sl@0
|
1415 |
/**
|
|
sl@0
|
1416 |
Processes the request for accessing a large column value as a stream of bytes/characters.
|
|
sl@0
|
1417 |
|
|
sl@0
|
1418 |
Usage of the IPC call arguments:
|
|
sl@0
|
1419 |
Arg 0: [in] column index (0 based)
|
|
sl@0
|
1420 |
Arg 2: [out] ipc buffer, column source
|
|
sl@0
|
1421 |
*/
|
|
sl@0
|
1422 |
TInt CSqlSrvSession::StmtColumnSourceL(const RMessage2& aMessage, TInt aStmtHandle)
|
|
sl@0
|
1423 |
{
|
|
sl@0
|
1424 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1425 |
TInt columnIndex = aMessage.Int0();
|
|
sl@0
|
1426 |
TPtrC8 columnSource;
|
|
sl@0
|
1427 |
TInt err = stmt.ColumnSource(columnIndex, columnSource);
|
|
sl@0
|
1428 |
__SQLLEAVE_IF_ERROR(err);
|
|
sl@0
|
1429 |
HIpcReadBuf* ipcBuf = HIpcReadBuf::NewL(columnSource);
|
|
sl@0
|
1430 |
return NewOutputStreamL(aMessage, ipcBuf);
|
|
sl@0
|
1431 |
}
|
|
sl@0
|
1432 |
|
|
sl@0
|
1433 |
/**
|
|
sl@0
|
1434 |
Processes the request for setting a large parameter value from a stream of bytes or 8/16-bit characters.
|
|
sl@0
|
1435 |
|
|
sl@0
|
1436 |
@panic SqlDb 3 Client panic. Internal error - invalid stream handle.
|
|
sl@0
|
1437 |
|
|
sl@0
|
1438 |
Usage of the IPC call arguments:
|
|
sl@0
|
1439 |
Arg 0: [in] parameter index (0 based)
|
|
sl@0
|
1440 |
Arg 2: [out] ipc buffer, parameter source
|
|
sl@0
|
1441 |
*/
|
|
sl@0
|
1442 |
TInt CSqlSrvSession::StmtParamSinkL(const RMessage2& aMessage, TInt aStmtHandle, TSqlSrvFunction aFunction)
|
|
sl@0
|
1443 |
{
|
|
sl@0
|
1444 |
iIpcStreams.AllocL();
|
|
sl@0
|
1445 |
TInt parameterIndex = aMessage.Int0();
|
|
sl@0
|
1446 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1447 |
HSqlSrvStmtParamBuf::TDataType dataType = aFunction == ESqlSrvStmtBinParamSink ? HSqlSrvStmtParamBuf::EBinary : HSqlSrvStmtParamBuf::EText16;
|
|
sl@0
|
1448 |
HSqlSrvStmtParamBuf* paramBuf = stmt.GetParamBufL(parameterIndex, dataType, HSqlSrvStmtParamBuf::EBufIpcStream);
|
|
sl@0
|
1449 |
HIpcStream* ipcStream = new (ELeave) HIpcStream(paramBuf, 0);
|
|
sl@0
|
1450 |
TInt strmHandle = iIpcStreams.Add(ipcStream);
|
|
sl@0
|
1451 |
__SQLPANIC_CLIENT(strmHandle > 0, aMessage, ESqlPanicBadHandle);
|
|
sl@0
|
1452 |
return strmHandle;
|
|
sl@0
|
1453 |
}
|
|
sl@0
|
1454 |
|
|
sl@0
|
1455 |
/**
|
|
sl@0
|
1456 |
Usage of the IPC call arguments:
|
|
sl@0
|
1457 |
Arg 0: [in] the client side buffer length in bytes
|
|
sl@0
|
1458 |
Arg 1: [out] refers to a place where the buffer data will be copied to.
|
|
sl@0
|
1459 |
*/
|
|
sl@0
|
1460 |
void CSqlSrvSession::StmtGetBufFlatL(const RMessage2& aMessage, TInt aStmtHandle)
|
|
sl@0
|
1461 |
{
|
|
sl@0
|
1462 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1463 |
const RSqlBufFlat& bufFlat = stmt.BufFlatL(static_cast <TSqlBufFlatType> (aMessage.Int0()));
|
|
sl@0
|
1464 |
aMessage.WriteL(1, bufFlat.BufDes());
|
|
sl@0
|
1465 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, bufFlat.Size());
|
|
sl@0
|
1466 |
}
|
|
sl@0
|
1467 |
|
|
sl@0
|
1468 |
/**
|
|
sl@0
|
1469 |
Usage of the IPC call arguments:
|
|
sl@0
|
1470 |
Arg 0: [in] column index
|
|
sl@0
|
1471 |
Arg 1: [in] column buffer length in bytes
|
|
sl@0
|
1472 |
Arg 2: [in/out] column buffer
|
|
sl@0
|
1473 |
*/
|
|
sl@0
|
1474 |
void CSqlSrvSession::StmtColumnValueL(const RMessage2& aMessage, TInt aStmtHandle)
|
|
sl@0
|
1475 |
{
|
|
sl@0
|
1476 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1477 |
TPtrC8 columnSource;
|
|
sl@0
|
1478 |
TInt columnIndex = aMessage.Int0();
|
|
sl@0
|
1479 |
TInt err = stmt.ColumnSource(columnIndex, columnSource);
|
|
sl@0
|
1480 |
__SQLLEAVE_IF_ERROR(err);
|
|
sl@0
|
1481 |
TInt len = aMessage.Int1();
|
|
sl@0
|
1482 |
if(columnSource.Length() > len)
|
|
sl@0
|
1483 |
{
|
|
sl@0
|
1484 |
TPtr8 ptr(const_cast <TUint8*> (columnSource.Ptr()), columnSource.Length(), columnSource.Length());
|
|
sl@0
|
1485 |
ptr.SetLength(len);
|
|
sl@0
|
1486 |
aMessage.WriteL(2, ptr);
|
|
sl@0
|
1487 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, len);
|
|
sl@0
|
1488 |
__SQLLEAVE(KErrOverflow);
|
|
sl@0
|
1489 |
}
|
|
sl@0
|
1490 |
else
|
|
sl@0
|
1491 |
{
|
|
sl@0
|
1492 |
aMessage.WriteL(2, columnSource);
|
|
sl@0
|
1493 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, len);
|
|
sl@0
|
1494 |
}
|
|
sl@0
|
1495 |
}
|
|
sl@0
|
1496 |
|
|
sl@0
|
1497 |
/**
|
|
sl@0
|
1498 |
Usage of the IPC call arguments:
|
|
sl@0
|
1499 |
Arg 0: [in] parameter buffer length in bytes
|
|
sl@0
|
1500 |
Arg 1: [in] parameter buffer
|
|
sl@0
|
1501 |
*/
|
|
sl@0
|
1502 |
void CSqlSrvSession::DoStmtBindL(const RMessage2& aMessage, CSqlSrvStatement& aStmt)
|
|
sl@0
|
1503 |
{
|
|
sl@0
|
1504 |
TInt prmLen = aMessage.Int0();
|
|
sl@0
|
1505 |
RSqlBufFlat& prmBuf = Server().GetFlatBufL(prmLen);
|
|
sl@0
|
1506 |
aMessage.ReadL(1, prmBuf.BufPtr());
|
|
sl@0
|
1507 |
SQLPROFILER_REPORT_IPC(ESqlIpcRead, prmLen);
|
|
sl@0
|
1508 |
aStmt.BindL(prmBuf);
|
|
sl@0
|
1509 |
}
|
|
sl@0
|
1510 |
|
|
sl@0
|
1511 |
/**
|
|
sl@0
|
1512 |
Processes the request for retrieving the statement declared column type names.
|
|
sl@0
|
1513 |
|
|
sl@0
|
1514 |
If the client side buffer size is not big enough, the function returns the size + KSqlClientBufOverflowCode.
|
|
sl@0
|
1515 |
In this case the client must increase the buffer and try again to get the buffer only
|
|
sl@0
|
1516 |
|
|
sl@0
|
1517 |
Usage of the IPC call arguments:
|
|
sl@0
|
1518 |
Arg 0: [in] input buffer max length in 16-bit characters
|
|
sl@0
|
1519 |
Arg 1: [out] ipc buffer, declared column type names
|
|
sl@0
|
1520 |
*/
|
|
sl@0
|
1521 |
TInt CSqlSrvSession::StmtDeclColumnTypesL(const RMessage2& aMessage, TInt aStmtHandle)
|
|
sl@0
|
1522 |
{
|
|
sl@0
|
1523 |
CSqlSrvStatement& stmt = ::SqlSessObjFind(iStatements, aStmtHandle, aMessage);
|
|
sl@0
|
1524 |
const RSqlBufFlat& declColumnTypesBuf = stmt.GetDeclColumnTypesL();
|
|
sl@0
|
1525 |
TInt size = declColumnTypesBuf.Size();
|
|
sl@0
|
1526 |
if(size <= aMessage.Int0())
|
|
sl@0
|
1527 |
{
|
|
sl@0
|
1528 |
aMessage.WriteL(1, declColumnTypesBuf.BufDes());
|
|
sl@0
|
1529 |
return 0;
|
|
sl@0
|
1530 |
}
|
|
sl@0
|
1531 |
return size + KSqlClientBufOverflowCode;
|
|
sl@0
|
1532 |
}
|
|
sl@0
|
1533 |
|
|
sl@0
|
1534 |
|
|
sl@0
|
1535 |
//////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
1536 |
//////////////////////// Helper methods /////////////////////////////////
|
|
sl@0
|
1537 |
//////////////////////////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
1538 |
|
|
sl@0
|
1539 |
/**
|
|
sl@0
|
1540 |
Creates a new output IPC stream object using the aStreamBuf parameter as a stream buffer (stream data source).
|
|
sl@0
|
1541 |
|
|
sl@0
|
1542 |
This method immediately pushes aStreamBuf onto the cleanup stack before creating a new output IPC
|
|
sl@0
|
1543 |
stream and so callers of this method should ensure that aStreamBuf is not already on the cleanup stack.
|
|
sl@0
|
1544 |
|
|
sl@0
|
1545 |
Returns the handle of the created stream.
|
|
sl@0
|
1546 |
|
|
sl@0
|
1547 |
@panic SqlDb 3 Client panic. Internal error - invalid stream handle.
|
|
sl@0
|
1548 |
|
|
sl@0
|
1549 |
Usage of the IPC call arguments:
|
|
sl@0
|
1550 |
Arg 2: [in/out] IPC buffer
|
|
sl@0
|
1551 |
*/
|
|
sl@0
|
1552 |
TInt CSqlSrvSession::NewOutputStreamL(const RMessage2& aMessage, MStreamBuf* aStreamBuf)
|
|
sl@0
|
1553 |
{
|
|
sl@0
|
1554 |
aStreamBuf->PushL();
|
|
sl@0
|
1555 |
iIpcStreams.AllocL();
|
|
sl@0
|
1556 |
TInt size = aStreamBuf->SizeL();
|
|
sl@0
|
1557 |
__ASSERT_DEBUG(size >= 0, __SQLPANIC(ESqlPanicInternalError));
|
|
sl@0
|
1558 |
TPckgBuf<TIpcStreamBuf> ipcBuf;
|
|
sl@0
|
1559 |
// read the first buffer-full
|
|
sl@0
|
1560 |
TInt len = Min(size, KIpcBufSize);
|
|
sl@0
|
1561 |
aStreamBuf->ReadL(ipcBuf().iData, len);
|
|
sl@0
|
1562 |
TInt handle = 0;
|
|
sl@0
|
1563 |
if(size > KIpcBufSize)
|
|
sl@0
|
1564 |
{ // create the stream object
|
|
sl@0
|
1565 |
HIpcStream* ipcStream = new (ELeave) HIpcStream(aStreamBuf, KIpcBufSize);
|
|
sl@0
|
1566 |
handle = iIpcStreams.Add(ipcStream);
|
|
sl@0
|
1567 |
__SQLPANIC_CLIENT(handle > 0, aMessage, ESqlPanicBadHandle);
|
|
sl@0
|
1568 |
CleanupStack::Pop(aStreamBuf);
|
|
sl@0
|
1569 |
}
|
|
sl@0
|
1570 |
else // no more data to send
|
|
sl@0
|
1571 |
{
|
|
sl@0
|
1572 |
CleanupStack::PopAndDestroy(aStreamBuf);
|
|
sl@0
|
1573 |
}
|
|
sl@0
|
1574 |
ipcBuf().iExt = size;
|
|
sl@0
|
1575 |
aMessage.WriteL(2, ipcBuf);
|
|
sl@0
|
1576 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, size);
|
|
sl@0
|
1577 |
return handle;
|
|
sl@0
|
1578 |
}
|
|
sl@0
|
1579 |
|
|
sl@0
|
1580 |
/**
|
|
sl@0
|
1581 |
Reads a 8-bit string with "aByteLen" bytes length, which is in "aArgNum" argument of aMessage.
|
|
sl@0
|
1582 |
The string will be zero terminated after the "read" operation.
|
|
sl@0
|
1583 |
Returns TDes8 reference pointing to the zero-terminated string.
|
|
sl@0
|
1584 |
|
|
sl@0
|
1585 |
@panic SqlDb 3 Client panic. The string length is not equal to aByteLen. If happens then it is an indication of a
|
|
sl@0
|
1586 |
problem inside client side sql library.
|
|
sl@0
|
1587 |
@panic SqlDb 4 Client panic. Negative aByteLen value.
|
|
sl@0
|
1588 |
*/
|
|
sl@0
|
1589 |
TDes8& CSqlSrvSession::ReadString8ZL(const RMessage2& aMessage, TInt aArgNum, TInt aByteLen)
|
|
sl@0
|
1590 |
{
|
|
sl@0
|
1591 |
__SQLPANIC_CLIENT(aByteLen >= 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1592 |
TDes8& buf = Server().GetBuf8L(aByteLen + 1);
|
|
sl@0
|
1593 |
aMessage.ReadL(aArgNum, buf);
|
|
sl@0
|
1594 |
SQLPROFILER_REPORT_IPC(ESqlIpcRead, aByteLen);
|
|
sl@0
|
1595 |
__SQLPANIC_CLIENT(buf.Length() == aByteLen, aMessage, ESqlPanicBadHandle);
|
|
sl@0
|
1596 |
buf.Append(TChar(0));
|
|
sl@0
|
1597 |
return buf;
|
|
sl@0
|
1598 |
}
|
|
sl@0
|
1599 |
|
|
sl@0
|
1600 |
/**
|
|
sl@0
|
1601 |
Reads a 16-bit string with "aCharLen" character length, which is in "aArgNum" argument of aMessage.
|
|
sl@0
|
1602 |
The string will be zero terminated after the "read" operation.
|
|
sl@0
|
1603 |
Returns TDes16 reference pointing to the zero-terminated string.
|
|
sl@0
|
1604 |
|
|
sl@0
|
1605 |
@panic SqlDb 3 Client panic. The string length is not equal to aCharLen. If happens then it is an indication of a
|
|
sl@0
|
1606 |
problem inside client side sql library.
|
|
sl@0
|
1607 |
@panic SqlDb 4 Client panic. Negative aCharLen value.
|
|
sl@0
|
1608 |
*/
|
|
sl@0
|
1609 |
TDes16& CSqlSrvSession::ReadString16ZL(const RMessage2& aMessage, TInt aArgNum, TInt aCharLen)
|
|
sl@0
|
1610 |
{
|
|
sl@0
|
1611 |
__SQLPANIC_CLIENT(aCharLen >= 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1612 |
TDes16& buf = Server().GetBuf16L(aCharLen + 1);
|
|
sl@0
|
1613 |
aMessage.ReadL(aArgNum, buf);
|
|
sl@0
|
1614 |
SQLPROFILER_REPORT_IPC(ESqlIpcRead, (aCharLen * sizeof(TText)));
|
|
sl@0
|
1615 |
__SQLPANIC_CLIENT(buf.Length() == aCharLen, aMessage, ESqlPanicBadHandle);
|
|
sl@0
|
1616 |
buf.Append(TChar(0));
|
|
sl@0
|
1617 |
return buf;
|
|
sl@0
|
1618 |
}
|
|
sl@0
|
1619 |
|
|
sl@0
|
1620 |
/**
|
|
sl@0
|
1621 |
Reads a 16-bit string with "aCharLen" character length, which is in "aArgNum" argument of aMessage.
|
|
sl@0
|
1622 |
Returns TDes16 reference pointing to the string.
|
|
sl@0
|
1623 |
|
|
sl@0
|
1624 |
@panic SqlDb 3 Client panic. The string length is not equal to aCharLen. If happens then it is an indication of a
|
|
sl@0
|
1625 |
problem inside client side sql library.
|
|
sl@0
|
1626 |
@panic SqlDb 4 Client panic. Negative aCharLen value.
|
|
sl@0
|
1627 |
*/
|
|
sl@0
|
1628 |
TDes16& CSqlSrvSession::ReadString16L(const RMessage2& aMessage, TInt aArgNum, TInt aCharLen)
|
|
sl@0
|
1629 |
{
|
|
sl@0
|
1630 |
__SQLPANIC_CLIENT(aCharLen >= 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1631 |
TDes16& buf = Server().GetBuf16L(aCharLen);
|
|
sl@0
|
1632 |
aMessage.ReadL(aArgNum, buf);
|
|
sl@0
|
1633 |
SQLPROFILER_REPORT_IPC(ESqlIpcRead, (aCharLen * sizeof(TText)));
|
|
sl@0
|
1634 |
__SQLPANIC_CLIENT(buf.Length() == aCharLen, aMessage, ESqlPanicBadHandle);
|
|
sl@0
|
1635 |
return buf;
|
|
sl@0
|
1636 |
}
|
|
sl@0
|
1637 |
|
|
sl@0
|
1638 |
/**
|
|
sl@0
|
1639 |
The method constructs a CSqlSecurityPolicy object from the passed as an argument descriptor.
|
|
sl@0
|
1640 |
|
|
sl@0
|
1641 |
@param aSecurityPolicyData A descriptor with the security policy data.
|
|
sl@0
|
1642 |
|
|
sl@0
|
1643 |
@return A pointer to the created CSqlSecurityPolicy instance.
|
|
sl@0
|
1644 |
|
|
sl@0
|
1645 |
@leave KErrNoMemory, out of memory condition has occured.
|
|
sl@0
|
1646 |
*/
|
|
sl@0
|
1647 |
CSqlSecurityPolicy* CSqlSrvSession::CreateSecurityPolicyL(const TDesC8& aSecurityPolicyData)
|
|
sl@0
|
1648 |
{
|
|
sl@0
|
1649 |
TSecurityPolicy defaultPolicy(TSecurityPolicy::EAlwaysFail);
|
|
sl@0
|
1650 |
CSqlSecurityPolicy* dbPolicy = CSqlSecurityPolicy::NewLC(defaultPolicy);
|
|
sl@0
|
1651 |
RSqlBufFlat& bufFlat = dbPolicy->BufFlat();
|
|
sl@0
|
1652 |
__SQLLEAVE_IF_ERROR(bufFlat.ReAlloc(aSecurityPolicyData.Length()));
|
|
sl@0
|
1653 |
bufFlat.BufPtr().Copy(aSecurityPolicyData);
|
|
sl@0
|
1654 |
CleanupStack::Pop(dbPolicy);
|
|
sl@0
|
1655 |
return dbPolicy;
|
|
sl@0
|
1656 |
}
|
|
sl@0
|
1657 |
|
|
sl@0
|
1658 |
/**
|
|
sl@0
|
1659 |
Reports how many objects are allocated by the client.
|
|
sl@0
|
1660 |
If the database connection is not in a test mode, the allocated memory cells count will be ignored.
|
|
sl@0
|
1661 |
*/
|
|
sl@0
|
1662 |
TInt CSqlSrvSession::CountResources()
|
|
sl@0
|
1663 |
{
|
|
sl@0
|
1664 |
return iStatements.Count() + iIpcStreams.Count() + (iDbResourceTestMode ? User::CountAllocCells() : 0);
|
|
sl@0
|
1665 |
}
|
|
sl@0
|
1666 |
|
|
sl@0
|
1667 |
/**
|
|
sl@0
|
1668 |
Extracts from aMessage:
|
|
sl@0
|
1669 |
- function code;
|
|
sl@0
|
1670 |
- stream or statement handle;
|
|
sl@0
|
1671 |
The function will panic the client if aMessage contains bad function code or bad handle encoded in it.
|
|
sl@0
|
1672 |
*/
|
|
sl@0
|
1673 |
void CSqlSrvSession::Extract(const RMessage2& aMessage, TSqlSrvFunction& aFunction, TInt& aHandle)
|
|
sl@0
|
1674 |
{
|
|
sl@0
|
1675 |
TInt msgCode = aMessage.Function();
|
|
sl@0
|
1676 |
aFunction = static_cast <TSqlSrvFunction> (KSqlSrvFunctionMask & msgCode);
|
|
sl@0
|
1677 |
//All operations with code > ESqlSrvDbDelete require valid iDatabase object.
|
|
sl@0
|
1678 |
if(aFunction > ESqlSrvDbDelete)
|
|
sl@0
|
1679 |
{
|
|
sl@0
|
1680 |
__SQLPANIC_CLIENT(iDatabase != NULL, aMessage, ESqlPanicInvalidObj);
|
|
sl@0
|
1681 |
}
|
|
sl@0
|
1682 |
if(aFunction >= ESqlSrvStmtClose)
|
|
sl@0
|
1683 |
{
|
|
sl@0
|
1684 |
//Extracting handle and handle type from the message code
|
|
sl@0
|
1685 |
TSqlSrvHandleType handleType = static_cast <TSqlSrvHandleType> (msgCode & KSqlSrvHandleTypeMask);
|
|
sl@0
|
1686 |
aHandle = (msgCode & KSqlSrvHandleMask) >> KSqlSrvHandleShiftBits;
|
|
sl@0
|
1687 |
__SQLPANIC_CLIENT(aHandle > 0, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1688 |
if(aFunction < ESqlSrvStreamBase)
|
|
sl@0
|
1689 |
{
|
|
sl@0
|
1690 |
__SQLPANIC_CLIENT(handleType == ESqlSrvStatementHandle, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1691 |
}
|
|
sl@0
|
1692 |
else
|
|
sl@0
|
1693 |
{
|
|
sl@0
|
1694 |
__SQLPANIC_CLIENT(handleType == ESqlSrvStreamHandle, aMessage, ESqlPanicBadArgument);
|
|
sl@0
|
1695 |
}
|
|
sl@0
|
1696 |
}
|
|
sl@0
|
1697 |
}
|
|
sl@0
|
1698 |
|
|
sl@0
|
1699 |
/**
|
|
sl@0
|
1700 |
The function reads aStmt column 0 value and copies it into the client buffer, accessed via aMessage argument.
|
|
sl@0
|
1701 |
|
|
sl@0
|
1702 |
If an error occurs during the execution the function leaves with the error code.
|
|
sl@0
|
1703 |
Possible non-leaving return values:
|
|
sl@0
|
1704 |
- KErrNone - the function has completed successfully;
|
|
sl@0
|
1705 |
- Positive return value - the length of the column, which means - the destination buffer is too small.
|
|
sl@0
|
1706 |
This return value is possible only with text or binary columns.
|
|
sl@0
|
1707 |
|
|
sl@0
|
1708 |
Usage of the IPC call arguments:
|
|
sl@0
|
1709 |
Arg 0: [in] (8/16-bit character length of SQL statement) | (expected column value type << 24).
|
|
sl@0
|
1710 |
Arg 1: [in] SQL statement.
|
|
sl@0
|
1711 |
Arg 2: [in] Byte max length of the receiving buffer
|
|
sl@0
|
1712 |
Arg 3: [in/out] The receiving buffer
|
|
sl@0
|
1713 |
*/
|
|
sl@0
|
1714 |
TInt CSqlSrvSession::GetColumnValueL(const RMessage2& aMessage, CSqlSrvStatement& aStmt, TSqlColumnType aColType)
|
|
sl@0
|
1715 |
{
|
|
sl@0
|
1716 |
TInt rc = KErrNone;
|
|
sl@0
|
1717 |
switch(aColType)
|
|
sl@0
|
1718 |
{
|
|
sl@0
|
1719 |
case ESqlInt:
|
|
sl@0
|
1720 |
{
|
|
sl@0
|
1721 |
TInt val = aStmt.ColumnInt(0);
|
|
sl@0
|
1722 |
aMessage.WriteL(3, TPtrC8(reinterpret_cast <const TUint8*> (&val), sizeof(val)));
|
|
sl@0
|
1723 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, sizeof(val));
|
|
sl@0
|
1724 |
}
|
|
sl@0
|
1725 |
break;
|
|
sl@0
|
1726 |
case ESqlInt64:
|
|
sl@0
|
1727 |
{
|
|
sl@0
|
1728 |
TInt64 val = aStmt.ColumnInt64(0);
|
|
sl@0
|
1729 |
aMessage.WriteL(3, TPtrC8(reinterpret_cast <const TUint8*> (&val), sizeof(val)));
|
|
sl@0
|
1730 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, sizeof(val));
|
|
sl@0
|
1731 |
}
|
|
sl@0
|
1732 |
break;
|
|
sl@0
|
1733 |
case ESqlReal:
|
|
sl@0
|
1734 |
{
|
|
sl@0
|
1735 |
TReal val = aStmt.ColumnReal(0);
|
|
sl@0
|
1736 |
aMessage.WriteL(3, TPtrC8(reinterpret_cast <const TUint8*> (&val), sizeof(val)));
|
|
sl@0
|
1737 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, sizeof(val));
|
|
sl@0
|
1738 |
}
|
|
sl@0
|
1739 |
break;
|
|
sl@0
|
1740 |
case ESqlText:
|
|
sl@0
|
1741 |
case ESqlBinary:
|
|
sl@0
|
1742 |
default:
|
|
sl@0
|
1743 |
{
|
|
sl@0
|
1744 |
TPtrC8 val;
|
|
sl@0
|
1745 |
if(aColType == ESqlText)
|
|
sl@0
|
1746 |
{
|
|
sl@0
|
1747 |
TPtrC textVal = aStmt.ColumnTextL(0);
|
|
sl@0
|
1748 |
val.Set(reinterpret_cast <const TUint8*> (textVal.Ptr()), textVal.Length() * sizeof(TUint16));
|
|
sl@0
|
1749 |
}
|
|
sl@0
|
1750 |
else
|
|
sl@0
|
1751 |
{
|
|
sl@0
|
1752 |
val.Set(aStmt.ColumnBinary(0));
|
|
sl@0
|
1753 |
}
|
|
sl@0
|
1754 |
TInt len = val.Length();
|
|
sl@0
|
1755 |
if(len > aMessage.Int2())
|
|
sl@0
|
1756 |
{
|
|
sl@0
|
1757 |
rc = aColType == ESqlText ? (TUint)len / sizeof(TUint16) : len;
|
|
sl@0
|
1758 |
len = aMessage.Int2();
|
|
sl@0
|
1759 |
}
|
|
sl@0
|
1760 |
aMessage.WriteL(3, val.Left(len));
|
|
sl@0
|
1761 |
SQLPROFILER_REPORT_IPC(ESqlIpcWrite, len);
|
|
sl@0
|
1762 |
}
|
|
sl@0
|
1763 |
break;
|
|
sl@0
|
1764 |
}
|
|
sl@0
|
1765 |
return rc;
|
|
sl@0
|
1766 |
}
|