h2database Engine_database_其他

<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/625d0debbe9ad24cfa756f9b/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/625d0debbe9ad24cfa756f9b/bg1.jpg"><div class="c x0 y1 w0 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">H2 Database Engine</div><div class="t m0 x1 h4 y3 ff2 fs1 fc1 sc0 ls0 ws0">Version 1.2.133 (2010-04-10)</div><div class="t m0 x2 h4 y4 ff2 fs1 fc1 sc0 ls0 ws0">1 of 157</div></div></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div> </body> </html>

<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/625d0debbe9ad24cfa756f9b/bg2.jpg"><div class="c x0 y1 w0 h2"><div class="t m0 x1 h5 y5 ff1 fs2 fc1 sc0 ls0 ws0">Table of Contents</div><div class="t m0 x1 h4 y6 ff2 fs1 fc2 sc0 ls0 ws0">H2 Database Engine.............................................................................................................................................................1</div><div class="t m0 x1 h4 y7 ff2 fs1 fc2 sc0 ls0 ws0">Quickstart..........................................................................................................................................................................11</div><div class="t m0 x3 h4 y8 ff2 fs1 fc2 sc0 ls0 ws0">Embedding H2 in an Application.....................................................................................................................................11</div><div class="t m0 x3 h4 y9 ff2 fs1 fc2 sc0 ls0 ws0">The H2 Console Application...........................................................................................................................................11</div><div class="t m0 x4 h4 ya ff2 fs1 fc2 sc0 ls0 ws0">Step-by-Step...........................................................................................................................................................11</div><div class="t m0 x5 h4 yb ff2 fs1 fc2 sc0 ls0 ws0">Installation.........................................................................................................................................................11</div><div class="t m0 x5 h4 yc ff2 fs1 fc2 sc0 ls0 ws0">Start the Console................................................................................................................................................11</div><div class="t m0 x5 h4 yd ff2 fs1 fc2 sc0 ls0 ws0">Login.................................................................................................................................................................12</div><div class="t m0 x5 h4 ye ff2 fs1 fc2 sc0 ls0 ws0">Sample..............................................................................................................................................................13</div><div class="t m0 x5 h4 yf ff2 fs1 fc2 sc0 ls0 ws0">Execute..............................................................................................................................................................14</div><div class="t m0 x5 h4 y10 ff2 fs1 fc2 sc0 ls0 ws0">Disconnect.........................................................................................................................................................15</div><div class="t m0 x5 h4 y11 ff2 fs1 fc2 sc0 ls0 ws0">End....................................................................................................................................................................15</div><div class="t m0 x1 h4 y12 ff2 fs1 fc2 sc0 ls0 ws0">Installation.........................................................................................................................................................................16</div><div class="t m0 x3 h4 y13 ff2 fs1 fc2 sc0 ls0 ws0">Requirements...............................................................................................................................................................16</div><div class="t m0 x3 h4 y14 ff2 fs1 fc2 sc0 ls0 ws0">Supported Platforms......................................................................................................................................................16</div><div class="t m0 x3 h4 y15 ff2 fs1 fc2 sc0 ls0 ws0">Installing the Software..................................................................................................................................................16</div><div class="t m0 x3 h4 y16 ff2 fs1 fc2 sc0 ls0 ws0">Directory Structure........................................................................................................................................................16</div><div class="t m0 x1 h4 y17 ff2 fs1 fc2 sc0 ls0 ws0">Tutorial..............................................................................................................................................................................17</div><div class="t m0 x3 h4 y18 ff2 fs1 fc2 sc0 ls0 ws0">Starting and Using the H2 Console.................................................................................................................................17</div><div class="t m0 x4 h4 y19 ff2 fs1 fc2 sc0 ls0 ws0">Firewall...................................................................................................................................................................18</div><div class="t m0 x4 h4 y1a ff2 fs1 fc2 sc0 ls0 ws0">Testing Java............................................................................................................................................................18</div><div class="t m0 x4 h4 y1b ff2 fs1 fc2 sc0 ls0 ws0">Error Message 'Port may be in use'...........................................................................................................................18</div><div class="t m0 x4 h4 y1c ff2 fs1 fc2 sc0 ls0 ws0">Using another Port...................................................................................................................................................18</div><div class="t m0 x4 h4 y1d ff2 fs1 fc2 sc0 ls0 ws0">Connecting to the Server using a Browser.................................................................................................................18</div><div class="t m0 x4 h4 y1e ff2 fs1 fc2 sc0 ls0 ws0">Multiple Concurrent Sessions....................................................................................................................................18</div><div class="t m0 x4 h4 y1f ff2 fs1 fc2 sc0 ls0 ws0">Login......................................................................................................................................................................18</div><div class="t m0 x4 h4 y20 ff2 fs1 fc2 sc0 ls0 ws0">Error Messages........................................................................................................................................................18</div><div class="t m0 x4 h4 y21 ff2 fs1 fc2 sc0 ls0 ws0">Adding Database Drivers..........................................................................................................................................19</div><div class="t m0 x4 h4 y22 ff2 fs1 fc2 sc0 ls0 ws0">Using the H2 Console...............................................................................................................................................19</div><div class="t m0 x4 h4 y23 ff2 fs1 fc2 sc0 ls0 ws0">Inserting Table Names or Column Names..................................................................................................................19</div><div class="t m0 x4 h4 y24 ff2 fs1 fc2 sc0 ls0 ws0">Disconnecting and Stopping the Application...............................................................................................................19</div><div class="t m0 x3 h4 y25 ff2 fs1 fc2 sc0 ls0 ws0">Settings of the H2 Console............................................................................................................................................19</div><div class="t m0 x3 h4 y26 ff2 fs1 fc2 sc0 ls0 ws0">Connecting to a Database using JDBC............................................................................................................................19</div><div class="t m0 x3 h4 y27 ff2 fs1 fc2 sc0 ls0 ws0">Creating New Databases................................................................................................................................................20</div><div class="t m0 x3 h4 y28 ff2 fs1 fc2 sc0 ls0 ws0">Using the Server...........................................................................................................................................................20</div><div class="t m0 x4 h4 y29 ff2 fs1 fc2 sc0 ls0 ws0">Starting the Server Tool from Command Line............................................................................................................20</div><div class="t m0 x4 h4 y2a ff2 fs1 fc2 sc0 ls0 ws0">Connecting to the TCP Server...................................................................................................................................20</div><div class="t m0 x4 h4 y2b ff2 fs1 fc2 sc0 ls0 ws0">Starting the TCP Server within an Application............................................................................................................20</div><div class="t m0 x4 h4 y2c ff2 fs1 fc2 sc0 ls0 ws0">Stopping a TCP Server from Another Process.............................................................................................................20</div><div class="t m0 x3 h4 y2d ff2 fs1 fc2 sc0 ls0 ws0">Using Hibernate............................................................................................................................................................21</div><div class="t m0 x3 h4 y2e ff2 fs1 fc2 sc0 ls0 ws0">Using TopLink and Glassfish..........................................................................................................................................21</div><div class="t m0 x3 h4 y2f ff2 fs1 fc2 sc0 ls0 ws0">Using EclipseLink..........................................................................................................................................................21</div><div class="t m0 x3 h4 y30 ff2 fs1 fc2 sc0 ls0 ws0">Using Databases in Web Applications.............................................................................................................................21</div><div class="t m0 x4 h4 y31 ff2 fs1 fc2 sc0 ls0 ws0">Embedded Mode......................................................................................................................................................21</div><div class="t m0 x4 h4 y32 ff2 fs1 fc2 sc0 ls0 ws0">Server Mode............................................................................................................................................................21</div><div class="t m0 x4 h4 y33 ff2 fs1 fc2 sc0 ls0 ws0">Using a Servlet Listener to Start and Stop a Database................................................................................................22</div><div class="t m0 x4 h4 y34 ff2 fs1 fc2 sc0 ls0 ws0">Using the H2 Console Servlet....................................................................................................................................22</div><div class="t m0 x3 h4 y35 ff2 fs1 fc2 sc0 ls0 ws0">CSV (Comma Separated Values) Support........................................................................................................................23</div><div class="t m0 x4 h4 y36 ff2 fs1 fc2 sc0 ls0 ws0">Writing a CSV File from Within a Database................................................................................................................23</div><div class="t m0 x4 h4 y37 ff2 fs1 fc2 sc0 ls0 ws0">Reading a CSV File from Within a Database...............................................................................................................23</div><div class="t m0 x4 h4 y38 ff2 fs1 fc2 sc0 ls0 ws0">Writing a CSV File from a Java Application.................................................................................................................23</div><div class="t m0 x4 h4 y39 ff2 fs1 fc2 sc0 ls0 ws0">Reading a CSV File from a Java Application...............................................................................................................23</div><div class="t m0 x3 h4 y3a ff2 fs1 fc2 sc0 ls0 ws0">Upgrade, Backup, and Restore.......................................................................................................................................24</div><div class="t m0 x4 h4 y3b ff2 fs1 fc2 sc0 ls0 ws0">Database Upgrade...................................................................................................................................................24</div><div class="t m0 x4 h4 y3c ff2 fs1 fc2 sc0 ls0 ws0">Backup using the Script Tool....................................................................................................................................24</div><div class="t m0 x4 h4 y3d ff2 fs1 fc2 sc0 ls0 ws0">Restore from a Script...............................................................................................................................................24</div><div class="t m0 x4 h4 y3e ff2 fs1 fc2 sc0 ls0 ws0">Online Backup.........................................................................................................................................................24</div><div class="t m0 x3 h4 y3f ff2 fs1 fc2 sc0 ls0 ws0">Command Line Tools.....................................................................................................................................................25</div><div class="t m0 x3 h4 y40 ff2 fs1 fc2 sc0 ls0 ws0">The Shell Tool...............................................................................................................................................................25</div><div class="t m0 x3 h4 y41 ff2 fs1 fc2 sc0 ls0 ws0">Using OpenOffice Base..................................................................................................................................................25</div><div class="t m0 x3 h4 y42 ff2 fs1 fc2 sc0 ls0 ws0">Java Web Start / JNLP...................................................................................................................................................26</div><div class="t m0 x3 h4 y43 ff2 fs1 fc2 sc0 ls0 ws0">Using a Connection Pool................................................................................................................................................26</div><div class="t m0 x3 h4 y44 ff2 fs1 fc2 sc0 ls0 ws0">Fulltext Search..............................................................................................................................................................27</div><div class="t m0 x4 h4 y45 ff2 fs1 fc2 sc0 ls0 ws0">Using the Native Fulltext Search...............................................................................................................................27</div><div class="t m0 x4 h4 y46 ff2 fs1 fc2 sc0 ls0 ws0">Using the Lucene Fulltext Search..............................................................................................................................27</div><div class="t m0 x3 h4 y47 ff2 fs1 fc2 sc0 ls0 ws0">User-Defined Variables..................................................................................................................................................28</div><div class="t m0 x2 h4 y4 ff2 fs1 fc1 sc0 ls0 ws0">2 of 157</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>

<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/625d0debbe9ad24cfa756f9b/bg3.jpg"><div class="c x0 y1 w0 h2"><div class="t m0 x3 h4 y48 ff2 fs1 fc2 sc0 ls0 ws0">Date and Time..............................................................................................................................................................28</div><div class="t m0 x3 h4 y49 ff2 fs1 fc2 sc0 ls0 ws0">Using Spring.................................................................................................................................................................28</div><div class="t m0 x1 h4 y4a ff2 fs1 fc2 sc0 ls0 ws0">Features............................................................................................................................................................................29</div><div class="t m0 x3 h4 y4b ff2 fs1 fc2 sc0 ls0 ws0">Feature List..................................................................................................................................................................29</div><div class="t m0 x4 h4 y3 ff2 fs1 fc2 sc0 ls0 ws0">Main Features..........................................................................................................................................................29</div><div class="t m0 x4 h4 y4c ff2 fs1 fc2 sc0 ls0 ws0">Additional Features..................................................................................................................................................29</div><div class="t m0 x4 h4 y4d ff2 fs1 fc2 sc0 ls0 ws0">SQL Support............................................................................................................................................................29</div><div class="t m0 x4 h4 y4e ff2 fs1 fc2 sc0 ls0 ws0">Security Features.....................................................................................................................................................30</div><div class="t m0 x4 h4 y4f ff2 fs1 fc2 sc0 ls0 ws0">Other Features and Tools.........................................................................................................................................30</div><div class="t m0 x3 h4 y50 ff2 fs1 fc2 sc0 ls0 ws0">Comparison to Other Database Engines..........................................................................................................................30</div><div class="t m0 x4 h4 y51 ff2 fs1 fc2 sc0 ls0 ws0">Derby and HSQLDB..................................................................................................................................................31</div><div class="t m0 x4 h4 y52 ff2 fs1 fc2 sc0 ls0 ws0">DaffodilDb and One$Db............................................................................................................................................31</div><div class="t m0 x4 h4 y53 ff2 fs1 fc2 sc0 ls0 ws0">McKoi......................................................................................................................................................................31</div><div class="t m0 x3 h4 y54 ff2 fs1 fc2 sc0 ls0 ws0">H2 in Use.....................................................................................................................................................................31</div><div class="t m0 x3 h4 y55 ff2 fs1 fc2 sc0 ls0 ws0">Connection Modes.........................................................................................................................................................31</div><div class="t m0 x4 h4 y56 ff2 fs1 fc2 sc0 ls0 ws0">Embedded Mode......................................................................................................................................................31</div><div class="t m0 x4 h4 y57 ff2 fs1 fc2 sc0 ls0 ws0">Server Mode............................................................................................................................................................32</div><div class="t m0 x4 h4 y58 ff2 fs1 fc2 sc0 ls0 ws0">Mixed Mode.............................................................................................................................................................32</div><div class="t m0 x3 h4 y59 ff2 fs1 fc2 sc0 ls0 ws0">Database URL Overview................................................................................................................................................33</div><div class="t m0 x3 h4 y5a ff2 fs1 fc2 sc0 ls0 ws0">Connecting to an Embedded (Local) Database................................................................................................................34</div><div class="t m0 x3 h4 y5b ff2 fs1 fc2 sc0 ls0 ws0">In-Memory Databases...................................................................................................................................................34</div><div class="t m0 x3 h4 y5c ff2 fs1 fc2 sc0 ls0 ws0">Database Files Encryption..............................................................................................................................................34</div><div class="t m0 x4 h4 y5d ff2 fs1 fc2 sc0 ls0 ws0">Creating a New Database with File Encryption...........................................................................................................34</div><div class="t m0 x4 h4 y5e ff2 fs1 fc2 sc0 ls0 ws0">Connecting to an Encrypted Database.......................................................................................................................34</div><div class="t m0 x4 h4 y5f ff2 fs1 fc2 sc0 ls0 ws0">Encrypting or Decrypting a Database........................................................................................................................35</div><div class="t m0 x3 h4 y60 ff2 fs1 fc2 sc0 ls0 ws0">Database File Locking....................................................................................................................................................35</div><div class="t m0 x3 h4 y61 ff2 fs1 fc2 sc0 ls0 ws0">Opening a Database Only if it Already Exists...................................................................................................................35</div><div class="t m0 x3 h4 y62 ff2 fs1 fc2 sc0 ls0 ws0">Closing a Database........................................................................................................................................................35</div><div class="t m0 x4 h4 y63 ff2 fs1 fc2 sc0 ls0 ws0">Delayed Database Closing........................................................................................................................................35</div><div class="t m0 x4 h4 y64 ff2 fs1 fc2 sc0 ls0 ws0">Don't Close a Database when the VM Exits................................................................................................................36</div><div class="t m0 x3 h4 y65 ff2 fs1 fc2 sc0 ls0 ws0">Execute SQL on Connection...........................................................................................................................................36</div><div class="t m0 x3 h4 y66 ff2 fs1 fc2 sc0 ls0 ws0">Ignore Unknown Settings..............................................................................................................................................36</div><div class="t m0 x3 h4 y67 ff2 fs1 fc2 sc0 ls0 ws0">Changing Other Settings when Opening a Connection.....................................................................................................36</div><div class="t m0 x3 h4 y68 ff2 fs1 fc2 sc0 ls0 ws0">Custom File Access Mode...............................................................................................................................................36</div><div class="t m0 x3 h4 y69 ff2 fs1 fc2 sc0 ls0 ws0">Multiple Connections.....................................................................................................................................................37</div><div class="t m0 x4 h4 y6a ff2 fs1 fc2 sc0 ls0 ws0">Opening Multiple Databases at the Same Time..........................................................................................................37</div><div class="t m0 x4 h4 y6b ff2 fs1 fc2 sc0 ls0 ws0">Multiple Connections to the Same Database: Client/Server.........................................................................................37</div><div class="t m0 x4 h4 y6c ff2 fs1 fc2 sc0 ls0 ws0">Multithreading Support.............................................................................................................................................37</div><div class="t m0 x4 h4 y6d ff2 fs1 fc2 sc0 ls0 ws0">Locking, Lock-Timeout, Deadlocks............................................................................................................................37</div><div class="t m0 x3 h4 y6e ff2 fs1 fc2 sc0 ls0 ws0">Database File Layout.....................................................................................................................................................37</div><div class="t m0 x4 h4 y6f ff2 fs1 fc2 sc0 ls0 ws0">Moving and Renaming Database Files.......................................................................................................................38</div><div class="t m0 x4 h4 y70 ff2 fs1 fc2 sc0 ls0 ws0">Backup....................................................................................................................................................................38</div><div class="t m0 x3 h4 y71 ff2 fs1 fc2 sc0 ls0 ws0">Logging and Recovery...................................................................................................................................................38</div><div class="t m0 x3 h4 y72 ff2 fs1 fc2 sc0 ls0 ws0">Compatibility.................................................................................................................................................................38</div><div class="t m0 x4 h4 y73 ff2 fs1 fc2 sc0 ls0 ws0">Compatibility Modes.................................................................................................................................................38</div><div class="t m0 x4 h4 y74 ff2 fs1 fc2 sc0 ls0 ws0">DB2 Compatibility Mode...........................................................................................................................................39</div><div class="t m0 x4 h4 y75 ff2 fs1 fc2 sc0 ls0 ws0">Derby Compatibility Mode.........................................................................................................................................39</div><div class="t m0 x4 h4 y76 ff2 fs1 fc2 sc0 ls0 ws0">HSQLDB Compatibility Mode.....................................................................................................................................39</div><div class="t m0 x4 h4 y77 ff2 fs1 fc2 sc0 ls0 ws0">MS SQL Server Compatibility Mode...........................................................................................................................39</div><div class="t m0 x4 h4 y78 ff2 fs1 fc2 sc0 ls0 ws0">MySQL Compatibility Mode.......................................................................................................................................39</div><div class="t m0 x4 h4 y79 ff2 fs1 fc2 sc0 ls0 ws0">Oracle Compatibility Mode........................................................................................................................................39</div><div class="t m0 x4 h4 y7a ff2 fs1 fc2 sc0 ls0 ws0">PostgreSQL Compatibility Mode................................................................................................................................40</div><div class="t m0 x3 h4 y7b ff2 fs1 fc2 sc0 ls0 ws0">Auto-Reconnect............................................................................................................................................................40</div><div class="t m0 x3 h4 y7c ff2 fs1 fc2 sc0 ls0 ws0">Automatic Mixed Mode..................................................................................................................................................40</div><div class="t m0 x3 h4 y7d ff2 fs1 fc2 sc0 ls0 ws0">Using the Trace Options................................................................................................................................................40</div><div class="t m0 x4 h4 y7e ff2 fs1 fc2 sc0 ls0 ws0">Trace Options..........................................................................................................................................................41</div><div class="t m0 x4 h4 y7f ff2 fs1 fc2 sc0 ls0 ws0">Setting the Maximum Size of the Trace File...............................................................................................................41</div><div class="t m0 x4 h4 y80 ff2 fs1 fc2 sc0 ls0 ws0">Java Code Generation..............................................................................................................................................41</div><div class="t m0 x3 h4 y81 ff2 fs1 fc2 sc0 ls0 ws0">Using Other Logging APIs..............................................................................................................................................41</div><div class="t m0 x3 h4 y82 ff2 fs1 fc2 sc0 ls0 ws0">Read Only Databases....................................................................................................................................................42</div><div class="t m0 x3 h4 y83 ff2 fs1 fc2 sc0 ls0 ws0">Read Only Databases in Zip or Jar File............................................................................................................................42</div><div class="t m0 x3 h4 y84 ff2 fs1 fc2 sc0 ls0 ws0">Graceful Handling of Low Disk Space Situations..............................................................................................................42</div><div class="t m0 x4 h4 y85 ff2 fs1 fc2 sc0 ls0 ws0">Opening a Corrupted Database.................................................................................................................................42</div><div class="t m0 x3 h4 y86 ff2 fs1 fc2 sc0 ls0 ws0">Computed Columns / Function Based Index....................................................................................................................42</div><div class="t m0 x3 h4 y87 ff2 fs1 fc2 sc0 ls0 ws0">Multi-Dimensional Indexes.............................................................................................................................................43</div><div class="t m0 x3 h4 y88 ff2 fs1 fc2 sc0 ls0 ws0">Using Passwords...........................................................................................................................................................43</div><div class="t m0 x4 h4 y89 ff2 fs1 fc2 sc0 ls0 ws0">Using Secure Passwords...........................................................................................................................................43</div><div class="t m0 x4 h4 y8a ff2 fs1 fc2 sc0 ls0 ws0">Passwords: Using Char Arrays instead of Strings........................................................................................................43</div><div class="t m0 x4 h4 y8b ff2 fs1 fc2 sc0 ls0 ws0">Passing the User Name and/or Password in the URL..................................................................................................44</div><div class="t m0 x3 h4 y8c ff2 fs1 fc2 sc0 ls0 ws0">User-Defined Functions and Stored Procedures...............................................................................................................44</div><div class="t m0 x4 h4 y8d ff2 fs1 fc2 sc0 ls0 ws0">Referencing a Compiled Method...............................................................................................................................44</div><div class="t m0 x2 h4 y4 ff2 fs1 fc1 sc0 ls0 ws0">3 of 157</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>

<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/625d0debbe9ad24cfa756f9b/bg4.jpg"><div class="c x0 y1 w0 h2"><div class="t m0 x4 h4 y48 ff2 fs1 fc2 sc0 ls0 ws0">Declaring Functions as Source Code..........................................................................................................................44</div><div class="t m0 x4 h4 y49 ff2 fs1 fc2 sc0 ls0 ws0">Function Data Type Mapping....................................................................................................................................45</div><div class="t m0 x4 h4 y4a ff2 fs1 fc2 sc0 ls0 ws0">Functions That Require a Connection........................................................................................................................45</div><div class="t m0 x4 h4 y4b ff2 fs1 fc2 sc0 ls0 ws0">Functions Throwing an Exception..............................................................................................................................45</div><div class="t m0 x4 h4 y3 ff2 fs1 fc2 sc0 ls0 ws0">Functions Returning a Result Set..............................................................................................................................45</div><div class="t m0 x4 h4 y4c ff2 fs1 fc2 sc0 ls0 ws0">Using SimpleResultSet..............................................................................................................................................45</div><div class="t m0 x4 h4 y4d ff2 fs1 fc2 sc0 ls0 ws0">Using a Function as a Table......................................................................................................................................46</div><div class="t m0 x3 h4 y4e ff2 fs1 fc2 sc0 ls0 ws0">Triggers........................................................................................................................................................................46</div><div class="t m0 x3 h4 y4f ff2 fs1 fc2 sc0 ls0 ws0">Compacting a Database.................................................................................................................................................47</div><div class="t m0 x3 h4 y50 ff2 fs1 fc2 sc0 ls0 ws0">Cache Settings..............................................................................................................................................................47</div><div class="t m0 x1 h4 y51 ff2 fs1 fc2 sc0 ls0 ws0">Performance......................................................................................................................................................................48</div><div class="t m0 x3 h4 y52 ff2 fs1 fc2 sc0 ls0 ws0">Performance Comparison...............................................................................................................................................48</div><div class="t m0 x4 h4 y53 ff2 fs1 fc2 sc0 ls0 ws0">Embedded...............................................................................................................................................................48</div><div class="t m0 x4 h4 y54 ff2 fs1 fc2 sc0 ls0 ws0">Client-Server...........................................................................................................................................................48</div><div class="t m0 x4 h4 y55 ff2 fs1 fc2 sc0 ls0 ws0">Benchmark Results and Comments...........................................................................................................................49</div><div class="t m0 x5 h4 y56 ff2 fs1 fc2 sc0 ls0 ws0">H2.....................................................................................................................................................................49</div><div class="t m0 x5 h4 y57 ff2 fs1 fc2 sc0 ls0 ws0">HSQLDB.............................................................................................................................................................49</div><div class="t m0 x5 h4 y58 ff2 fs1 fc2 sc0 ls0 ws0">Derby................................................................................................................................................................49</div><div class="t m0 x5 h4 y59 ff2 fs1 fc2 sc0 ls0 ws0">PostgreSQL........................................................................................................................................................49</div><div class="t m0 x5 h4 y5a ff2 fs1 fc2 sc0 ls0 ws0">MySQL...............................................................................................................................................................49</div><div class="t m0 x5 h4 y5b ff2 fs1 fc2 sc0 ls0 ws0">Firebird..............................................................................................................................................................50</div><div class="t m0 x5 h4 y5c ff2 fs1 fc2 sc0 ls0 ws0">Why Oracle / MS SQL Server / DB2 are Not Listed................................................................................................50</div><div class="t m0 x4 h4 y5d ff2 fs1 fc2 sc0 ls0 ws0">About this Benchmark..............................................................................................................................................50</div><div class="t m0 x5 h4 y5e ff2 fs1 fc2 sc0 ls0 ws0">How to Run........................................................................................................................................................50</div><div class="t m0 x5 h4 y5f ff2 fs1 fc2 sc0 ls0 ws0">Separate Process per Database...........................................................................................................................50</div><div class="t m0 x5 h4 y60 ff2 fs1 fc2 sc0 ls0 ws0">Number of Connections.......................................................................................................................................50</div><div class="t m0 x5 h4 y61 ff2 fs1 fc2 sc0 ls0 ws0">Real-World Tests................................................................................................................................................50</div><div class="t m0 x5 h4 y62 ff2 fs1 fc2 sc0 ls0 ws0">Comparing Embedded with Server Databases.......................................................................................................50</div><div class="t m0 x5 h4 y63 ff2 fs1 fc2 sc0 ls0 ws0">Test Platform.....................................................................................................................................................50</div><div class="t m0 x5 h4 y64 ff2 fs1 fc2 sc0 ls0 ws0">Multiple Runs.....................................................................................................................................................51</div><div class="t m0 x5 h4 y65 ff2 fs1 fc2 sc0 ls0 ws0">Memory Usage...................................................................................................................................................51</div><div class="t m0 x5 h4 y66 ff2 fs1 fc2 sc0 ls0 ws0">Delayed Operations............................................................................................................................................51</div><div class="t m0 x5 h4 y67 ff2 fs1 fc2 sc0 ls0 ws0">Transaction Commit / Durability..........................................................................................................................51</div><div class="t m0 x5 h4 y68 ff2 fs1 fc2 sc0 ls0 ws0">Using Prepared Statements.................................................................................................................................51</div><div class="t m0 x5 h4 y69 ff2 fs1 fc2 sc0 ls0 ws0">Currently Not Tested: Startup Time.....................................................................................................................51</div><div class="t m0 x3 h4 y6a ff2 fs1 fc2 sc0 ls0 ws0">PolePosition Benchmark.................................................................................................................................................51</div><div class="t m0 x3 h4 y6b ff2 fs1 fc2 sc0 ls0 ws0">Application Profiling.......................................................................................................................................................52</div><div class="t m0 x4 h4 y6c ff2 fs1 fc2 sc0 ls0 ws0">Analyze First............................................................................................................................................................52</div><div class="t m0 x3 h4 y6d ff2 fs1 fc2 sc0 ls0 ws0">Database Profiling.........................................................................................................................................................53</div><div class="t m0 x3 h4 y6e ff2 fs1 fc2 sc0 ls0 ws0">Database Performance Tuning.......................................................................................................................................53</div><div class="t m0 x4 h4 y6f ff2 fs1 fc2 sc0 ls0 ws0">Keep Connections Open or Use a Connection Pool.....................................................................................................53</div><div class="t m0 x4 h4 y70 ff2 fs1 fc2 sc0 ls0 ws0">Use a Modern JVM...................................................................................................................................................53</div><div class="t m0 x4 h4 y71 ff2 fs1 fc2 sc0 ls0 ws0">Virus Scanners.........................................................................................................................................................53</div><div class="t m0 x4 h4 y72 ff2 fs1 fc2 sc0 ls0 ws0">Using the Trace Options...........................................................................................................................................54</div><div class="t m0 x4 h4 y73 ff2 fs1 fc2 sc0 ls0 ws0">Index Usage............................................................................................................................................................54</div><div class="t m0 x4 h4 y74 ff2 fs1 fc2 sc0 ls0 ws0">Optimizer................................................................................................................................................................54</div><div class="t m0 x4 h4 y75 ff2 fs1 fc2 sc0 ls0 ws0">Expression Optimization...........................................................................................................................................54</div><div class="t m0 x4 h4 y76 ff2 fs1 fc2 sc0 ls0 ws0">COUNT(*) Optimization............................................................................................................................................54</div><div class="t m0 x4 h4 y77 ff2 fs1 fc2 sc0 ls0 ws0">Updating Optimizer Statistics / Column Selectivity......................................................................................................54</div><div class="t m0 x4 h4 y78 ff2 fs1 fc2 sc0 ls0 ws0">In-Memory (Hash) Indexes.......................................................................................................................................54</div><div class="t m0 x4 h4 y79 ff2 fs1 fc2 sc0 ls0 ws0">Use Prepared Statements.........................................................................................................................................55</div><div class="t m0 x4 h4 y7a ff2 fs1 fc2 sc0 ls0 ws0">Prepared Statements and IN(...)...............................................................................................................................55</div><div class="t m0 x4 h4 y7b ff2 fs1 fc2 sc0 ls0 ws0">Optimization Examples.............................................................................................................................................55</div><div class="t m0 x4 h4 y7c ff2 fs1 fc2 sc0 ls0 ws0">Cache Size and Type................................................................................................................................................55</div><div class="t m0 x4 h4 y7d ff2 fs1 fc2 sc0 ls0 ws0">Data Types..............................................................................................................................................................55</div><div class="t m0 x4 h4 y7e ff2 fs1 fc2 sc0 ls0 ws0">Sorted Insert Optimization........................................................................................................................................55</div><div class="t m0 x3 h4 y7f ff2 fs1 fc2 sc0 ls0 ws0">Using the Built-In Profiler..............................................................................................................................................55</div><div class="t m0 x3 h4 y80 ff2 fs1 fc2 sc0 ls0 ws0">Fast Database Import....................................................................................................................................................56</div><div class="t m0 x1 h4 y81 ff2 fs1 fc2 sc0 ls0 ws0">Advanced...........................................................................................................................................................................57</div><div class="t m0 x3 h4 y82 ff2 fs1 fc2 sc0 ls0 ws0">Result Sets...................................................................................................................................................................57</div><div class="t m0 x4 h4 y83 ff2 fs1 fc2 sc0 ls0 ws0">Statements that Return a Result Set.........................................................................................................................57</div><div class="t m0 x4 h4 y84 ff2 fs1 fc2 sc0 ls0 ws0">Limiting the Number of Rows...................................................................................................................................57</div><div class="t m0 x4 h4 y85 ff2 fs1 fc2 sc0 ls0 ws0">Large Result Sets and External Sorting......................................................................................................................57</div><div class="t m0 x3 h4 y86 ff2 fs1 fc2 sc0 ls0 ws0">Large Objects...............................................................................................................................................................57</div><div class="t m0 x4 h4 y87 ff2 fs1 fc2 sc0 ls0 ws0">Storing and Reading Large Objects...........................................................................................................................57</div><div class="t m0 x4 h4 y88 ff2 fs1 fc2 sc0 ls0 ws0">When to use CLOB/BLOB..........................................................................................................................................58</div><div class="t m0 x4 h4 y89 ff2 fs1 fc2 sc0 ls0 ws0">Large Object Compression........................................................................................................................................58</div><div class="t m0 x3 h4 y8a ff2 fs1 fc2 sc0 ls0 ws0">Linked Tables...............................................................................................................................................................58</div><div class="t m0 x3 h4 y8b ff2 fs1 fc2 sc0 ls0 ws0">Transaction Isolation.....................................................................................................................................................58</div><div class="t m0 x4 h4 y8c ff2 fs1 fc2 sc0 ls0 ws0">Table Level Locking.................................................................................................................................................59</div><div class="t m0 x4 h4 y8d ff2 fs1 fc2 sc0 ls0 ws0">Lock Timeout...........................................................................................................................................................59</div><div class="t m0 x2 h4 y4 ff2 fs1 fc1 sc0 ls0 ws0">4 of 157</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>

<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/625d0debbe9ad24cfa756f9b/bg5.jpg"><div class="c x0 y1 w0 h2"><div class="t m0 x3 h4 y48 ff2 fs1 fc2 sc0 ls0 ws0">Multi-Version Concurrency Control (MVCC).....................................................................................................................59</div><div class="t m0 x3 h4 y49 ff2 fs1 fc2 sc0 ls0 ws0">Clustering / High Availability..........................................................................................................................................59</div><div class="t m0 x4 h4 y4a ff2 fs1 fc2 sc0 ls0 ws0">Using the CreateCluster Tool....................................................................................................................................60</div><div class="t m0 x4 h4 y4b ff2 fs1 fc2 sc0 ls0 ws0">Detect Which Cluster Instances are Running.............................................................................................................60</div><div class="t m0 x4 h4 y3 ff2 fs1 fc2 sc0 ls0 ws0">Clustering Algorithm and Limitations.........................................................................................................................60</div><div class="t m0 x3 h4 y4c ff2 fs1 fc2 sc0 ls0 ws0">Two Phase Commit.......................................................................................................................................................61</div><div class="t m0 x3 h4 y4d ff2 fs1 fc2 sc0 ls0 ws0">Compatibility.................................................................................................................................................................61</div><div class="t m0 x4 h4 y4e ff2 fs1 fc2 sc0 ls0 ws0">Transaction Commit when Autocommit is On.............................................................................................................61</div><div class="t m0 x4 h4 y4f ff2 fs1 fc2 sc0 ls0 ws0">Keywords / Reserved Words.....................................................................................................................................61</div><div class="t m0 x3 h4 y50 ff2 fs1 fc2 sc0 ls0 ws0">Standards Compliance...................................................................................................................................................61</div><div class="t m0 x3 h4 y51 ff2 fs1 fc2 sc0 ls0 ws0">Run as Windows Service................................................................................................................................................61</div><div class="t m0 x4 h4 y52 ff2 fs1 fc2 sc0 ls0 ws0">Install the Service....................................................................................................................................................62</div><div class="t m0 x4 h4 y53 ff2 fs1 fc2 sc0 ls0 ws0">Start the Service......................................................................................................................................................62</div><div class="t m0 x4 h4 y54 ff2 fs1 fc2 sc0 ls0 ws0">Connect to the H2 Console.......................................................................................................................................62</div><div class="t m0 x4 h4 y55 ff2 fs1 fc2 sc0 ls0 ws0">Stop the Service......................................................................................................................................................62</div><div class="t m0 x4 h4 y56 ff2 fs1 fc2 sc0 ls0 ws0">Uninstall the Service................................................................................................................................................62</div><div class="t m0 x3 h4 y57 ff2 fs1 fc2 sc0 ls0 ws0">ODBC Driver.................................................................................................................................................................62</div><div class="t m0 x4 h4 y58 ff2 fs1 fc2 sc0 ls0 ws0">ODBC Installation....................................................................................................................................................62</div><div class="t m0 x4 h4 y59 ff2 fs1 fc2 sc0 ls0 ws0">Starting the Server...................................................................................................................................................62</div><div class="t m0 x4 h4 y5a ff2 fs1 fc2 sc0 ls0 ws0">ODBC Configuration.................................................................................................................................................63</div><div class="t m0 x4 h4 y5b ff2 fs1 fc2 sc0 ls0 ws0">PG Protocol Support Limitations................................................................................................................................63</div><div class="t m0 x4 h4 y5c ff2 fs1 fc2 sc0 ls0 ws0">Security Considerations............................................................................................................................................63</div><div class="t m0 x3 h4 y5d ff2 fs1 fc2 sc0 ls0 ws0">Using H2 in Microsoft .NET............................................................................................................................................63</div><div class="t m0 x4 h4 y5e ff2 fs1 fc2 sc0 ls0 ws0">Using the ADO.NET API on .NET...............................................................................................................................63</div><div class="t m0 x4 h4 y5f ff2 fs1 fc2 sc0 ls0 ws0">Using the JDBC API on .NET.....................................................................................................................................64</div><div class="t m0 x3 h4 y60 ff2 fs1 fc2 sc0 ls0 ws0">ACID............................................................................................................................................................................64</div><div class="t m0 x4 h4 y61 ff2 fs1 fc2 sc0 ls0 ws0">Atomicity.................................................................................................................................................................64</div><div class="t m0 x4 h4 y62 ff2 fs1 fc2 sc0 ls0 ws0">Consistency.............................................................................................................................................................64</div><div class="t m0 x4 h4 y63 ff2 fs1 fc2 sc0 ls0 ws0">Isolation..................................................................................................................................................................64</div><div class="t m0 x4 h4 y64 ff2 fs1 fc2 sc0 ls0 ws0">Durability................................................................................................................................................................64</div><div class="t m0 x3 h4 y65 ff2 fs1 fc2 sc0 ls0 ws0">Durability Problems.......................................................................................................................................................65</div><div class="t m0 x4 h4 y66 ff2 fs1 fc2 sc0 ls0 ws0">Ways to (Not) Achieve Durability..............................................................................................................................65</div><div class="t m0 x4 h4 y67 ff2 fs1 fc2 sc0 ls0 ws0">Running the Durability Test......................................................................................................................................65</div><div class="t m0 x3 h4 y68 ff2 fs1 fc2 sc0 ls0 ws0">Using the Recover Tool.................................................................................................................................................65</div><div class="t m0 x3 h4 y69 ff2 fs1 fc2 sc0 ls0 ws0">File Locking Protocols....................................................................................................................................................66</div><div class="t m0 x4 h4 y6a ff2 fs1 fc2 sc0 ls0 ws0">File Locking Method 'File'..........................................................................................................................................66</div><div class="t m0 x4 h4 y6b ff2 fs1 fc2 sc0 ls0 ws0">File Locking Method 'Socket'.....................................................................................................................................66</div><div class="t m0 x3 h4 y6c ff2 fs1 fc2 sc0 ls0 ws0">File Locking Method 'Serialized'......................................................................................................................................67</div><div class="t m0 x3 h4 y6d ff2 fs1 fc2 sc0 ls0 ws0">Protection against SQL Injection....................................................................................................................................67</div><div class="t m0 x4 h4 y6e ff2 fs1 fc2 sc0 ls0 ws0">What is SQL Injection..............................................................................................................................................67</div><div class="t m0 x4 h4 y6f ff2 fs1 fc2 sc0 ls0 ws0">Disabling Literals.....................................................................................................................................................67</div><div class="t m0 x4 h4 y70 ff2 fs1 fc2 sc0 ls0 ws0">Using Constants.......................................................................................................................................................68</div><div class="t m0 x4 h4 y71 ff2 fs1 fc2 sc0 ls0 ws0">Using the ZERO() Function.......................................................................................................................................68</div><div class="t m0 x3 h4 y72 ff2 fs1 fc2 sc0 ls0 ws0">Protection against Remote Access..................................................................................................................................68</div><div class="t m0 x3 h4 y73 ff2 fs1 fc2 sc0 ls0 ws0">Restricting Class Loading and Usage..............................................................................................................................68</div><div class="t m0 x3 h4 y74 ff2 fs1 fc2 sc0 ls0 ws0">Security Protocols.........................................................................................................................................................68</div><div class="t m0 x4 h4 y75 ff2 fs1 fc2 sc0 ls0 ws0">User Password Encryption........................................................................................................................................69</div><div class="t m0 x4 h4 y76 ff2 fs1 fc2 sc0 ls0 ws0">File Encryption.........................................................................................................................................................69</div><div class="t m0 x4 h4 y77 ff2 fs1 fc2 sc0 ls0 ws0">Wrong Password / User Name Delay.........................................................................................................................69</div><div class="t m0 x4 h4 y78 ff2 fs1 fc2 sc0 ls0 ws0">HTTPS Connections..................................................................................................................................................70</div><div class="t m0 x3 h4 y79 ff2 fs1 fc2 sc0 ls0 ws0">SSL/TLS Connections.....................................................................................................................................................70</div><div class="t m0 x3 h4 y7a ff2 fs1 fc2 sc0 ls0 ws0">Universally Unique Identifiers (UUID).............................................................................................................................70</div><div class="t m0 x3 h4 y7b ff2 fs1 fc2 sc0 ls0 ws0">Settings Read from System Properties............................................................................................................................70</div><div class="t m0 x3 h4 y7c ff2 fs1 fc2 sc0 ls0 ws0">Setting the Server Bind Address.....................................................................................................................................71</div><div class="t m0 x3 h4 y7d ff2 fs1 fc2 sc0 ls0 ws0">Pluggable File System....................................................................................................................................................71</div><div class="t m0 x3 h4 y7e ff2 fs1 fc2 sc0 ls0 ws0">Limits and Limitations....................................................................................................................................................71</div><div class="t m0 x3 h4 y7f ff2 fs1 fc2 sc0 ls0 ws0">Glossary and Links........................................................................................................................................................72</div><div class="t m0 x1 h4 y80 ff2 fs1 fc2 sc0 ls0 ws0">SQL Grammar....................................................................................................................................................................73</div><div class="t m0 x3 h4 y81 ff2 fs1 fc2 sc0 ls0 ws0">Commands (Data Manipulation).....................................................................................................................................73</div><div class="t m0 x3 h4 y82 ff2 fs1 fc2 sc0 ls0 ws0">Commands (Data Definition)..........................................................................................................................................73</div><div class="t m0 x3 h4 y83 ff2 fs1 fc2 sc0 ls0 ws0">Commands (Other).......................................................................................................................................................74</div><div class="t m0 x3 h4 y84 ff2 fs1 fc2 sc0 ls0 ws0">Other Grammar.............................................................................................................................................................74</div><div class="t m0 x3 h4 y85 ff2 fs1 fc2 sc0 ls0 ws0">System Tables..............................................................................................................................................................75</div><div class="t m0 x4 h4 y86 ff2 fs1 fc2 sc0 ls0 ws0">SELECT...................................................................................................................................................................75</div><div class="t m0 x4 h4 y87 ff2 fs1 fc2 sc0 ls0 ws0">INSERT...................................................................................................................................................................76</div><div class="t m0 x4 h4 y88 ff2 fs1 fc2 sc0 ls0 ws0">UPDATE..................................................................................................................................................................76</div><div class="t m0 x4 h4 y89 ff2 fs1 fc2 sc0 ls0 ws0">DELETE...................................................................................................................................................................76</div><div class="t m0 x4 h4 y8a ff2 fs1 fc2 sc0 ls0 ws0">BACKUP..................................................................................................................................................................76</div><div class="t m0 x4 h4 y8b ff2 fs1 fc2 sc0 ls0 ws0">CALL.......................................................................................................................................................................76</div><div class="t m0 x4 h4 y8c ff2 fs1 fc2 sc0 ls0 ws0">EXPLAIN..................................................................................................................................................................77</div><div class="t m0 x4 h4 y8d ff2 fs1 fc2 sc0 ls0 ws0">MERGE....................................................................................................................................................................77</div><div class="t m0 x2 h4 y4 ff2 fs1 fc1 sc0 ls0 ws0">5 of 157</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>