mirror of
https://github.com/ysoftdevs/DependencyCheck.git
synced 2026-01-19 10:07:12 +01:00
865 lines
110 KiB
HTML
865 lines
110 KiB
HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
|
|
<head><meta http-equiv="content-type" content="text/html; charset=UTF-8" />
|
|
<title>CveDB xref</title>
|
|
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
|
|
</head>
|
|
<body>
|
|
<div id="overview"><a href="../../../../../../apidocs/org/owasp/dependencycheck/data/nvdcve/CveDB.html">View Javadoc</a></div><pre>
|
|
<a class="jxr_linenumber" name="L1" href="#L1">1</a> <em class="jxr_comment">/*</em>
|
|
<a class="jxr_linenumber" name="L2" href="#L2">2</a> <em class="jxr_comment"> * This file is part of dependency-check-core.</em>
|
|
<a class="jxr_linenumber" name="L3" href="#L3">3</a> <em class="jxr_comment"> *</em>
|
|
<a class="jxr_linenumber" name="L4" href="#L4">4</a> <em class="jxr_comment"> * Licensed under the Apache License, Version 2.0 (the "License");</em>
|
|
<a class="jxr_linenumber" name="L5" href="#L5">5</a> <em class="jxr_comment"> * you may not use this file except in compliance with the License.</em>
|
|
<a class="jxr_linenumber" name="L6" href="#L6">6</a> <em class="jxr_comment"> * You may obtain a copy of the License at</em>
|
|
<a class="jxr_linenumber" name="L7" href="#L7">7</a> <em class="jxr_comment"> *</em>
|
|
<a class="jxr_linenumber" name="L8" href="#L8">8</a> <em class="jxr_comment"> * <a href="http://www.apache.org/licenses/LICENSE-2." target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.</a>0</em>
|
|
<a class="jxr_linenumber" name="L9" href="#L9">9</a> <em class="jxr_comment"> *</em>
|
|
<a class="jxr_linenumber" name="L10" href="#L10">10</a> <em class="jxr_comment"> * Unless required by applicable law or agreed to in writing, software</em>
|
|
<a class="jxr_linenumber" name="L11" href="#L11">11</a> <em class="jxr_comment"> * distributed under the License is distributed on an "AS IS" BASIS,</em>
|
|
<a class="jxr_linenumber" name="L12" href="#L12">12</a> <em class="jxr_comment"> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</em>
|
|
<a class="jxr_linenumber" name="L13" href="#L13">13</a> <em class="jxr_comment"> * See the License for the specific language governing permissions and</em>
|
|
<a class="jxr_linenumber" name="L14" href="#L14">14</a> <em class="jxr_comment"> * limitations under the License.</em>
|
|
<a class="jxr_linenumber" name="L15" href="#L15">15</a> <em class="jxr_comment"> *</em>
|
|
<a class="jxr_linenumber" name="L16" href="#L16">16</a> <em class="jxr_comment"> * Copyright (c) 2012 Jeremy Long. All Rights Reserved.</em>
|
|
<a class="jxr_linenumber" name="L17" href="#L17">17</a> <em class="jxr_comment"> */</em>
|
|
<a class="jxr_linenumber" name="L18" href="#L18">18</a> <strong class="jxr_keyword">package</strong> org.owasp.dependencycheck.data.nvdcve;
|
|
<a class="jxr_linenumber" name="L19" href="#L19">19</a>
|
|
<a class="jxr_linenumber" name="L20" href="#L20">20</a> <strong class="jxr_keyword">import</strong> java.io.IOException;
|
|
<a class="jxr_linenumber" name="L21" href="#L21">21</a> <strong class="jxr_keyword">import</strong> java.io.UnsupportedEncodingException;
|
|
<a class="jxr_linenumber" name="L22" href="#L22">22</a> <strong class="jxr_keyword">import</strong> java.sql.Connection;
|
|
<a class="jxr_linenumber" name="L23" href="#L23">23</a> <strong class="jxr_keyword">import</strong> java.sql.PreparedStatement;
|
|
<a class="jxr_linenumber" name="L24" href="#L24">24</a> <strong class="jxr_keyword">import</strong> java.sql.ResultSet;
|
|
<a class="jxr_linenumber" name="L25" href="#L25">25</a> <strong class="jxr_keyword">import</strong> java.sql.SQLException;
|
|
<a class="jxr_linenumber" name="L26" href="#L26">26</a> <strong class="jxr_keyword">import</strong> java.sql.Statement;
|
|
<a class="jxr_linenumber" name="L27" href="#L27">27</a> <strong class="jxr_keyword">import</strong> java.util.ArrayList;
|
|
<a class="jxr_linenumber" name="L28" href="#L28">28</a> <strong class="jxr_keyword">import</strong> java.util.HashMap;
|
|
<a class="jxr_linenumber" name="L29" href="#L29">29</a> <strong class="jxr_keyword">import</strong> java.util.HashSet;
|
|
<a class="jxr_linenumber" name="L30" href="#L30">30</a> <strong class="jxr_keyword">import</strong> java.util.List;
|
|
<a class="jxr_linenumber" name="L31" href="#L31">31</a> <strong class="jxr_keyword">import</strong> java.util.Locale;
|
|
<a class="jxr_linenumber" name="L32" href="#L32">32</a> <strong class="jxr_keyword">import</strong> java.util.Map;
|
|
<a class="jxr_linenumber" name="L33" href="#L33">33</a> <strong class="jxr_keyword">import</strong> java.util.Map.Entry;
|
|
<a class="jxr_linenumber" name="L34" href="#L34">34</a> <strong class="jxr_keyword">import</strong> java.util.MissingResourceException;
|
|
<a class="jxr_linenumber" name="L35" href="#L35">35</a> <strong class="jxr_keyword">import</strong> java.util.Properties;
|
|
<a class="jxr_linenumber" name="L36" href="#L36">36</a> <strong class="jxr_keyword">import</strong> java.util.ResourceBundle;
|
|
<a class="jxr_linenumber" name="L37" href="#L37">37</a> <strong class="jxr_keyword">import</strong> java.util.Set;
|
|
<a class="jxr_linenumber" name="L38" href="#L38">38</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.data.cwe.CweDB;
|
|
<a class="jxr_linenumber" name="L39" href="#L39">39</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.dependency.Reference;
|
|
<a class="jxr_linenumber" name="L40" href="#L40">40</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.dependency.Vulnerability;
|
|
<a class="jxr_linenumber" name="L41" href="#L41">41</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.dependency.VulnerableSoftware;
|
|
<a class="jxr_linenumber" name="L42" href="#L42">42</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.utils.DBUtils;
|
|
<a class="jxr_linenumber" name="L43" href="#L43">43</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.utils.DependencyVersion;
|
|
<a class="jxr_linenumber" name="L44" href="#L44">44</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.utils.DependencyVersionUtil;
|
|
<a class="jxr_linenumber" name="L45" href="#L45">45</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.utils.Pair;
|
|
<a class="jxr_linenumber" name="L46" href="#L46">46</a> <strong class="jxr_keyword">import</strong> org.owasp.dependencycheck.utils.Settings;
|
|
<a class="jxr_linenumber" name="L47" href="#L47">47</a> <strong class="jxr_keyword">import</strong> org.slf4j.Logger;
|
|
<a class="jxr_linenumber" name="L48" href="#L48">48</a> <strong class="jxr_keyword">import</strong> org.slf4j.LoggerFactory;
|
|
<a class="jxr_linenumber" name="L49" href="#L49">49</a>
|
|
<a class="jxr_linenumber" name="L50" href="#L50">50</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L51" href="#L51">51</a> <em class="jxr_javadoccomment"> * The database holding information about the NVD CVE data.</em>
|
|
<a class="jxr_linenumber" name="L52" href="#L52">52</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L53" href="#L53">53</a> <em class="jxr_javadoccomment"> * @author Jeremy Long</em>
|
|
<a class="jxr_linenumber" name="L54" href="#L54">54</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L55" href="#L55">55</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/CveDB.html">CveDB</a> {
|
|
<a class="jxr_linenumber" name="L56" href="#L56">56</a>
|
|
<a class="jxr_linenumber" name="L57" href="#L57">57</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L58" href="#L58">58</a> <em class="jxr_javadoccomment"> * The logger.</em>
|
|
<a class="jxr_linenumber" name="L59" href="#L59">59</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L60" href="#L60">60</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Logger LOGGER = LoggerFactory.getLogger(CveDB.<strong class="jxr_keyword">class</strong>);
|
|
<a class="jxr_linenumber" name="L61" href="#L61">61</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L62" href="#L62">62</a> <em class="jxr_javadoccomment"> * Database connection</em>
|
|
<a class="jxr_linenumber" name="L63" href="#L63">63</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L64" href="#L64">64</a> <strong class="jxr_keyword">private</strong> Connection conn;
|
|
<a class="jxr_linenumber" name="L65" href="#L65">65</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L66" href="#L66">66</a> <em class="jxr_javadoccomment"> * The bundle of statements used when accessing the database.</em>
|
|
<a class="jxr_linenumber" name="L67" href="#L67">67</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L68" href="#L68">68</a> <strong class="jxr_keyword">private</strong> ResourceBundle statementBundle = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L69" href="#L69">69</a>
|
|
<a class="jxr_linenumber" name="L70" href="#L70">70</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L71" href="#L71">71</a> <em class="jxr_javadoccomment"> * Creates a new CveDB object and opens the database connection. Note, the</em>
|
|
<a class="jxr_linenumber" name="L72" href="#L72">72</a> <em class="jxr_javadoccomment"> * connection must be closed by the caller by calling the close method.</em>
|
|
<a class="jxr_linenumber" name="L73" href="#L73">73</a> <em class="jxr_javadoccomment"> * ======= Does the underlying connection support batch operations?</em>
|
|
<a class="jxr_linenumber" name="L74" href="#L74">74</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L75" href="#L75">75</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">boolean</strong> batchSupported;
|
|
<a class="jxr_linenumber" name="L76" href="#L76">76</a>
|
|
<a class="jxr_linenumber" name="L77" href="#L77">77</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L78" href="#L78">78</a> <em class="jxr_javadoccomment"> * Creates a new CveDB object and opens the database connection. Note, the</em>
|
|
<a class="jxr_linenumber" name="L79" href="#L79">79</a> <em class="jxr_javadoccomment"> * connection must be closed by the caller by calling the close method.</em>
|
|
<a class="jxr_linenumber" name="L80" href="#L80">80</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L81" href="#L81">81</a> <em class="jxr_javadoccomment"> * @throws DatabaseException thrown if there is an exception opening the</em>
|
|
<a class="jxr_linenumber" name="L82" href="#L82">82</a> <em class="jxr_javadoccomment"> * database.</em>
|
|
<a class="jxr_linenumber" name="L83" href="#L83">83</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L84" href="#L84">84</a> <strong class="jxr_keyword">public</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/CveDB.html">CveDB</a>() <strong class="jxr_keyword">throws</strong> DatabaseException {
|
|
<a class="jxr_linenumber" name="L85" href="#L85">85</a> <strong class="jxr_keyword">super</strong>();
|
|
<a class="jxr_linenumber" name="L86" href="#L86">86</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L87" href="#L87">87</a> open();
|
|
<a class="jxr_linenumber" name="L88" href="#L88">88</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L89" href="#L89">89</a> <strong class="jxr_keyword">final</strong> String databaseProductName = conn.getMetaData().getDatabaseProductName();
|
|
<a class="jxr_linenumber" name="L90" href="#L90">90</a> LOGGER.debug(<span class="jxr_string">"Database dialect: {}"</span>, databaseProductName);
|
|
<a class="jxr_linenumber" name="L91" href="#L91">91</a> <strong class="jxr_keyword">final</strong> Locale dbDialect = <strong class="jxr_keyword">new</strong> Locale(databaseProductName);
|
|
<a class="jxr_linenumber" name="L92" href="#L92">92</a> statementBundle = ResourceBundle.getBundle(<span class="jxr_string">"data/dbStatements"</span>, dbDialect);
|
|
<a class="jxr_linenumber" name="L93" href="#L93">93</a> <strong class="jxr_keyword">if</strong> (<span class="jxr_string">"mysql"</span>.equalsIgnoreCase(databaseProductName)) {
|
|
<a class="jxr_linenumber" name="L94" href="#L94">94</a> batchSupported = false;
|
|
<a class="jxr_linenumber" name="L95" href="#L95">95</a> }
|
|
<a class="jxr_linenumber" name="L96" href="#L96">96</a> } <strong class="jxr_keyword">catch</strong> (SQLException se) {
|
|
<a class="jxr_linenumber" name="L97" href="#L97">97</a> LOGGER.warn(<span class="jxr_string">"Problem loading database specific dialect!"</span>, se);
|
|
<a class="jxr_linenumber" name="L98" href="#L98">98</a> statementBundle = ResourceBundle.getBundle(<span class="jxr_string">"data/dbStatements"</span>);
|
|
<a class="jxr_linenumber" name="L99" href="#L99">99</a> }
|
|
<a class="jxr_linenumber" name="L100" href="#L100">100</a> databaseProperties = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseProperties.html">DatabaseProperties</a>(<strong class="jxr_keyword">this</strong>);
|
|
<a class="jxr_linenumber" name="L101" href="#L101">101</a> } <strong class="jxr_keyword">catch</strong> (DatabaseException ex) {
|
|
<a class="jxr_linenumber" name="L102" href="#L102">102</a> <strong class="jxr_keyword">throw</strong> ex;
|
|
<a class="jxr_linenumber" name="L103" href="#L103">103</a> }
|
|
<a class="jxr_linenumber" name="L104" href="#L104">104</a> }
|
|
<a class="jxr_linenumber" name="L105" href="#L105">105</a>
|
|
<a class="jxr_linenumber" name="L106" href="#L106">106</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L107" href="#L107">107</a> <em class="jxr_javadoccomment"> * Returns the database connection.</em>
|
|
<a class="jxr_linenumber" name="L108" href="#L108">108</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L109" href="#L109">109</a> <em class="jxr_javadoccomment"> * @return the database connection</em>
|
|
<a class="jxr_linenumber" name="L110" href="#L110">110</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L111" href="#L111">111</a> <strong class="jxr_keyword">protected</strong> Connection getConnection() {
|
|
<a class="jxr_linenumber" name="L112" href="#L112">112</a> <strong class="jxr_keyword">return</strong> conn;
|
|
<a class="jxr_linenumber" name="L113" href="#L113">113</a> }
|
|
<a class="jxr_linenumber" name="L114" href="#L114">114</a>
|
|
<a class="jxr_linenumber" name="L115" href="#L115">115</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L116" href="#L116">116</a> <em class="jxr_javadoccomment"> * Opens the database connection. If the database does not exist, it will</em>
|
|
<a class="jxr_linenumber" name="L117" href="#L117">117</a> <em class="jxr_javadoccomment"> * create a new one.</em>
|
|
<a class="jxr_linenumber" name="L118" href="#L118">118</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L119" href="#L119">119</a> <em class="jxr_javadoccomment"> * @throws DatabaseException thrown if there is an error opening the</em>
|
|
<a class="jxr_linenumber" name="L120" href="#L120">120</a> <em class="jxr_javadoccomment"> * database connection</em>
|
|
<a class="jxr_linenumber" name="L121" href="#L121">121</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L122" href="#L122">122</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> open() <strong class="jxr_keyword">throws</strong> DatabaseException {
|
|
<a class="jxr_linenumber" name="L123" href="#L123">123</a> <strong class="jxr_keyword">if</strong> (!isOpen()) {
|
|
<a class="jxr_linenumber" name="L124" href="#L124">124</a> conn = ConnectionFactory.getConnection();
|
|
<a class="jxr_linenumber" name="L125" href="#L125">125</a> }
|
|
<a class="jxr_linenumber" name="L126" href="#L126">126</a> }
|
|
<a class="jxr_linenumber" name="L127" href="#L127">127</a>
|
|
<a class="jxr_linenumber" name="L128" href="#L128">128</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L129" href="#L129">129</a> <em class="jxr_javadoccomment"> * Closes the DB4O database. Close should be called on this object when it</em>
|
|
<a class="jxr_linenumber" name="L130" href="#L130">130</a> <em class="jxr_javadoccomment"> * is done being used.</em>
|
|
<a class="jxr_linenumber" name="L131" href="#L131">131</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L132" href="#L132">132</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> close() {
|
|
<a class="jxr_linenumber" name="L133" href="#L133">133</a> <strong class="jxr_keyword">if</strong> (conn != <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L134" href="#L134">134</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L135" href="#L135">135</a> conn.close();
|
|
<a class="jxr_linenumber" name="L136" href="#L136">136</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L137" href="#L137">137</a> LOGGER.error(<span class="jxr_string">"There was an error attempting to close the CveDB, see the log for more details."</span>);
|
|
<a class="jxr_linenumber" name="L138" href="#L138">138</a> LOGGER.debug(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L139" href="#L139">139</a> } <strong class="jxr_keyword">catch</strong> (Throwable ex) {
|
|
<a class="jxr_linenumber" name="L140" href="#L140">140</a> LOGGER.error(<span class="jxr_string">"There was an exception attempting to close the CveDB, see the log for more details."</span>);
|
|
<a class="jxr_linenumber" name="L141" href="#L141">141</a> LOGGER.debug(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L142" href="#L142">142</a> }
|
|
<a class="jxr_linenumber" name="L143" href="#L143">143</a> conn = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L144" href="#L144">144</a> }
|
|
<a class="jxr_linenumber" name="L145" href="#L145">145</a> }
|
|
<a class="jxr_linenumber" name="L146" href="#L146">146</a>
|
|
<a class="jxr_linenumber" name="L147" href="#L147">147</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L148" href="#L148">148</a> <em class="jxr_javadoccomment"> * Returns whether the database connection is open or closed.</em>
|
|
<a class="jxr_linenumber" name="L149" href="#L149">149</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L150" href="#L150">150</a> <em class="jxr_javadoccomment"> * @return whether the database connection is open or closed</em>
|
|
<a class="jxr_linenumber" name="L151" href="#L151">151</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L152" href="#L152">152</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">boolean</strong> isOpen() {
|
|
<a class="jxr_linenumber" name="L153" href="#L153">153</a> <strong class="jxr_keyword">return</strong> conn != <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L154" href="#L154">154</a> }
|
|
<a class="jxr_linenumber" name="L155" href="#L155">155</a>
|
|
<a class="jxr_linenumber" name="L156" href="#L156">156</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L157" href="#L157">157</a> <em class="jxr_javadoccomment"> * Commits all completed transactions.</em>
|
|
<a class="jxr_linenumber" name="L158" href="#L158">158</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L159" href="#L159">159</a> <em class="jxr_javadoccomment"> * @throws SQLException thrown if a SQL Exception occurs</em>
|
|
<a class="jxr_linenumber" name="L160" href="#L160">160</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L161" href="#L161">161</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> commit() <strong class="jxr_keyword">throws</strong> SQLException {
|
|
<a class="jxr_linenumber" name="L162" href="#L162">162</a> <em class="jxr_comment">//temporary remove this as autocommit is on.</em>
|
|
<a class="jxr_linenumber" name="L163" href="#L163">163</a> <em class="jxr_comment">//if (conn != null) {</em>
|
|
<a class="jxr_linenumber" name="L164" href="#L164">164</a> <em class="jxr_comment">// conn.commit();</em>
|
|
<a class="jxr_linenumber" name="L165" href="#L165">165</a> <em class="jxr_comment">//}</em>
|
|
<a class="jxr_linenumber" name="L166" href="#L166">166</a> }
|
|
<a class="jxr_linenumber" name="L167" href="#L167">167</a>
|
|
<a class="jxr_linenumber" name="L168" href="#L168">168</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L169" href="#L169">169</a> <em class="jxr_javadoccomment"> * Cleans up the object and ensures that "close" has been called.</em>
|
|
<a class="jxr_linenumber" name="L170" href="#L170">170</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L171" href="#L171">171</a> <em class="jxr_javadoccomment"> * @throws Throwable thrown if there is a problem</em>
|
|
<a class="jxr_linenumber" name="L172" href="#L172">172</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L173" href="#L173">173</a> @Override
|
|
<a class="jxr_linenumber" name="L174" href="#L174">174</a> @SuppressWarnings(<span class="jxr_string">"FinalizeDeclaration"</span>)
|
|
<a class="jxr_linenumber" name="L175" href="#L175">175</a> <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> finalize() <strong class="jxr_keyword">throws</strong> Throwable {
|
|
<a class="jxr_linenumber" name="L176" href="#L176">176</a> LOGGER.debug(<span class="jxr_string">"Entering finalize"</span>);
|
|
<a class="jxr_linenumber" name="L177" href="#L177">177</a> close();
|
|
<a class="jxr_linenumber" name="L178" href="#L178">178</a> <strong class="jxr_keyword">super</strong>.finalize();
|
|
<a class="jxr_linenumber" name="L179" href="#L179">179</a> }
|
|
<a class="jxr_linenumber" name="L180" href="#L180">180</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L181" href="#L181">181</a> <em class="jxr_javadoccomment"> * Database properties object containing the 'properties' from the database</em>
|
|
<a class="jxr_linenumber" name="L182" href="#L182">182</a> <em class="jxr_javadoccomment"> * table.</em>
|
|
<a class="jxr_linenumber" name="L183" href="#L183">183</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L184" href="#L184">184</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseProperties.html">DatabaseProperties</a> databaseProperties;
|
|
<a class="jxr_linenumber" name="L185" href="#L185">185</a>
|
|
<a class="jxr_linenumber" name="L186" href="#L186">186</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L187" href="#L187">187</a> <em class="jxr_javadoccomment"> * Get the value of databaseProperties.</em>
|
|
<a class="jxr_linenumber" name="L188" href="#L188">188</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L189" href="#L189">189</a> <em class="jxr_javadoccomment"> * @return the value of databaseProperties</em>
|
|
<a class="jxr_linenumber" name="L190" href="#L190">190</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L191" href="#L191">191</a> <strong class="jxr_keyword">public</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseProperties.html">DatabaseProperties</a> getDatabaseProperties() {
|
|
<a class="jxr_linenumber" name="L192" href="#L192">192</a> <strong class="jxr_keyword">return</strong> databaseProperties;
|
|
<a class="jxr_linenumber" name="L193" href="#L193">193</a> }
|
|
<a class="jxr_linenumber" name="L194" href="#L194">194</a>
|
|
<a class="jxr_linenumber" name="L195" href="#L195">195</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L196" href="#L196">196</a> <em class="jxr_javadoccomment"> * Searches the CPE entries in the database and retrieves all entries for a</em>
|
|
<a class="jxr_linenumber" name="L197" href="#L197">197</a> <em class="jxr_javadoccomment"> * given vendor and product combination. The returned list will include all</em>
|
|
<a class="jxr_linenumber" name="L198" href="#L198">198</a> <em class="jxr_javadoccomment"> * versions of the product that are registered in the NVD CVE data.</em>
|
|
<a class="jxr_linenumber" name="L199" href="#L199">199</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L200" href="#L200">200</a> <em class="jxr_javadoccomment"> * @param vendor the identified vendor name of the dependency being analyzed</em>
|
|
<a class="jxr_linenumber" name="L201" href="#L201">201</a> <em class="jxr_javadoccomment"> * @param product the identified name of the product of the dependency being</em>
|
|
<a class="jxr_linenumber" name="L202" href="#L202">202</a> <em class="jxr_javadoccomment"> * analyzed</em>
|
|
<a class="jxr_linenumber" name="L203" href="#L203">203</a> <em class="jxr_javadoccomment"> * @return a set of vulnerable software</em>
|
|
<a class="jxr_linenumber" name="L204" href="#L204">204</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L205" href="#L205">205</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> Set<VulnerableSoftware> getCPEs(String vendor, String product) {
|
|
<a class="jxr_linenumber" name="L206" href="#L206">206</a> <strong class="jxr_keyword">final</strong> Set<VulnerableSoftware> cpe = <strong class="jxr_keyword">new</strong> HashSet<VulnerableSoftware>();
|
|
<a class="jxr_linenumber" name="L207" href="#L207">207</a> ResultSet rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L208" href="#L208">208</a> PreparedStatement ps = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L209" href="#L209">209</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L210" href="#L210">210</a> ps = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_CPE_ENTRIES"</span>));
|
|
<a class="jxr_linenumber" name="L211" href="#L211">211</a> ps.setString(1, vendor);
|
|
<a class="jxr_linenumber" name="L212" href="#L212">212</a> ps.setString(2, product);
|
|
<a class="jxr_linenumber" name="L213" href="#L213">213</a> rs = ps.executeQuery();
|
|
<a class="jxr_linenumber" name="L214" href="#L214">214</a>
|
|
<a class="jxr_linenumber" name="L215" href="#L215">215</a> <strong class="jxr_keyword">while</strong> (rs.next()) {
|
|
<a class="jxr_linenumber" name="L216" href="#L216">216</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/VulnerableSoftware.html">VulnerableSoftware</a> vs = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/VulnerableSoftware.html">VulnerableSoftware</a>();
|
|
<a class="jxr_linenumber" name="L217" href="#L217">217</a> vs.setCpe(rs.getString(1));
|
|
<a class="jxr_linenumber" name="L218" href="#L218">218</a> cpe.add(vs);
|
|
<a class="jxr_linenumber" name="L219" href="#L219">219</a> }
|
|
<a class="jxr_linenumber" name="L220" href="#L220">220</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L221" href="#L221">221</a> LOGGER.error(<span class="jxr_string">"An unexpected SQL Exception occurred; please see the verbose log for more details."</span>);
|
|
<a class="jxr_linenumber" name="L222" href="#L222">222</a> LOGGER.debug(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L223" href="#L223">223</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L224" href="#L224">224</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L225" href="#L225">225</a> DBUtils.closeStatement(ps);
|
|
<a class="jxr_linenumber" name="L226" href="#L226">226</a> }
|
|
<a class="jxr_linenumber" name="L227" href="#L227">227</a> <strong class="jxr_keyword">return</strong> cpe;
|
|
<a class="jxr_linenumber" name="L228" href="#L228">228</a> }
|
|
<a class="jxr_linenumber" name="L229" href="#L229">229</a>
|
|
<a class="jxr_linenumber" name="L230" href="#L230">230</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L231" href="#L231">231</a> <em class="jxr_javadoccomment"> * Returns the entire list of vendor/product combinations.</em>
|
|
<a class="jxr_linenumber" name="L232" href="#L232">232</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L233" href="#L233">233</a> <em class="jxr_javadoccomment"> * @return the entire list of vendor/product combinations</em>
|
|
<a class="jxr_linenumber" name="L234" href="#L234">234</a> <em class="jxr_javadoccomment"> * @throws DatabaseException thrown when there is an error retrieving the</em>
|
|
<a class="jxr_linenumber" name="L235" href="#L235">235</a> <em class="jxr_javadoccomment"> * data from the DB</em>
|
|
<a class="jxr_linenumber" name="L236" href="#L236">236</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L237" href="#L237">237</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> Set<Pair<String, String>> getVendorProductList() <strong class="jxr_keyword">throws</strong> DatabaseException {
|
|
<a class="jxr_linenumber" name="L238" href="#L238">238</a> <strong class="jxr_keyword">final</strong> Set<Pair<String, String>> data = <strong class="jxr_keyword">new</strong> HashSet<Pair<String, String>>();
|
|
<a class="jxr_linenumber" name="L239" href="#L239">239</a> ResultSet rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L240" href="#L240">240</a> PreparedStatement ps = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L241" href="#L241">241</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L242" href="#L242">242</a> ps = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_VENDOR_PRODUCT_LIST"</span>));
|
|
<a class="jxr_linenumber" name="L243" href="#L243">243</a> rs = ps.executeQuery();
|
|
<a class="jxr_linenumber" name="L244" href="#L244">244</a> <strong class="jxr_keyword">while</strong> (rs.next()) {
|
|
<a class="jxr_linenumber" name="L245" href="#L245">245</a> data.add(<strong class="jxr_keyword">new</strong> Pair<String, String>(rs.getString(1), rs.getString(2)));
|
|
<a class="jxr_linenumber" name="L246" href="#L246">246</a> }
|
|
<a class="jxr_linenumber" name="L247" href="#L247">247</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L248" href="#L248">248</a> <strong class="jxr_keyword">final</strong> String msg = <span class="jxr_string">"An unexpected SQL Exception occurred; please see the verbose log for more details."</span>;
|
|
<a class="jxr_linenumber" name="L249" href="#L249">249</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseException.html">DatabaseException</a>(msg, ex);
|
|
<a class="jxr_linenumber" name="L250" href="#L250">250</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L251" href="#L251">251</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L252" href="#L252">252</a> DBUtils.closeStatement(ps);
|
|
<a class="jxr_linenumber" name="L253" href="#L253">253</a> }
|
|
<a class="jxr_linenumber" name="L254" href="#L254">254</a> <strong class="jxr_keyword">return</strong> data;
|
|
<a class="jxr_linenumber" name="L255" href="#L255">255</a> }
|
|
<a class="jxr_linenumber" name="L256" href="#L256">256</a>
|
|
<a class="jxr_linenumber" name="L257" href="#L257">257</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L258" href="#L258">258</a> <em class="jxr_javadoccomment"> * Returns a set of properties.</em>
|
|
<a class="jxr_linenumber" name="L259" href="#L259">259</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L260" href="#L260">260</a> <em class="jxr_javadoccomment"> * @return the properties from the database</em>
|
|
<a class="jxr_linenumber" name="L261" href="#L261">261</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L262" href="#L262">262</a> <strong class="jxr_keyword">synchronized</strong> Properties getProperties() {
|
|
<a class="jxr_linenumber" name="L263" href="#L263">263</a> <strong class="jxr_keyword">final</strong> Properties prop = <strong class="jxr_keyword">new</strong> Properties();
|
|
<a class="jxr_linenumber" name="L264" href="#L264">264</a> PreparedStatement ps = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L265" href="#L265">265</a> ResultSet rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L266" href="#L266">266</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L267" href="#L267">267</a> ps = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_PROPERTIES"</span>));
|
|
<a class="jxr_linenumber" name="L268" href="#L268">268</a> rs = ps.executeQuery();
|
|
<a class="jxr_linenumber" name="L269" href="#L269">269</a> <strong class="jxr_keyword">while</strong> (rs.next()) {
|
|
<a class="jxr_linenumber" name="L270" href="#L270">270</a> prop.setProperty(rs.getString(1), rs.getString(2));
|
|
<a class="jxr_linenumber" name="L271" href="#L271">271</a> }
|
|
<a class="jxr_linenumber" name="L272" href="#L272">272</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L273" href="#L273">273</a> LOGGER.error(<span class="jxr_string">"An unexpected SQL Exception occurred; please see the verbose log for more details."</span>);
|
|
<a class="jxr_linenumber" name="L274" href="#L274">274</a> LOGGER.debug(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L275" href="#L275">275</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L276" href="#L276">276</a> DBUtils.closeStatement(ps);
|
|
<a class="jxr_linenumber" name="L277" href="#L277">277</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L278" href="#L278">278</a> }
|
|
<a class="jxr_linenumber" name="L279" href="#L279">279</a> <strong class="jxr_keyword">return</strong> prop;
|
|
<a class="jxr_linenumber" name="L280" href="#L280">280</a> }
|
|
<a class="jxr_linenumber" name="L281" href="#L281">281</a>
|
|
<a class="jxr_linenumber" name="L282" href="#L282">282</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L283" href="#L283">283</a> <em class="jxr_javadoccomment"> * Saves a property to the database.</em>
|
|
<a class="jxr_linenumber" name="L284" href="#L284">284</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L285" href="#L285">285</a> <em class="jxr_javadoccomment"> * @param key the property key</em>
|
|
<a class="jxr_linenumber" name="L286" href="#L286">286</a> <em class="jxr_javadoccomment"> * @param value the property value</em>
|
|
<a class="jxr_linenumber" name="L287" href="#L287">287</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L288" href="#L288">288</a> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> saveProperty(String key, String value) {
|
|
<a class="jxr_linenumber" name="L289" href="#L289">289</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L290" href="#L290">290</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L291" href="#L291">291</a> <strong class="jxr_keyword">final</strong> PreparedStatement mergeProperty = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"MERGE_PROPERTY"</span>));
|
|
<a class="jxr_linenumber" name="L292" href="#L292">292</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L293" href="#L293">293</a> mergeProperty.setString(1, key);
|
|
<a class="jxr_linenumber" name="L294" href="#L294">294</a> mergeProperty.setString(2, value);
|
|
<a class="jxr_linenumber" name="L295" href="#L295">295</a> mergeProperty.executeUpdate();
|
|
<a class="jxr_linenumber" name="L296" href="#L296">296</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L297" href="#L297">297</a> DBUtils.closeStatement(mergeProperty);
|
|
<a class="jxr_linenumber" name="L298" href="#L298">298</a> }
|
|
<a class="jxr_linenumber" name="L299" href="#L299">299</a> } <strong class="jxr_keyword">catch</strong> (MissingResourceException mre) {
|
|
<a class="jxr_linenumber" name="L300" href="#L300">300</a> <em class="jxr_comment">// No Merge statement, so doing an Update/Insert...</em>
|
|
<a class="jxr_linenumber" name="L301" href="#L301">301</a> PreparedStatement updateProperty = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L302" href="#L302">302</a> PreparedStatement insertProperty = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L303" href="#L303">303</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L304" href="#L304">304</a> updateProperty = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"UPDATE_PROPERTY"</span>));
|
|
<a class="jxr_linenumber" name="L305" href="#L305">305</a> updateProperty.setString(1, value);
|
|
<a class="jxr_linenumber" name="L306" href="#L306">306</a> updateProperty.setString(2, key);
|
|
<a class="jxr_linenumber" name="L307" href="#L307">307</a> <strong class="jxr_keyword">if</strong> (updateProperty.executeUpdate() == 0) {
|
|
<a class="jxr_linenumber" name="L308" href="#L308">308</a> insertProperty = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"INSERT_PROPERTY"</span>));
|
|
<a class="jxr_linenumber" name="L309" href="#L309">309</a> insertProperty.setString(1, key);
|
|
<a class="jxr_linenumber" name="L310" href="#L310">310</a> insertProperty.setString(2, value);
|
|
<a class="jxr_linenumber" name="L311" href="#L311">311</a> insertProperty.executeUpdate();
|
|
<a class="jxr_linenumber" name="L312" href="#L312">312</a> }
|
|
<a class="jxr_linenumber" name="L313" href="#L313">313</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L314" href="#L314">314</a> DBUtils.closeStatement(updateProperty);
|
|
<a class="jxr_linenumber" name="L315" href="#L315">315</a> DBUtils.closeStatement(insertProperty);
|
|
<a class="jxr_linenumber" name="L316" href="#L316">316</a> }
|
|
<a class="jxr_linenumber" name="L317" href="#L317">317</a> }
|
|
<a class="jxr_linenumber" name="L318" href="#L318">318</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L319" href="#L319">319</a> LOGGER.warn(<span class="jxr_string">"Unable to save property '{}' with a value of '{}' to the database"</span>, key, value);
|
|
<a class="jxr_linenumber" name="L320" href="#L320">320</a> LOGGER.debug(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L321" href="#L321">321</a> }
|
|
<a class="jxr_linenumber" name="L322" href="#L322">322</a> }
|
|
<a class="jxr_linenumber" name="L323" href="#L323">323</a>
|
|
<a class="jxr_linenumber" name="L324" href="#L324">324</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L325" href="#L325">325</a> <em class="jxr_javadoccomment"> * Retrieves the vulnerabilities associated with the specified CPE.</em>
|
|
<a class="jxr_linenumber" name="L326" href="#L326">326</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L327" href="#L327">327</a> <em class="jxr_javadoccomment"> * @param cpeStr the CPE name</em>
|
|
<a class="jxr_linenumber" name="L328" href="#L328">328</a> <em class="jxr_javadoccomment"> * @return a list of Vulnerabilities</em>
|
|
<a class="jxr_linenumber" name="L329" href="#L329">329</a> <em class="jxr_javadoccomment"> * @throws DatabaseException thrown if there is an exception retrieving data</em>
|
|
<a class="jxr_linenumber" name="L330" href="#L330">330</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L331" href="#L331">331</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> List<Vulnerability> getVulnerabilities(String cpeStr) <strong class="jxr_keyword">throws</strong> DatabaseException {
|
|
<a class="jxr_linenumber" name="L332" href="#L332">332</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/VulnerableSoftware.html">VulnerableSoftware</a> cpe = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/VulnerableSoftware.html">VulnerableSoftware</a>();
|
|
<a class="jxr_linenumber" name="L333" href="#L333">333</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L334" href="#L334">334</a> cpe.parseName(cpeStr);
|
|
<a class="jxr_linenumber" name="L335" href="#L335">335</a> } <strong class="jxr_keyword">catch</strong> (UnsupportedEncodingException ex) {
|
|
<a class="jxr_linenumber" name="L336" href="#L336">336</a> LOGGER.trace(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L337" href="#L337">337</a> }
|
|
<a class="jxr_linenumber" name="L338" href="#L338">338</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> detectedVersion = parseDependencyVersion(cpe);
|
|
<a class="jxr_linenumber" name="L339" href="#L339">339</a> <strong class="jxr_keyword">final</strong> List<Vulnerability> vulnerabilities = <strong class="jxr_keyword">new</strong> ArrayList<Vulnerability>();
|
|
<a class="jxr_linenumber" name="L340" href="#L340">340</a>
|
|
<a class="jxr_linenumber" name="L341" href="#L341">341</a> PreparedStatement ps = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L342" href="#L342">342</a> ResultSet rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L343" href="#L343">343</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L344" href="#L344">344</a> ps = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_CVE_FROM_SOFTWARE"</span>));
|
|
<a class="jxr_linenumber" name="L345" href="#L345">345</a> ps.setString(1, cpe.getVendor());
|
|
<a class="jxr_linenumber" name="L346" href="#L346">346</a> ps.setString(2, cpe.getProduct());
|
|
<a class="jxr_linenumber" name="L347" href="#L347">347</a> rs = ps.executeQuery();
|
|
<a class="jxr_linenumber" name="L348" href="#L348">348</a> String currentCVE = <span class="jxr_string">""</span>;
|
|
<a class="jxr_linenumber" name="L349" href="#L349">349</a>
|
|
<a class="jxr_linenumber" name="L350" href="#L350">350</a> <strong class="jxr_keyword">final</strong> Map<String, Boolean> vulnSoftware = <strong class="jxr_keyword">new</strong> HashMap<String, Boolean>();
|
|
<a class="jxr_linenumber" name="L351" href="#L351">351</a> <strong class="jxr_keyword">while</strong> (rs.next()) {
|
|
<a class="jxr_linenumber" name="L352" href="#L352">352</a> <strong class="jxr_keyword">final</strong> String cveId = rs.getString(1);
|
|
<a class="jxr_linenumber" name="L353" href="#L353">353</a> <strong class="jxr_keyword">if</strong> (!currentCVE.equals(cveId)) { <em class="jxr_comment">//check for match and add</em>
|
|
<a class="jxr_linenumber" name="L354" href="#L354">354</a> <strong class="jxr_keyword">final</strong> Entry<String, Boolean> matchedCPE = getMatchingSoftware(vulnSoftware, cpe.getVendor(), cpe.getProduct(), detectedVersion);
|
|
<a class="jxr_linenumber" name="L355" href="#L355">355</a> <strong class="jxr_keyword">if</strong> (matchedCPE != <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L356" href="#L356">356</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/Vulnerability.html">Vulnerability</a> v = getVulnerability(currentCVE);
|
|
<a class="jxr_linenumber" name="L357" href="#L357">357</a> v.setMatchedCPE(matchedCPE.getKey(), matchedCPE.getValue() ? <span class="jxr_string">"Y"</span> : <strong class="jxr_keyword">null</strong>);
|
|
<a class="jxr_linenumber" name="L358" href="#L358">358</a> vulnerabilities.add(v);
|
|
<a class="jxr_linenumber" name="L359" href="#L359">359</a> }
|
|
<a class="jxr_linenumber" name="L360" href="#L360">360</a> vulnSoftware.clear();
|
|
<a class="jxr_linenumber" name="L361" href="#L361">361</a> currentCVE = cveId;
|
|
<a class="jxr_linenumber" name="L362" href="#L362">362</a> }
|
|
<a class="jxr_linenumber" name="L363" href="#L363">363</a>
|
|
<a class="jxr_linenumber" name="L364" href="#L364">364</a> <strong class="jxr_keyword">final</strong> String cpeId = rs.getString(2);
|
|
<a class="jxr_linenumber" name="L365" href="#L365">365</a> <strong class="jxr_keyword">final</strong> String previous = rs.getString(3);
|
|
<a class="jxr_linenumber" name="L366" href="#L366">366</a> <strong class="jxr_keyword">final</strong> Boolean p = previous != <strong class="jxr_keyword">null</strong> && !previous.isEmpty();
|
|
<a class="jxr_linenumber" name="L367" href="#L367">367</a> vulnSoftware.put(cpeId, p);
|
|
<a class="jxr_linenumber" name="L368" href="#L368">368</a> }
|
|
<a class="jxr_linenumber" name="L369" href="#L369">369</a> <em class="jxr_comment">//remember to process the last set of CVE/CPE entries</em>
|
|
<a class="jxr_linenumber" name="L370" href="#L370">370</a> <strong class="jxr_keyword">final</strong> Entry<String, Boolean> matchedCPE = getMatchingSoftware(vulnSoftware, cpe.getVendor(), cpe.getProduct(), detectedVersion);
|
|
<a class="jxr_linenumber" name="L371" href="#L371">371</a> <strong class="jxr_keyword">if</strong> (matchedCPE != <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L372" href="#L372">372</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/Vulnerability.html">Vulnerability</a> v = getVulnerability(currentCVE);
|
|
<a class="jxr_linenumber" name="L373" href="#L373">373</a> v.setMatchedCPE(matchedCPE.getKey(), matchedCPE.getValue() ? <span class="jxr_string">"Y"</span> : <strong class="jxr_keyword">null</strong>);
|
|
<a class="jxr_linenumber" name="L374" href="#L374">374</a> vulnerabilities.add(v);
|
|
<a class="jxr_linenumber" name="L375" href="#L375">375</a> }
|
|
<a class="jxr_linenumber" name="L376" href="#L376">376</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L377" href="#L377">377</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseException.html">DatabaseException</a>(<span class="jxr_string">"Exception retrieving vulnerability for "</span> + cpeStr, ex);
|
|
<a class="jxr_linenumber" name="L378" href="#L378">378</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L379" href="#L379">379</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L380" href="#L380">380</a> DBUtils.closeStatement(ps);
|
|
<a class="jxr_linenumber" name="L381" href="#L381">381</a> }
|
|
<a class="jxr_linenumber" name="L382" href="#L382">382</a> <strong class="jxr_keyword">return</strong> vulnerabilities;
|
|
<a class="jxr_linenumber" name="L383" href="#L383">383</a> }
|
|
<a class="jxr_linenumber" name="L384" href="#L384">384</a>
|
|
<a class="jxr_linenumber" name="L385" href="#L385">385</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L386" href="#L386">386</a> <em class="jxr_javadoccomment"> * Gets a vulnerability for the provided CVE.</em>
|
|
<a class="jxr_linenumber" name="L387" href="#L387">387</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L388" href="#L388">388</a> <em class="jxr_javadoccomment"> * @param cve the CVE to lookup</em>
|
|
<a class="jxr_linenumber" name="L389" href="#L389">389</a> <em class="jxr_javadoccomment"> * @return a vulnerability object</em>
|
|
<a class="jxr_linenumber" name="L390" href="#L390">390</a> <em class="jxr_javadoccomment"> * @throws DatabaseException if an exception occurs</em>
|
|
<a class="jxr_linenumber" name="L391" href="#L391">391</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L392" href="#L392">392</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/Vulnerability.html">Vulnerability</a> getVulnerability(String cve) <strong class="jxr_keyword">throws</strong> DatabaseException {
|
|
<a class="jxr_linenumber" name="L393" href="#L393">393</a> PreparedStatement psV = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L394" href="#L394">394</a> PreparedStatement psR = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L395" href="#L395">395</a> PreparedStatement psS = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L396" href="#L396">396</a> ResultSet rsV = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L397" href="#L397">397</a> ResultSet rsR = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L398" href="#L398">398</a> ResultSet rsS = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L399" href="#L399">399</a> <a href="../../../../../org/owasp/dependencycheck/dependency/Vulnerability.html">Vulnerability</a> vuln = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L400" href="#L400">400</a>
|
|
<a class="jxr_linenumber" name="L401" href="#L401">401</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L402" href="#L402">402</a> psV = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_VULNERABILITY"</span>));
|
|
<a class="jxr_linenumber" name="L403" href="#L403">403</a> psV.setString(1, cve);
|
|
<a class="jxr_linenumber" name="L404" href="#L404">404</a> rsV = psV.executeQuery();
|
|
<a class="jxr_linenumber" name="L405" href="#L405">405</a> <strong class="jxr_keyword">if</strong> (rsV.next()) {
|
|
<a class="jxr_linenumber" name="L406" href="#L406">406</a> vuln = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/Vulnerability.html">Vulnerability</a>();
|
|
<a class="jxr_linenumber" name="L407" href="#L407">407</a> vuln.setName(cve);
|
|
<a class="jxr_linenumber" name="L408" href="#L408">408</a> vuln.setDescription(rsV.getString(2));
|
|
<a class="jxr_linenumber" name="L409" href="#L409">409</a> String cwe = rsV.getString(3);
|
|
<a class="jxr_linenumber" name="L410" href="#L410">410</a> <strong class="jxr_keyword">if</strong> (cwe != <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L411" href="#L411">411</a> <strong class="jxr_keyword">final</strong> String name = CweDB.getCweName(cwe);
|
|
<a class="jxr_linenumber" name="L412" href="#L412">412</a> <strong class="jxr_keyword">if</strong> (name != <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L413" href="#L413">413</a> cwe += ' ' + name;
|
|
<a class="jxr_linenumber" name="L414" href="#L414">414</a> }
|
|
<a class="jxr_linenumber" name="L415" href="#L415">415</a> }
|
|
<a class="jxr_linenumber" name="L416" href="#L416">416</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> cveId = rsV.getInt(1);
|
|
<a class="jxr_linenumber" name="L417" href="#L417">417</a> vuln.setCwe(cwe);
|
|
<a class="jxr_linenumber" name="L418" href="#L418">418</a> vuln.setCvssScore(rsV.getFloat(4));
|
|
<a class="jxr_linenumber" name="L419" href="#L419">419</a> vuln.setCvssAccessVector(rsV.getString(5));
|
|
<a class="jxr_linenumber" name="L420" href="#L420">420</a> vuln.setCvssAccessComplexity(rsV.getString(6));
|
|
<a class="jxr_linenumber" name="L421" href="#L421">421</a> vuln.setCvssAuthentication(rsV.getString(7));
|
|
<a class="jxr_linenumber" name="L422" href="#L422">422</a> vuln.setCvssConfidentialityImpact(rsV.getString(8));
|
|
<a class="jxr_linenumber" name="L423" href="#L423">423</a> vuln.setCvssIntegrityImpact(rsV.getString(9));
|
|
<a class="jxr_linenumber" name="L424" href="#L424">424</a> vuln.setCvssAvailabilityImpact(rsV.getString(10));
|
|
<a class="jxr_linenumber" name="L425" href="#L425">425</a>
|
|
<a class="jxr_linenumber" name="L426" href="#L426">426</a> psR = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_REFERENCES"</span>));
|
|
<a class="jxr_linenumber" name="L427" href="#L427">427</a> psR.setInt(1, cveId);
|
|
<a class="jxr_linenumber" name="L428" href="#L428">428</a> rsR = psR.executeQuery();
|
|
<a class="jxr_linenumber" name="L429" href="#L429">429</a> <strong class="jxr_keyword">while</strong> (rsR.next()) {
|
|
<a class="jxr_linenumber" name="L430" href="#L430">430</a> vuln.addReference(rsR.getString(1), rsR.getString(2), rsR.getString(3));
|
|
<a class="jxr_linenumber" name="L431" href="#L431">431</a> }
|
|
<a class="jxr_linenumber" name="L432" href="#L432">432</a> psS = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_SOFTWARE"</span>));
|
|
<a class="jxr_linenumber" name="L433" href="#L433">433</a> psS.setInt(1, cveId);
|
|
<a class="jxr_linenumber" name="L434" href="#L434">434</a> rsS = psS.executeQuery();
|
|
<a class="jxr_linenumber" name="L435" href="#L435">435</a> <strong class="jxr_keyword">while</strong> (rsS.next()) {
|
|
<a class="jxr_linenumber" name="L436" href="#L436">436</a> <strong class="jxr_keyword">final</strong> String cpe = rsS.getString(1);
|
|
<a class="jxr_linenumber" name="L437" href="#L437">437</a> <strong class="jxr_keyword">final</strong> String prevVersion = rsS.getString(2);
|
|
<a class="jxr_linenumber" name="L438" href="#L438">438</a> <strong class="jxr_keyword">if</strong> (prevVersion == <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L439" href="#L439">439</a> vuln.addVulnerableSoftware(cpe);
|
|
<a class="jxr_linenumber" name="L440" href="#L440">440</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L441" href="#L441">441</a> vuln.addVulnerableSoftware(cpe, prevVersion);
|
|
<a class="jxr_linenumber" name="L442" href="#L442">442</a> }
|
|
<a class="jxr_linenumber" name="L443" href="#L443">443</a> }
|
|
<a class="jxr_linenumber" name="L444" href="#L444">444</a> }
|
|
<a class="jxr_linenumber" name="L445" href="#L445">445</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L446" href="#L446">446</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseException.html">DatabaseException</a>(<span class="jxr_string">"Error retrieving "</span> + cve, ex);
|
|
<a class="jxr_linenumber" name="L447" href="#L447">447</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L448" href="#L448">448</a> DBUtils.closeResultSet(rsV);
|
|
<a class="jxr_linenumber" name="L449" href="#L449">449</a> DBUtils.closeResultSet(rsR);
|
|
<a class="jxr_linenumber" name="L450" href="#L450">450</a> DBUtils.closeResultSet(rsS);
|
|
<a class="jxr_linenumber" name="L451" href="#L451">451</a> DBUtils.closeStatement(psV);
|
|
<a class="jxr_linenumber" name="L452" href="#L452">452</a> DBUtils.closeStatement(psR);
|
|
<a class="jxr_linenumber" name="L453" href="#L453">453</a> DBUtils.closeStatement(psS);
|
|
<a class="jxr_linenumber" name="L454" href="#L454">454</a> }
|
|
<a class="jxr_linenumber" name="L455" href="#L455">455</a> <strong class="jxr_keyword">return</strong> vuln;
|
|
<a class="jxr_linenumber" name="L456" href="#L456">456</a> }
|
|
<a class="jxr_linenumber" name="L457" href="#L457">457</a>
|
|
<a class="jxr_linenumber" name="L458" href="#L458">458</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L459" href="#L459">459</a> <em class="jxr_javadoccomment"> * Updates the vulnerability within the database. If the vulnerability does</em>
|
|
<a class="jxr_linenumber" name="L460" href="#L460">460</a> <em class="jxr_javadoccomment"> * not exist it will be added.</em>
|
|
<a class="jxr_linenumber" name="L461" href="#L461">461</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L462" href="#L462">462</a> <em class="jxr_javadoccomment"> * @param vuln the vulnerability to add to the database</em>
|
|
<a class="jxr_linenumber" name="L463" href="#L463">463</a> <em class="jxr_javadoccomment"> * @throws DatabaseException is thrown if the database</em>
|
|
<a class="jxr_linenumber" name="L464" href="#L464">464</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L465" href="#L465">465</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> updateVulnerability(<a href="../../../../../org/owasp/dependencycheck/dependency/Vulnerability.html">Vulnerability</a> vuln) <strong class="jxr_keyword">throws</strong> DatabaseException {
|
|
<a class="jxr_linenumber" name="L466" href="#L466">466</a> PreparedStatement selectVulnerabilityId = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L467" href="#L467">467</a> PreparedStatement deleteVulnerability = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L468" href="#L468">468</a> PreparedStatement deleteReferences = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L469" href="#L469">469</a> PreparedStatement deleteSoftware = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L470" href="#L470">470</a> PreparedStatement updateVulnerability = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L471" href="#L471">471</a> PreparedStatement insertVulnerability = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L472" href="#L472">472</a> PreparedStatement insertReference = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L473" href="#L473">473</a> PreparedStatement selectCpeId = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L474" href="#L474">474</a> PreparedStatement insertCpe = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L475" href="#L475">475</a> PreparedStatement insertSoftware = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L476" href="#L476">476</a>
|
|
<a class="jxr_linenumber" name="L477" href="#L477">477</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L478" href="#L478">478</a> selectVulnerabilityId = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_VULNERABILITY_ID"</span>));
|
|
<a class="jxr_linenumber" name="L479" href="#L479">479</a> deleteVulnerability = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"DELETE_VULNERABILITY"</span>));
|
|
<a class="jxr_linenumber" name="L480" href="#L480">480</a> deleteReferences = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"DELETE_REFERENCE"</span>));
|
|
<a class="jxr_linenumber" name="L481" href="#L481">481</a> deleteSoftware = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"DELETE_SOFTWARE"</span>));
|
|
<a class="jxr_linenumber" name="L482" href="#L482">482</a> updateVulnerability = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"UPDATE_VULNERABILITY"</span>));
|
|
<a class="jxr_linenumber" name="L483" href="#L483">483</a> <strong class="jxr_keyword">final</strong> String[] ids = {<span class="jxr_string">"id"</span>};
|
|
<a class="jxr_linenumber" name="L484" href="#L484">484</a> insertVulnerability = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"INSERT_VULNERABILITY"</span>),
|
|
<a class="jxr_linenumber" name="L485" href="#L485">485</a> <em class="jxr_comment">//Statement.RETURN_GENERATED_KEYS);</em>
|
|
<a class="jxr_linenumber" name="L486" href="#L486">486</a> ids);
|
|
<a class="jxr_linenumber" name="L487" href="#L487">487</a> insertReference = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"INSERT_REFERENCE"</span>));
|
|
<a class="jxr_linenumber" name="L488" href="#L488">488</a> selectCpeId = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"SELECT_CPE_ID"</span>));
|
|
<a class="jxr_linenumber" name="L489" href="#L489">489</a> insertCpe = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"INSERT_CPE"</span>),
|
|
<a class="jxr_linenumber" name="L490" href="#L490">490</a> <em class="jxr_comment">//Statement.RETURN_GENERATED_KEYS);</em>
|
|
<a class="jxr_linenumber" name="L491" href="#L491">491</a> ids);
|
|
<a class="jxr_linenumber" name="L492" href="#L492">492</a> insertSoftware = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"INSERT_SOFTWARE"</span>));
|
|
<a class="jxr_linenumber" name="L493" href="#L493">493</a> <strong class="jxr_keyword">int</strong> vulnerabilityId = 0;
|
|
<a class="jxr_linenumber" name="L494" href="#L494">494</a> selectVulnerabilityId.setString(1, vuln.getName());
|
|
<a class="jxr_linenumber" name="L495" href="#L495">495</a> ResultSet rs = selectVulnerabilityId.executeQuery();
|
|
<a class="jxr_linenumber" name="L496" href="#L496">496</a> <strong class="jxr_keyword">if</strong> (rs.next()) {
|
|
<a class="jxr_linenumber" name="L497" href="#L497">497</a> vulnerabilityId = rs.getInt(1);
|
|
<a class="jxr_linenumber" name="L498" href="#L498">498</a> <em class="jxr_comment">// first delete any existing vulnerability info. We don't know what was updated. yes, slower but atm easier.</em>
|
|
<a class="jxr_linenumber" name="L499" href="#L499">499</a> deleteReferences.setInt(1, vulnerabilityId);
|
|
<a class="jxr_linenumber" name="L500" href="#L500">500</a> deleteReferences.execute();
|
|
<a class="jxr_linenumber" name="L501" href="#L501">501</a> deleteSoftware.setInt(1, vulnerabilityId);
|
|
<a class="jxr_linenumber" name="L502" href="#L502">502</a> deleteSoftware.execute();
|
|
<a class="jxr_linenumber" name="L503" href="#L503">503</a> }
|
|
<a class="jxr_linenumber" name="L504" href="#L504">504</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L505" href="#L505">505</a> rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L506" href="#L506">506</a>
|
|
<a class="jxr_linenumber" name="L507" href="#L507">507</a> <strong class="jxr_keyword">if</strong> (vulnerabilityId != 0) {
|
|
<a class="jxr_linenumber" name="L508" href="#L508">508</a> <strong class="jxr_keyword">if</strong> (vuln.getDescription().contains(<span class="jxr_string">"** REJECT **"</span>)) {
|
|
<a class="jxr_linenumber" name="L509" href="#L509">509</a> deleteVulnerability.setInt(1, vulnerabilityId);
|
|
<a class="jxr_linenumber" name="L510" href="#L510">510</a> deleteVulnerability.executeUpdate();
|
|
<a class="jxr_linenumber" name="L511" href="#L511">511</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L512" href="#L512">512</a> updateVulnerability.setString(1, vuln.getDescription());
|
|
<a class="jxr_linenumber" name="L513" href="#L513">513</a> updateVulnerability.setString(2, vuln.getCwe());
|
|
<a class="jxr_linenumber" name="L514" href="#L514">514</a> updateVulnerability.setFloat(3, vuln.getCvssScore());
|
|
<a class="jxr_linenumber" name="L515" href="#L515">515</a> updateVulnerability.setString(4, vuln.getCvssAccessVector());
|
|
<a class="jxr_linenumber" name="L516" href="#L516">516</a> updateVulnerability.setString(5, vuln.getCvssAccessComplexity());
|
|
<a class="jxr_linenumber" name="L517" href="#L517">517</a> updateVulnerability.setString(6, vuln.getCvssAuthentication());
|
|
<a class="jxr_linenumber" name="L518" href="#L518">518</a> updateVulnerability.setString(7, vuln.getCvssConfidentialityImpact());
|
|
<a class="jxr_linenumber" name="L519" href="#L519">519</a> updateVulnerability.setString(8, vuln.getCvssIntegrityImpact());
|
|
<a class="jxr_linenumber" name="L520" href="#L520">520</a> updateVulnerability.setString(9, vuln.getCvssAvailabilityImpact());
|
|
<a class="jxr_linenumber" name="L521" href="#L521">521</a> updateVulnerability.setInt(10, vulnerabilityId);
|
|
<a class="jxr_linenumber" name="L522" href="#L522">522</a> updateVulnerability.executeUpdate();
|
|
<a class="jxr_linenumber" name="L523" href="#L523">523</a> }
|
|
<a class="jxr_linenumber" name="L524" href="#L524">524</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L525" href="#L525">525</a> insertVulnerability.setString(1, vuln.getName());
|
|
<a class="jxr_linenumber" name="L526" href="#L526">526</a> insertVulnerability.setString(2, vuln.getDescription());
|
|
<a class="jxr_linenumber" name="L527" href="#L527">527</a> insertVulnerability.setString(3, vuln.getCwe());
|
|
<a class="jxr_linenumber" name="L528" href="#L528">528</a> insertVulnerability.setFloat(4, vuln.getCvssScore());
|
|
<a class="jxr_linenumber" name="L529" href="#L529">529</a> insertVulnerability.setString(5, vuln.getCvssAccessVector());
|
|
<a class="jxr_linenumber" name="L530" href="#L530">530</a> insertVulnerability.setString(6, vuln.getCvssAccessComplexity());
|
|
<a class="jxr_linenumber" name="L531" href="#L531">531</a> insertVulnerability.setString(7, vuln.getCvssAuthentication());
|
|
<a class="jxr_linenumber" name="L532" href="#L532">532</a> insertVulnerability.setString(8, vuln.getCvssConfidentialityImpact());
|
|
<a class="jxr_linenumber" name="L533" href="#L533">533</a> insertVulnerability.setString(9, vuln.getCvssIntegrityImpact());
|
|
<a class="jxr_linenumber" name="L534" href="#L534">534</a> insertVulnerability.setString(10, vuln.getCvssAvailabilityImpact());
|
|
<a class="jxr_linenumber" name="L535" href="#L535">535</a> insertVulnerability.execute();
|
|
<a class="jxr_linenumber" name="L536" href="#L536">536</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L537" href="#L537">537</a> rs = insertVulnerability.getGeneratedKeys();
|
|
<a class="jxr_linenumber" name="L538" href="#L538">538</a> rs.next();
|
|
<a class="jxr_linenumber" name="L539" href="#L539">539</a> vulnerabilityId = rs.getInt(1);
|
|
<a class="jxr_linenumber" name="L540" href="#L540">540</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L541" href="#L541">541</a> <strong class="jxr_keyword">final</strong> String msg = String.format(<span class="jxr_string">"Unable to retrieve id for new vulnerability for '%s'"</span>, vuln.getName());
|
|
<a class="jxr_linenumber" name="L542" href="#L542">542</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseException.html">DatabaseException</a>(msg, ex);
|
|
<a class="jxr_linenumber" name="L543" href="#L543">543</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L544" href="#L544">544</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L545" href="#L545">545</a> rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L546" href="#L546">546</a> }
|
|
<a class="jxr_linenumber" name="L547" href="#L547">547</a> }
|
|
<a class="jxr_linenumber" name="L548" href="#L548">548</a>
|
|
<a class="jxr_linenumber" name="L549" href="#L549">549</a> <strong class="jxr_keyword">for</strong> (Reference r : vuln.getReferences()) {
|
|
<a class="jxr_linenumber" name="L550" href="#L550">550</a> insertReference.setInt(1, vulnerabilityId);
|
|
<a class="jxr_linenumber" name="L551" href="#L551">551</a> insertReference.setString(2, r.getName());
|
|
<a class="jxr_linenumber" name="L552" href="#L552">552</a> insertReference.setString(3, r.getUrl());
|
|
<a class="jxr_linenumber" name="L553" href="#L553">553</a> insertReference.setString(4, r.getSource());
|
|
<a class="jxr_linenumber" name="L554" href="#L554">554</a>
|
|
<a class="jxr_linenumber" name="L555" href="#L555">555</a> <strong class="jxr_keyword">if</strong> (batchSupported) {
|
|
<a class="jxr_linenumber" name="L556" href="#L556">556</a> insertReference.addBatch();
|
|
<a class="jxr_linenumber" name="L557" href="#L557">557</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L558" href="#L558">558</a> insertReference.execute();
|
|
<a class="jxr_linenumber" name="L559" href="#L559">559</a> }
|
|
<a class="jxr_linenumber" name="L560" href="#L560">560</a> }
|
|
<a class="jxr_linenumber" name="L561" href="#L561">561</a>
|
|
<a class="jxr_linenumber" name="L562" href="#L562">562</a> <strong class="jxr_keyword">if</strong> (batchSupported) {
|
|
<a class="jxr_linenumber" name="L563" href="#L563">563</a> insertReference.executeBatch();
|
|
<a class="jxr_linenumber" name="L564" href="#L564">564</a> }
|
|
<a class="jxr_linenumber" name="L565" href="#L565">565</a>
|
|
<a class="jxr_linenumber" name="L566" href="#L566">566</a> <strong class="jxr_keyword">for</strong> (VulnerableSoftware s : vuln.getVulnerableSoftware()) {
|
|
<a class="jxr_linenumber" name="L567" href="#L567">567</a> <strong class="jxr_keyword">int</strong> cpeProductId = 0;
|
|
<a class="jxr_linenumber" name="L568" href="#L568">568</a> selectCpeId.setString(1, s.getName());
|
|
<a class="jxr_linenumber" name="L569" href="#L569">569</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L570" href="#L570">570</a> rs = selectCpeId.executeQuery();
|
|
<a class="jxr_linenumber" name="L571" href="#L571">571</a> <strong class="jxr_keyword">if</strong> (rs.next()) {
|
|
<a class="jxr_linenumber" name="L572" href="#L572">572</a> cpeProductId = rs.getInt(1);
|
|
<a class="jxr_linenumber" name="L573" href="#L573">573</a> }
|
|
<a class="jxr_linenumber" name="L574" href="#L574">574</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L575" href="#L575">575</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseException.html">DatabaseException</a>(<span class="jxr_string">"Unable to get primary key for new cpe: "</span> + s.getName(), ex);
|
|
<a class="jxr_linenumber" name="L576" href="#L576">576</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L577" href="#L577">577</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L578" href="#L578">578</a> rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L579" href="#L579">579</a> }
|
|
<a class="jxr_linenumber" name="L580" href="#L580">580</a>
|
|
<a class="jxr_linenumber" name="L581" href="#L581">581</a> <strong class="jxr_keyword">if</strong> (cpeProductId == 0) {
|
|
<a class="jxr_linenumber" name="L582" href="#L582">582</a> insertCpe.setString(1, s.getName());
|
|
<a class="jxr_linenumber" name="L583" href="#L583">583</a> insertCpe.setString(2, s.getVendor());
|
|
<a class="jxr_linenumber" name="L584" href="#L584">584</a> insertCpe.setString(3, s.getProduct());
|
|
<a class="jxr_linenumber" name="L585" href="#L585">585</a> insertCpe.executeUpdate();
|
|
<a class="jxr_linenumber" name="L586" href="#L586">586</a> cpeProductId = DBUtils.getGeneratedKey(insertCpe);
|
|
<a class="jxr_linenumber" name="L587" href="#L587">587</a> }
|
|
<a class="jxr_linenumber" name="L588" href="#L588">588</a> <strong class="jxr_keyword">if</strong> (cpeProductId == 0) {
|
|
<a class="jxr_linenumber" name="L589" href="#L589">589</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseException.html">DatabaseException</a>(<span class="jxr_string">"Unable to retrieve cpeProductId - no data returned"</span>);
|
|
<a class="jxr_linenumber" name="L590" href="#L590">590</a> }
|
|
<a class="jxr_linenumber" name="L591" href="#L591">591</a>
|
|
<a class="jxr_linenumber" name="L592" href="#L592">592</a> insertSoftware.setInt(1, vulnerabilityId);
|
|
<a class="jxr_linenumber" name="L593" href="#L593">593</a> insertSoftware.setInt(2, cpeProductId);
|
|
<a class="jxr_linenumber" name="L594" href="#L594">594</a>
|
|
<a class="jxr_linenumber" name="L595" href="#L595">595</a> <strong class="jxr_keyword">if</strong> (s.getPreviousVersion() == <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L596" href="#L596">596</a> insertSoftware.setNull(3, java.sql.Types.VARCHAR);
|
|
<a class="jxr_linenumber" name="L597" href="#L597">597</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L598" href="#L598">598</a> insertSoftware.setString(3, s.getPreviousVersion());
|
|
<a class="jxr_linenumber" name="L599" href="#L599">599</a> }
|
|
<a class="jxr_linenumber" name="L600" href="#L600">600</a> <strong class="jxr_keyword">if</strong> (batchSupported) {
|
|
<a class="jxr_linenumber" name="L601" href="#L601">601</a> insertSoftware.addBatch();
|
|
<a class="jxr_linenumber" name="L602" href="#L602">602</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L603" href="#L603">603</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L604" href="#L604">604</a> insertSoftware.execute();
|
|
<a class="jxr_linenumber" name="L605" href="#L605">605</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L606" href="#L606">606</a> <strong class="jxr_keyword">if</strong> (ex.getMessage().contains(<span class="jxr_string">"Duplicate entry"</span>)) {
|
|
<a class="jxr_linenumber" name="L607" href="#L607">607</a> <strong class="jxr_keyword">final</strong> String msg = String.format(<span class="jxr_string">"Duplicate software key identified in '%s:%s'"</span>, vuln.getName(), s.getName());
|
|
<a class="jxr_linenumber" name="L608" href="#L608">608</a> LOGGER.debug(msg, ex);
|
|
<a class="jxr_linenumber" name="L609" href="#L609">609</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L610" href="#L610">610</a> <strong class="jxr_keyword">throw</strong> ex;
|
|
<a class="jxr_linenumber" name="L611" href="#L611">611</a> }
|
|
<a class="jxr_linenumber" name="L612" href="#L612">612</a> }
|
|
<a class="jxr_linenumber" name="L613" href="#L613">613</a> }
|
|
<a class="jxr_linenumber" name="L614" href="#L614">614</a> }
|
|
<a class="jxr_linenumber" name="L615" href="#L615">615</a> <strong class="jxr_keyword">if</strong> (batchSupported) {
|
|
<a class="jxr_linenumber" name="L616" href="#L616">616</a> insertSoftware.executeBatch();
|
|
<a class="jxr_linenumber" name="L617" href="#L617">617</a> }
|
|
<a class="jxr_linenumber" name="L618" href="#L618">618</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L619" href="#L619">619</a> <strong class="jxr_keyword">final</strong> String msg = String.format(<span class="jxr_string">"Error updating '%s'"</span>, vuln.getName());
|
|
<a class="jxr_linenumber" name="L620" href="#L620">620</a> LOGGER.debug(msg, ex);
|
|
<a class="jxr_linenumber" name="L621" href="#L621">621</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/data/nvdcve/DatabaseException.html">DatabaseException</a>(msg, ex);
|
|
<a class="jxr_linenumber" name="L622" href="#L622">622</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L623" href="#L623">623</a> DBUtils.closeStatement(selectVulnerabilityId);
|
|
<a class="jxr_linenumber" name="L624" href="#L624">624</a> DBUtils.closeStatement(deleteReferences);
|
|
<a class="jxr_linenumber" name="L625" href="#L625">625</a> DBUtils.closeStatement(deleteSoftware);
|
|
<a class="jxr_linenumber" name="L626" href="#L626">626</a> DBUtils.closeStatement(updateVulnerability);
|
|
<a class="jxr_linenumber" name="L627" href="#L627">627</a> DBUtils.closeStatement(deleteVulnerability);
|
|
<a class="jxr_linenumber" name="L628" href="#L628">628</a> DBUtils.closeStatement(insertVulnerability);
|
|
<a class="jxr_linenumber" name="L629" href="#L629">629</a> DBUtils.closeStatement(insertReference);
|
|
<a class="jxr_linenumber" name="L630" href="#L630">630</a> DBUtils.closeStatement(selectCpeId);
|
|
<a class="jxr_linenumber" name="L631" href="#L631">631</a> DBUtils.closeStatement(insertCpe);
|
|
<a class="jxr_linenumber" name="L632" href="#L632">632</a> DBUtils.closeStatement(insertSoftware);
|
|
<a class="jxr_linenumber" name="L633" href="#L633">633</a> }
|
|
<a class="jxr_linenumber" name="L634" href="#L634">634</a> }
|
|
<a class="jxr_linenumber" name="L635" href="#L635">635</a>
|
|
<a class="jxr_linenumber" name="L636" href="#L636">636</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L637" href="#L637">637</a> <em class="jxr_javadoccomment"> * Checks to see if data exists so that analysis can be performed.</em>
|
|
<a class="jxr_linenumber" name="L638" href="#L638">638</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L639" href="#L639">639</a> <em class="jxr_javadoccomment"> * @return <code>true</code> if data exists; otherwise <code>false</code></em>
|
|
<a class="jxr_linenumber" name="L640" href="#L640">640</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L641" href="#L641">641</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">boolean</strong> dataExists() {
|
|
<a class="jxr_linenumber" name="L642" href="#L642">642</a> Statement cs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L643" href="#L643">643</a> ResultSet rs = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L644" href="#L644">644</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L645" href="#L645">645</a> cs = conn.createStatement();
|
|
<a class="jxr_linenumber" name="L646" href="#L646">646</a> rs = cs.executeQuery(<span class="jxr_string">"SELECT COUNT(*) records FROM cpeEntry"</span>);
|
|
<a class="jxr_linenumber" name="L647" href="#L647">647</a> <strong class="jxr_keyword">if</strong> (rs.next()) {
|
|
<a class="jxr_linenumber" name="L648" href="#L648">648</a> <strong class="jxr_keyword">if</strong> (rs.getInt(1) > 0) {
|
|
<a class="jxr_linenumber" name="L649" href="#L649">649</a> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">true</strong>;
|
|
<a class="jxr_linenumber" name="L650" href="#L650">650</a> }
|
|
<a class="jxr_linenumber" name="L651" href="#L651">651</a> }
|
|
<a class="jxr_linenumber" name="L652" href="#L652">652</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L653" href="#L653">653</a> String dd;
|
|
<a class="jxr_linenumber" name="L654" href="#L654">654</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L655" href="#L655">655</a> dd = Settings.getDataDirectory().getAbsolutePath();
|
|
<a class="jxr_linenumber" name="L656" href="#L656">656</a> } <strong class="jxr_keyword">catch</strong> (IOException ex1) {
|
|
<a class="jxr_linenumber" name="L657" href="#L657">657</a> dd = Settings.getString(Settings.KEYS.DATA_DIRECTORY);
|
|
<a class="jxr_linenumber" name="L658" href="#L658">658</a> }
|
|
<a class="jxr_linenumber" name="L659" href="#L659">659</a> LOGGER.error(<span class="jxr_string">"Unable to access the local database.\n\nEnsure that '{}' is a writable directory. "</span>
|
|
<a class="jxr_linenumber" name="L660" href="#L660">660</a> + <span class="jxr_string">"If the problem persist try deleting the files in '{}' and running {} again. If the problem continues, please "</span>
|
|
<a class="jxr_linenumber" name="L661" href="#L661">661</a> + <span class="jxr_string">"create a log file (see documentation at http://jeremylong.github.io/DependencyCheck/) and open a ticket at "</span>
|
|
<a class="jxr_linenumber" name="L662" href="#L662">662</a> + <span class="jxr_string">"https://github.com/jeremylong/DependencyCheck/issues and include the log file.\n\n"</span>,
|
|
<a class="jxr_linenumber" name="L663" href="#L663">663</a> dd, dd, Settings.getString(Settings.KEYS.APPLICATION_NAME));
|
|
<a class="jxr_linenumber" name="L664" href="#L664">664</a> LOGGER.debug(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L665" href="#L665">665</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L666" href="#L666">666</a> DBUtils.closeResultSet(rs);
|
|
<a class="jxr_linenumber" name="L667" href="#L667">667</a> DBUtils.closeStatement(cs);
|
|
<a class="jxr_linenumber" name="L668" href="#L668">668</a> }
|
|
<a class="jxr_linenumber" name="L669" href="#L669">669</a> <strong class="jxr_keyword">return</strong> false;
|
|
<a class="jxr_linenumber" name="L670" href="#L670">670</a> }
|
|
<a class="jxr_linenumber" name="L671" href="#L671">671</a>
|
|
<a class="jxr_linenumber" name="L672" href="#L672">672</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L673" href="#L673">673</a> <em class="jxr_javadoccomment"> * It is possible that orphaned rows may be generated during database</em>
|
|
<a class="jxr_linenumber" name="L674" href="#L674">674</a> <em class="jxr_javadoccomment"> * updates. This should be called after all updates have been completed to</em>
|
|
<a class="jxr_linenumber" name="L675" href="#L675">675</a> <em class="jxr_javadoccomment"> * ensure orphan entries are removed.</em>
|
|
<a class="jxr_linenumber" name="L676" href="#L676">676</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L677" href="#L677">677</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> cleanupDatabase() {
|
|
<a class="jxr_linenumber" name="L678" href="#L678">678</a> PreparedStatement ps = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L679" href="#L679">679</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L680" href="#L680">680</a> ps = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"CLEANUP_ORPHANS"</span>));
|
|
<a class="jxr_linenumber" name="L681" href="#L681">681</a> <strong class="jxr_keyword">if</strong> (ps != <strong class="jxr_keyword">null</strong>) {
|
|
<a class="jxr_linenumber" name="L682" href="#L682">682</a> ps.executeUpdate();
|
|
<a class="jxr_linenumber" name="L683" href="#L683">683</a> }
|
|
<a class="jxr_linenumber" name="L684" href="#L684">684</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L685" href="#L685">685</a> LOGGER.error(<span class="jxr_string">"An unexpected SQL Exception occurred; please see the verbose log for more details."</span>);
|
|
<a class="jxr_linenumber" name="L686" href="#L686">686</a> LOGGER.debug(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L687" href="#L687">687</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L688" href="#L688">688</a> DBUtils.closeStatement(ps);
|
|
<a class="jxr_linenumber" name="L689" href="#L689">689</a> }
|
|
<a class="jxr_linenumber" name="L690" href="#L690">690</a> }
|
|
<a class="jxr_linenumber" name="L691" href="#L691">691</a>
|
|
<a class="jxr_linenumber" name="L692" href="#L692">692</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L693" href="#L693">693</a> <em class="jxr_javadoccomment"> * Determines if the given identifiedVersion is affected by the given cpeId</em>
|
|
<a class="jxr_linenumber" name="L694" href="#L694">694</a> <em class="jxr_javadoccomment"> * and previous version flag. A non-null, non-empty string passed to the</em>
|
|
<a class="jxr_linenumber" name="L695" href="#L695">695</a> <em class="jxr_javadoccomment"> * previous version argument indicates that all previous versions are</em>
|
|
<a class="jxr_linenumber" name="L696" href="#L696">696</a> <em class="jxr_javadoccomment"> * affected.</em>
|
|
<a class="jxr_linenumber" name="L697" href="#L697">697</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L698" href="#L698">698</a> <em class="jxr_javadoccomment"> * @param vendor the vendor of the dependency being analyzed</em>
|
|
<a class="jxr_linenumber" name="L699" href="#L699">699</a> <em class="jxr_javadoccomment"> * @param product the product name of the dependency being analyzed</em>
|
|
<a class="jxr_linenumber" name="L700" href="#L700">700</a> <em class="jxr_javadoccomment"> * @param vulnerableSoftware a map of the vulnerable software with a boolean</em>
|
|
<a class="jxr_linenumber" name="L701" href="#L701">701</a> <em class="jxr_javadoccomment"> * indicating if all previous versions are affected</em>
|
|
<a class="jxr_linenumber" name="L702" href="#L702">702</a> <em class="jxr_javadoccomment"> * @param identifiedVersion the identified version of the dependency being</em>
|
|
<a class="jxr_linenumber" name="L703" href="#L703">703</a> <em class="jxr_javadoccomment"> * analyzed</em>
|
|
<a class="jxr_linenumber" name="L704" href="#L704">704</a> <em class="jxr_javadoccomment"> * @return true if the identified version is affected, otherwise false</em>
|
|
<a class="jxr_linenumber" name="L705" href="#L705">705</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L706" href="#L706">706</a> Entry<String, Boolean> getMatchingSoftware(Map<String, Boolean> vulnerableSoftware, String vendor, String product,
|
|
<a class="jxr_linenumber" name="L707" href="#L707">707</a> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> identifiedVersion) {
|
|
<a class="jxr_linenumber" name="L708" href="#L708">708</a>
|
|
<a class="jxr_linenumber" name="L709" href="#L709">709</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> isVersionTwoADifferentProduct = <span class="jxr_string">"apache"</span>.equals(vendor) && <span class="jxr_string">"struts"</span>.equals(product);
|
|
<a class="jxr_linenumber" name="L710" href="#L710">710</a>
|
|
<a class="jxr_linenumber" name="L711" href="#L711">711</a> <strong class="jxr_keyword">final</strong> Set<String> majorVersionsAffectingAllPrevious = <strong class="jxr_keyword">new</strong> HashSet<String>();
|
|
<a class="jxr_linenumber" name="L712" href="#L712">712</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> matchesAnyPrevious = identifiedVersion == <strong class="jxr_keyword">null</strong> || <span class="jxr_string">"-"</span>.equals(identifiedVersion.toString());
|
|
<a class="jxr_linenumber" name="L713" href="#L713">713</a> String majorVersionMatch = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L714" href="#L714">714</a> <strong class="jxr_keyword">for</strong> (Entry<String, Boolean> entry : vulnerableSoftware.entrySet()) {
|
|
<a class="jxr_linenumber" name="L715" href="#L715">715</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> v = parseDependencyVersion(entry.getKey());
|
|
<a class="jxr_linenumber" name="L716" href="#L716">716</a> <strong class="jxr_keyword">if</strong> (v == <strong class="jxr_keyword">null</strong> || <span class="jxr_string">"-"</span>.equals(v.toString())) { <em class="jxr_comment">//all versions</em>
|
|
<a class="jxr_linenumber" name="L717" href="#L717">717</a> <strong class="jxr_keyword">return</strong> entry;
|
|
<a class="jxr_linenumber" name="L718" href="#L718">718</a> }
|
|
<a class="jxr_linenumber" name="L719" href="#L719">719</a> <strong class="jxr_keyword">if</strong> (entry.getValue()) {
|
|
<a class="jxr_linenumber" name="L720" href="#L720">720</a> <strong class="jxr_keyword">if</strong> (matchesAnyPrevious) {
|
|
<a class="jxr_linenumber" name="L721" href="#L721">721</a> <strong class="jxr_keyword">return</strong> entry;
|
|
<a class="jxr_linenumber" name="L722" href="#L722">722</a> }
|
|
<a class="jxr_linenumber" name="L723" href="#L723">723</a> <strong class="jxr_keyword">if</strong> (identifiedVersion != <strong class="jxr_keyword">null</strong> && identifiedVersion.getVersionParts().get(0).equals(v.getVersionParts().get(0))) {
|
|
<a class="jxr_linenumber" name="L724" href="#L724">724</a> majorVersionMatch = v.getVersionParts().get(0);
|
|
<a class="jxr_linenumber" name="L725" href="#L725">725</a> }
|
|
<a class="jxr_linenumber" name="L726" href="#L726">726</a> majorVersionsAffectingAllPrevious.add(v.getVersionParts().get(0));
|
|
<a class="jxr_linenumber" name="L727" href="#L727">727</a> }
|
|
<a class="jxr_linenumber" name="L728" href="#L728">728</a> }
|
|
<a class="jxr_linenumber" name="L729" href="#L729">729</a> <strong class="jxr_keyword">if</strong> (matchesAnyPrevious) {
|
|
<a class="jxr_linenumber" name="L730" href="#L730">730</a> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L731" href="#L731">731</a> }
|
|
<a class="jxr_linenumber" name="L732" href="#L732">732</a>
|
|
<a class="jxr_linenumber" name="L733" href="#L733">733</a> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">boolean</strong> canSkipVersions = majorVersionMatch != <strong class="jxr_keyword">null</strong> && majorVersionsAffectingAllPrevious.size() > 1;
|
|
<a class="jxr_linenumber" name="L734" href="#L734">734</a> <em class="jxr_comment">//yes, we are iterating over this twice. The first time we are skipping versions those that affect all versions</em>
|
|
<a class="jxr_linenumber" name="L735" href="#L735">735</a> <em class="jxr_comment">//then later we process those that affect all versions. This could be done with sorting...</em>
|
|
<a class="jxr_linenumber" name="L736" href="#L736">736</a> <strong class="jxr_keyword">for</strong> (Entry<String, Boolean> entry : vulnerableSoftware.entrySet()) {
|
|
<a class="jxr_linenumber" name="L737" href="#L737">737</a> <strong class="jxr_keyword">if</strong> (!entry.getValue()) {
|
|
<a class="jxr_linenumber" name="L738" href="#L738">738</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> v = parseDependencyVersion(entry.getKey());
|
|
<a class="jxr_linenumber" name="L739" href="#L739">739</a> <em class="jxr_comment">//this can't dereference a null 'majorVersionMatch' as canSkipVersions accounts for this.</em>
|
|
<a class="jxr_linenumber" name="L740" href="#L740">740</a> <strong class="jxr_keyword">if</strong> (canSkipVersions && !majorVersionMatch.equals(v.getVersionParts().get(0))) {
|
|
<a class="jxr_linenumber" name="L741" href="#L741">741</a> <strong class="jxr_keyword">continue</strong>;
|
|
<a class="jxr_linenumber" name="L742" href="#L742">742</a> }
|
|
<a class="jxr_linenumber" name="L743" href="#L743">743</a> <em class="jxr_comment">//this can't dereference a null 'identifiedVersion' because if it was null we would have exited</em>
|
|
<a class="jxr_linenumber" name="L744" href="#L744">744</a> <em class="jxr_comment">//in the above loop or just after loop (if matchesAnyPrevious return null).</em>
|
|
<a class="jxr_linenumber" name="L745" href="#L745">745</a> <strong class="jxr_keyword">if</strong> (identifiedVersion.equals(v)) {
|
|
<a class="jxr_linenumber" name="L746" href="#L746">746</a> <strong class="jxr_keyword">return</strong> entry;
|
|
<a class="jxr_linenumber" name="L747" href="#L747">747</a> }
|
|
<a class="jxr_linenumber" name="L748" href="#L748">748</a> }
|
|
<a class="jxr_linenumber" name="L749" href="#L749">749</a> }
|
|
<a class="jxr_linenumber" name="L750" href="#L750">750</a> <strong class="jxr_keyword">for</strong> (Entry<String, Boolean> entry : vulnerableSoftware.entrySet()) {
|
|
<a class="jxr_linenumber" name="L751" href="#L751">751</a> <strong class="jxr_keyword">if</strong> (entry.getValue()) {
|
|
<a class="jxr_linenumber" name="L752" href="#L752">752</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> v = parseDependencyVersion(entry.getKey());
|
|
<a class="jxr_linenumber" name="L753" href="#L753">753</a> <em class="jxr_comment">//this can't dereference a null 'majorVersionMatch' as canSkipVersions accounts for this.</em>
|
|
<a class="jxr_linenumber" name="L754" href="#L754">754</a> <strong class="jxr_keyword">if</strong> (canSkipVersions && !majorVersionMatch.equals(v.getVersionParts().get(0))) {
|
|
<a class="jxr_linenumber" name="L755" href="#L755">755</a> <strong class="jxr_keyword">continue</strong>;
|
|
<a class="jxr_linenumber" name="L756" href="#L756">756</a> }
|
|
<a class="jxr_linenumber" name="L757" href="#L757">757</a> <em class="jxr_comment">//this can't dereference a null 'identifiedVersion' because if it was null we would have exited</em>
|
|
<a class="jxr_linenumber" name="L758" href="#L758">758</a> <em class="jxr_comment">//in the above loop or just after loop (if matchesAnyPrevious return null).</em>
|
|
<a class="jxr_linenumber" name="L759" href="#L759">759</a> <strong class="jxr_keyword">if</strong> (entry.getValue() && identifiedVersion.compareTo(v) <= 0) {
|
|
<a class="jxr_linenumber" name="L760" href="#L760">760</a> <strong class="jxr_keyword">if</strong> (!(isVersionTwoADifferentProduct && !identifiedVersion.getVersionParts().get(0).equals(v.getVersionParts().get(0)))) {
|
|
<a class="jxr_linenumber" name="L761" href="#L761">761</a> <strong class="jxr_keyword">return</strong> entry;
|
|
<a class="jxr_linenumber" name="L762" href="#L762">762</a> }
|
|
<a class="jxr_linenumber" name="L763" href="#L763">763</a> }
|
|
<a class="jxr_linenumber" name="L764" href="#L764">764</a> }
|
|
<a class="jxr_linenumber" name="L765" href="#L765">765</a> }
|
|
<a class="jxr_linenumber" name="L766" href="#L766">766</a> <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L767" href="#L767">767</a> }
|
|
<a class="jxr_linenumber" name="L768" href="#L768">768</a>
|
|
<a class="jxr_linenumber" name="L769" href="#L769">769</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L770" href="#L770">770</a> <em class="jxr_javadoccomment"> * Parses the version (including revision) from a CPE identifier. If no</em>
|
|
<a class="jxr_linenumber" name="L771" href="#L771">771</a> <em class="jxr_javadoccomment"> * version is identified then a '-' is returned.</em>
|
|
<a class="jxr_linenumber" name="L772" href="#L772">772</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L773" href="#L773">773</a> <em class="jxr_javadoccomment"> * @param cpeStr a cpe identifier</em>
|
|
<a class="jxr_linenumber" name="L774" href="#L774">774</a> <em class="jxr_javadoccomment"> * @return a dependency version</em>
|
|
<a class="jxr_linenumber" name="L775" href="#L775">775</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L776" href="#L776">776</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> parseDependencyVersion(String cpeStr) {
|
|
<a class="jxr_linenumber" name="L777" href="#L777">777</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/VulnerableSoftware.html">VulnerableSoftware</a> cpe = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/dependency/VulnerableSoftware.html">VulnerableSoftware</a>();
|
|
<a class="jxr_linenumber" name="L778" href="#L778">778</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L779" href="#L779">779</a> cpe.parseName(cpeStr);
|
|
<a class="jxr_linenumber" name="L780" href="#L780">780</a> } <strong class="jxr_keyword">catch</strong> (UnsupportedEncodingException ex) {
|
|
<a class="jxr_linenumber" name="L781" href="#L781">781</a> <em class="jxr_comment">//never going to happen.</em>
|
|
<a class="jxr_linenumber" name="L782" href="#L782">782</a> LOGGER.trace(<span class="jxr_string">""</span>, ex);
|
|
<a class="jxr_linenumber" name="L783" href="#L783">783</a> }
|
|
<a class="jxr_linenumber" name="L784" href="#L784">784</a> <strong class="jxr_keyword">return</strong> parseDependencyVersion(cpe);
|
|
<a class="jxr_linenumber" name="L785" href="#L785">785</a> }
|
|
<a class="jxr_linenumber" name="L786" href="#L786">786</a>
|
|
<a class="jxr_linenumber" name="L787" href="#L787">787</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L788" href="#L788">788</a> <em class="jxr_javadoccomment"> * Takes a CPE and parses out the version number. If no version is</em>
|
|
<a class="jxr_linenumber" name="L789" href="#L789">789</a> <em class="jxr_javadoccomment"> * identified then a '-' is returned.</em>
|
|
<a class="jxr_linenumber" name="L790" href="#L790">790</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L791" href="#L791">791</a> <em class="jxr_javadoccomment"> * @param cpe a cpe object</em>
|
|
<a class="jxr_linenumber" name="L792" href="#L792">792</a> <em class="jxr_javadoccomment"> * @return a dependency version</em>
|
|
<a class="jxr_linenumber" name="L793" href="#L793">793</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L794" href="#L794">794</a> <strong class="jxr_keyword">private</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> parseDependencyVersion(<a href="../../../../../org/owasp/dependencycheck/dependency/VulnerableSoftware.html">VulnerableSoftware</a> cpe) {
|
|
<a class="jxr_linenumber" name="L795" href="#L795">795</a> <strong class="jxr_keyword">final</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a> cpeVersion;
|
|
<a class="jxr_linenumber" name="L796" href="#L796">796</a> <strong class="jxr_keyword">if</strong> (cpe.getVersion() != <strong class="jxr_keyword">null</strong> && !cpe.getVersion().isEmpty()) {
|
|
<a class="jxr_linenumber" name="L797" href="#L797">797</a> <strong class="jxr_keyword">final</strong> String versionText;
|
|
<a class="jxr_linenumber" name="L798" href="#L798">798</a> <strong class="jxr_keyword">if</strong> (cpe.getUpdate() != <strong class="jxr_keyword">null</strong> && !cpe.getUpdate().isEmpty()) {
|
|
<a class="jxr_linenumber" name="L799" href="#L799">799</a> versionText = String.format(<span class="jxr_string">"%s.%s"</span>, cpe.getVersion(), cpe.getUpdate());
|
|
<a class="jxr_linenumber" name="L800" href="#L800">800</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L801" href="#L801">801</a> versionText = cpe.getVersion();
|
|
<a class="jxr_linenumber" name="L802" href="#L802">802</a> }
|
|
<a class="jxr_linenumber" name="L803" href="#L803">803</a> cpeVersion = DependencyVersionUtil.parseVersion(versionText);
|
|
<a class="jxr_linenumber" name="L804" href="#L804">804</a> } <strong class="jxr_keyword">else</strong> {
|
|
<a class="jxr_linenumber" name="L805" href="#L805">805</a> cpeVersion = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/owasp/dependencycheck/utils/DependencyVersion.html">DependencyVersion</a>(<span class="jxr_string">"-"</span>);
|
|
<a class="jxr_linenumber" name="L806" href="#L806">806</a> }
|
|
<a class="jxr_linenumber" name="L807" href="#L807">807</a> <strong class="jxr_keyword">return</strong> cpeVersion;
|
|
<a class="jxr_linenumber" name="L808" href="#L808">808</a> }
|
|
<a class="jxr_linenumber" name="L809" href="#L809">809</a>
|
|
<a class="jxr_linenumber" name="L810" href="#L810">810</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L811" href="#L811">811</a> <em class="jxr_javadoccomment"> * This method is only referenced in unused code.</em>
|
|
<a class="jxr_linenumber" name="L812" href="#L812">812</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L813" href="#L813">813</a> <em class="jxr_javadoccomment"> * Deletes unused dictionary entries from the database.</em>
|
|
<a class="jxr_linenumber" name="L814" href="#L814">814</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L815" href="#L815">815</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> deleteUnusedCpe() {
|
|
<a class="jxr_linenumber" name="L816" href="#L816">816</a> PreparedStatement ps = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L817" href="#L817">817</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L818" href="#L818">818</a> ps = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"DELETE_UNUSED_DICT_CPE"</span>));
|
|
<a class="jxr_linenumber" name="L819" href="#L819">819</a> ps.executeUpdate();
|
|
<a class="jxr_linenumber" name="L820" href="#L820">820</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L821" href="#L821">821</a> LOGGER.error(<span class="jxr_string">"Unable to delete CPE dictionary entries"</span>, ex);
|
|
<a class="jxr_linenumber" name="L822" href="#L822">822</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L823" href="#L823">823</a> DBUtils.closeStatement(ps);
|
|
<a class="jxr_linenumber" name="L824" href="#L824">824</a> }
|
|
<a class="jxr_linenumber" name="L825" href="#L825">825</a> }
|
|
<a class="jxr_linenumber" name="L826" href="#L826">826</a>
|
|
<a class="jxr_linenumber" name="L827" href="#L827">827</a> <em class="jxr_javadoccomment">/**</em>
|
|
<a class="jxr_linenumber" name="L828" href="#L828">828</a> <em class="jxr_javadoccomment"> * This method is only referenced in unused code and will likely break on</em>
|
|
<a class="jxr_linenumber" name="L829" href="#L829">829</a> <em class="jxr_javadoccomment"> * MySQL if ever used due to the MERGE statement.</em>
|
|
<a class="jxr_linenumber" name="L830" href="#L830">830</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L831" href="#L831">831</a> <em class="jxr_javadoccomment"> * Merges CPE entries into the database.</em>
|
|
<a class="jxr_linenumber" name="L832" href="#L832">832</a> <em class="jxr_javadoccomment"> *</em>
|
|
<a class="jxr_linenumber" name="L833" href="#L833">833</a> <em class="jxr_javadoccomment"> * @param cpe the CPE identifier</em>
|
|
<a class="jxr_linenumber" name="L834" href="#L834">834</a> <em class="jxr_javadoccomment"> * @param vendor the CPE vendor</em>
|
|
<a class="jxr_linenumber" name="L835" href="#L835">835</a> <em class="jxr_javadoccomment"> * @param product the CPE product</em>
|
|
<a class="jxr_linenumber" name="L836" href="#L836">836</a> <em class="jxr_javadoccomment"> */</em>
|
|
<a class="jxr_linenumber" name="L837" href="#L837">837</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">synchronized</strong> <strong class="jxr_keyword">void</strong> addCpe(String cpe, String vendor, String product) {
|
|
<a class="jxr_linenumber" name="L838" href="#L838">838</a> PreparedStatement ps = <strong class="jxr_keyword">null</strong>;
|
|
<a class="jxr_linenumber" name="L839" href="#L839">839</a> <strong class="jxr_keyword">try</strong> {
|
|
<a class="jxr_linenumber" name="L840" href="#L840">840</a> ps = getConnection().prepareStatement(statementBundle.getString(<span class="jxr_string">"ADD_DICT_CPE"</span>));
|
|
<a class="jxr_linenumber" name="L841" href="#L841">841</a> ps.setString(1, cpe);
|
|
<a class="jxr_linenumber" name="L842" href="#L842">842</a> ps.setString(2, vendor);
|
|
<a class="jxr_linenumber" name="L843" href="#L843">843</a> ps.setString(3, product);
|
|
<a class="jxr_linenumber" name="L844" href="#L844">844</a> ps.executeUpdate();
|
|
<a class="jxr_linenumber" name="L845" href="#L845">845</a> } <strong class="jxr_keyword">catch</strong> (SQLException ex) {
|
|
<a class="jxr_linenumber" name="L846" href="#L846">846</a> LOGGER.error(<span class="jxr_string">"Unable to add CPE dictionary entry"</span>, ex);
|
|
<a class="jxr_linenumber" name="L847" href="#L847">847</a> } <strong class="jxr_keyword">finally</strong> {
|
|
<a class="jxr_linenumber" name="L848" href="#L848">848</a> DBUtils.closeStatement(ps);
|
|
<a class="jxr_linenumber" name="L849" href="#L849">849</a> }
|
|
<a class="jxr_linenumber" name="L850" href="#L850">850</a> }
|
|
<a class="jxr_linenumber" name="L851" href="#L851">851</a> }
|
|
</pre>
|
|
<hr/>
|
|
<div id="footer">Copyright © 2012–2017 <a href="http://www.owasp.org">OWASP</a>. All rights reserved.</div>
|
|
</body>
|
|
</html>
|