<html> <head> <META http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Closing A Database</title> <link rel="stylesheet" type="text/css" href="../../../style.css"> </head> <body> <div class="CommonContent"> <div class="CommonContentArea"> <h1>Closing A Database</h1><script> //We attach this function to a browser object as a variable so that if multiple of these blocks are //present on the same page, then they will simply over-write eachother with the same function instead //of generating a naming collision. window.WikiCodeFormattingCopyToClipboard = function copyToClipboard(sID){ var sContent = document.getElementById(sID).innerText; if( window.clipboardData && clipboardData.setData ) { clipboardData.setData("Text", sContent); } else { alert("You must enable javascript access to your clipboard for this feature to work. Please referr to your browser documentation or Google search for instructions."); } } </script><p class="MsoNormal"><br><br>The following methods will close SQLite and db4o database accordingly:</p> <p class="MsoNormal">SQLite:</p> <p class="MsoNormal"><div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">SqlExample.java: <span class="fscMemberName">close</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81"><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color: #008080;">01</span><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Open_Text').style.display='inline';"/><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">/** */</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_0_44_Open_Text"><span style="color: #008000;">/**</span><span style="color: #008000;"> </span><span style="color: #008080;">02</span><span style="color: #008000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> * Close database connection </span><span style="color: #008080;">03</span><span style="color: #008000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> </span><span style="color: #008000;">*/</span></span><span style="color: #000000;"> </span><span style="color: #008080;">04</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">static</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> close() </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_76_273_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">05</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;">(_db </span><span style="color: #000000;">!=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_Close_169_81_98_267_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">long</span><span style="color: #000000;"> startTime </span><span style="color: #000000;">=</span><span style="color: #000000;"> System.currentTimeMillis(); </span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> _db.close(); </span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> logToConsole(startTime, </span><span style="color: #000000;">"</span><span style="color: #000000;">Database committed and closed: </span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">false</span><span style="color: #000000;">); </span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> _db </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">; </span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div><o:p> </o:p></p> <p class="MsoNormal">db4o:</p> <p class="MsoNormal"><div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">Db4oExample.java: <span class="fscMemberName">close</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86"><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color: #008080;">01</span><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Open_Text').style.display='inline';"/><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">/** */</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_0_44_Open_Text"><span style="color: #008000;">/**</span><span style="color: #008000;"> </span><span style="color: #008080;">02</span><span style="color: #008000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> * Close database connection </span><span style="color: #008080;">03</span><span style="color: #008000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> </span><span style="color: #008000;">*/</span></span><span style="color: #000000;"> </span><span style="color: #008080;">04</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">static</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> close() </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_76_294_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">05</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;">(_container </span><span style="color: #000000;">!=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_Close_330_86_105_288_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">long</span><span style="color: #000000;"> startTime </span><span style="color: #000000;">=</span><span style="color: #000000;"> System.currentTimeMillis(); </span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> _container.close(); </span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> logToConsole(startTime, </span><span style="color: #000000;">"</span><span style="color: #000000;">Database committed and closed: </span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">false</span><span style="color: #000000;">); </span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> _container </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">; </span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div> </div> </div> <div id="footer"> This revision (2) was last Modified 2007-11-26T19:05:28 by Tetyana. </div> </body> </html>