System.Data.SQLite
Check-in [661e488237]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Prevent encrypted connections from being used with the connection pool. Pursuant to [89d3a159f1].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 661e4882371a7e6ad8f72d8668984a06653f4d92
User & Date: mistachkin 2015-08-08 01:28:43
References
2015-08-08
01:29 Closed ticket [89d3a159f1]: Issue with Lost Updates with Password protected database with Connection Pooling ON. plus 6 other changes artifact: 39ac05b775 user: mistachkin
Context
2015-08-12
17:53
Compilation fixes for .NET Compact Framework with custom compile options. check-in: 8d08bc1cf9 user: mistachkin tags: trunk
2015-08-08
01:28
Prevent encrypted connections from being used with the connection pool. Pursuant to [89d3a159f1]. check-in: 661e488237 user: mistachkin tags: trunk
2015-07-30
18:30
Update release procedures wiki page. check-in: fc9062d656 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/Provider/version.html.

    44     44       <div id="mainBody">
    45     45       <h1 class="heading">Version History</h1>
    46     46       <p><b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b></p>
    47     47       <ul>
    48     48         <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_11_1.html">SQLite 3.8.11.1</a>.</li>
    49     49         <li>Add full support for Visual Studio 2015 and the .NET Framework 4.6.</li>
    50     50         <li>Implement the Substring method for LINQ using the &quot;substr&quot; core SQL function.&nbsp;<b>** Potentially Incompatible Change **</b></li>
           51  +      <li>Prevent encrypted connections from being used with the connection pool. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/89d3a159f1">[89d3a159f1]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    51     52         <li>Honor the second argument to Math.Round when using LINQ.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    52     53         <li>Honor the pre-existing flags for connections during the Open method. Fix for <a href="https://system.data.sqlite.org/index.html/info/964063da16">[964063da16]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    53     54         <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for <a href="https://system.data.sqlite.org/index.html/info/9d353b0bd8">[9d353b0bd8]</a>.</li>
    54     55         <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    55     56         <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/71bedaca19">[71bedaca19]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    56     57         <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li>
    57     58         <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li>

Changes to System.Data.SQLite/SQLite3.cs.

  2631   2631       }
  2632   2632   
  2633   2633   #if INTEROP_CODEC || INTEROP_INCLUDE_SEE
  2634   2634       internal override void SetPassword(byte[] passwordBytes)
  2635   2635       {
  2636   2636         SQLiteErrorCode n = UnsafeNativeMethods.sqlite3_key(_sql, passwordBytes, passwordBytes.Length);
  2637   2637         if (n != SQLiteErrorCode.Ok) throw new SQLiteException(n, GetLastError());
         2638  +      _usePool = false;
  2638   2639       }
  2639   2640   
  2640   2641       internal override void ChangePassword(byte[] newPasswordBytes)
  2641   2642       {
  2642   2643         SQLiteErrorCode n = UnsafeNativeMethods.sqlite3_rekey(_sql, newPasswordBytes, (newPasswordBytes == null) ? 0 : newPasswordBytes.Length);
  2643   2644         if (n != SQLiteErrorCode.Ok) throw new SQLiteException(n, GetLastError());
         2645  +      _usePool = false;
  2644   2646       }
  2645   2647   #endif
  2646   2648   
  2647   2649       internal override void SetProgressHook(int nOps, SQLiteProgressCallback func)
  2648   2650       {
  2649   2651           UnsafeNativeMethods.sqlite3_progress_handler(_sql, nOps, func, IntPtr.Zero);
  2650   2652       }

Changes to readme.htm.

   211    211   <p>
   212    212       <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b>
   213    213   </p>
   214    214   <ul>
   215    215       <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_11_1.html">SQLite 3.8.11.1</a>.</li>
   216    216       <li>Add full support for Visual Studio 2015 and the .NET Framework 4.6.</li>
   217    217       <li>Implement the Substring method for LINQ using the &quot;substr&quot; core SQL function.&nbsp;<b>** Potentially Incompatible Change **</b></li>
          218  +    <li>Prevent encrypted connections from being used with the connection pool. Pursuant to [89d3a159f1].&nbsp;<b>** Potentially Incompatible Change **</b></li>
   218    219       <li>Honor the second argument to Math.Round when using LINQ.&nbsp;<b>** Potentially Incompatible Change **</b></li>
   219    220       <li>Honor the pre-existing flags for connections during the Open method. Fix for [964063da16].&nbsp;<b>** Potentially Incompatible Change **</b></li>
   220    221       <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li>
   221    222       <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer.&nbsp;<b>** Potentially Incompatible Change **</b></li>
   222    223       <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19].&nbsp;<b>** Potentially Incompatible Change **</b></li>
   223    224       <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li>
   224    225       <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li>

Changes to www/news.wiki.

     5      5   <p>
     6      6       <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b>
     7      7   </p>
     8      8   <ul>
     9      9       <li>Updated to [https://www.sqlite.org/releaselog/3_8_11_1.html|SQLite 3.8.11.1].</li>
    10     10       <li>Add full support for Visual Studio 2015 and the .NET Framework 4.6.</li>
    11     11       <li>Implement the Substring method for LINQ using the &quot;substr&quot; core SQL function.&nbsp;<b>** Potentially Incompatible Change **</b></li>
           12  +    <li>Prevent encrypted connections from being used with the connection pool. Pursuant to [89d3a159f1].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    12     13       <li>Honor the second argument to Math.Round when using LINQ.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    13     14       <li>Honor the pre-existing flags for connections during the Open method. Fix for [964063da16].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    14     15       <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li>
    15     16       <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    16     17       <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    17     18       <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li>
    18     19       <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li>