marcucio / Cordova-WP-SqlitePlugin

14 stars 20 forks source link

Issue while Communicating with Sqlite database #21

Open sumeshkuyyali opened 10 years ago

sumeshkuyyali commented 10 years ago

HI, Integrated this sqlite plugin with my windows phone application, on my application start i executed almost 15-25 queries. some times i got the following error and i can't use my application

at Sqlite3.sqlite3EndTable(Parse pParse, Token pCons, Token pEnd, Select pSelect)
at Sqlite3.sqlite3EndTable(Parse pParse, Token pCons, Token pEnd, Int32 null_4)
at Sqlite3.yy_reduce(yyParser yypParser, Int32 yyruleno)
at Sqlite3.sqlite3Parser(yyParser yyp, Int32 yymajor, Token yyminor, Parse pParse)
at Sqlite3.sqlite3RunParser(Parse pParse, String zSql, String& pzErrMsg)
at Sqlite3.sqlite3Prepare(sqlite3 db, String zSql, Int32 nBytes, Int32 saveSqlFlag, Vdbe pReprepare, Vdbe& ppStmt, String& pzTail)
at Sqlite3.sqlite3LockAndPrepare(sqlite3 db, String zSql, Int32 nBytes, Int32 saveSqlFlag, Vdbe pOld, Vdbe& ppStmt, String& pzTail)
at Sqlite3.sqlite3_prepare(sqlite3 db, String zSql, Int32 nBytes, Vdbe& ppStmt, String& pzTail)
at Sqlite3.sqlite3_prepare(sqlite3 db, String zSql, Int32 nBytes, Vdbe& ppStmt, Int32 dummy)
at Sqlite3.sqlite3InitCallback(Object pInit, Int64 argc, Object p2, Object NotUsed)
at Sqlite3.sqlite3InitOne(sqlite3 db, Int32 iDb, String& pzErrMsg)
at Sqlite3.sqlite3Init(sqlite3 db, String& pzErrMsg)
at Sqlite3.sqlite3ReadSchema(Parse pParse)
at Sqlite3.sqlite3LocateTable(Parse pParse, Int32 isView, String zName, String zDbase)
at Sqlite3.selectExpander(Walker pWalker, Select p)
at Sqlite3.sqlite3WalkSelect(Walker pWalker, Select p)
at Sqlite3.sqlite3SelectExpand(Parse pParse, Select pSelect)
at Sqlite3.sqlite3SelectPrep(Parse pParse, Select p, NameContext pOuterNC)
at Sqlite3.sqlite3Select(Parse pParse, Select p, SelectDest& pDest)
at Sqlite3.yy_reduce(yyParser yypParser, Int32 yyruleno)
at Sqlite3.sqlite3Parser(yyParser yyp, Int32 yymajor, Token yyminor, Parse pParse)
at Sqlite3.sqlite3RunParser(Parse pParse, String zSql, String& pzErrMsg)
at Sqlite3.sqlite3Prepare(sqlite3 db, String zSql, Int32 nBytes, Int32 saveSqlFlag, Vdbe pReprepare, Vdbe& ppStmt, String& pzTail)
at Sqlite3.sqlite3LockAndPrepare(sqlite3 db, String zSql, Int32 nBytes, Int32 saveSqlFlag, Vdbe pOld, Vdbe& ppStmt, String& pzTail)
at Sqlite3.sqlite3_prepare_v2(sqlite3 db, String zSql, Int32 nBytes, Vdbe& ppStmt, Int32 dummy)
at SQLite3.Prepare2(sqlite3 db, String query)
at SQLiteCommand.Prepare()
at d0.MoveNext()
at List1..ctor(IEnumerable1 collection)
at Enumerable.ToList(IEnumerable`1 source)
at SQLiteCommand.ExecuteQuery()
at SQLiteConnection.Query2(String query, Object[] args)
at <>c
DisplayClass2.b0()
at SQLiteConnection.RunInTransaction(Action action)
at SQLitePlugin.executeSqlBatch(String options)
at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at MethodBase.Invoke(Object obj, Object[] parameters)
at BaseCommand.InvokeMethodNamed(String methodName, Object[] args)
at <>c
DisplayClass7.b__2()
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart()