title: Artifactory OSS with Oracle defaults to Derby
body: <p>I recently set up a Red Hat and Oracle environment for Artifactory OSS 4.12.2. The problem is, the metadata is still being stored using Derby.</p>
  
  <p>I followed the instructions at..</p>
  
  <p><a href="https://www.jfrog.com/confluence/display/RTF/Configuring+the+Database" rel="nofollow">https://www.jfrog.com/confluence/display/RTF/Configuring+the+Database</a>
  <a href="https://www.jfrog.com/confluence/display/RTF/Oracle" rel="nofollow">https://www.jfrog.com/confluence/display/RTF/Oracle</a></p>
  
  <p>I want to set it up using "DB-Filesystem - This configuration stores metadata in Oracle Database and artifact binary data is stored on the file system" Yet the Oracle database is empty and when I look at the Artifactory system info page I see...</p>
  
  <p>Storage Info:
  Database Type:  derby
  Storage Type:   filesystem
  Connection Url: jdbc:derby:/var/opt/jfrog/artifactory/data/derby;create=true</p>
  
  <p>Any help would be greatly appreciated as I really think I followed all of the instructions (tomcat/lib/obdbc7.jar, oracle.properties updated with DB connection details then copied to etc/storage.properties)</p>
  
  <p>I did notice the artifactory.log file kicked off Derby on start up rather than Oracle...</p>
  
  <p>2016-09-15 14:25:46,835 [art-init] [INFO ] (o.a.s.d.DbServiceImpl:186) - Database: Apache Derby 10.11.1.1 - (1616546). Driver: Apache Derby Embedded JDBC Driver 10.11.1.1 - (1616546)
  2016-09-15 14:25:46,836 [art-init] [INFO ] (o.a.s.d.DbServiceImpl:188) - Connection URL: jdbc:derby:/var/opt/jfrog/artifactory/data/derby</p>
  
  <p>Thanks</p>
  
  <p>Jonny</p>
  
  <p><strong>#Update 2</strong></p>
  
  <pre><code>#
  #
  # Artifactory is a binaries repository manager.
  # Copyright (C) 2016 JFrog Ltd.
  #
  # Artifactory is free software: you can redistribute it and/or modify
  # it under the terms of the GNU Affero General Public License as published by
  # the Free Software Foundation, either version 3 of the License, or
  #  (at your option) any later version.
  #
  # Artifactory is distributed in the hope that it will be useful,
  # but WITHOUT ANY WARRANTY; without even the implied warranty of
  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  # GNU Affero General Public License for more details.
  #
  # You should have received a copy of the GNU Affero General Public License
  # along with Artifactory.  If not, see &lt;http://www.gnu.org/licenses/&gt;.
  #
  #
  
  type=oracle
  driver=oracle.jdbc.OracleDriver
  url=jdbc:oracle:thin:@ourserver:ourport:ourdatabase
  username=ourschema
  password=ourschemapassword
  
  ## Determines where the actual artifacts binaries are stored. Available options:
  ## filesystem - binaries are stored in the filesystem (recommended, default)
  ## fullDb     - binaries are stored as blobs in the db, filesystem is used for caching
  ## cachedFS   - binaries are stored in the filesystem, but a front cache (with faster access) is added
  ## IMPORTANT NOTE: This property should not be change after the initial setup. To change binaries storage you have to export and import
  #binary.provider.type=filesystem
  
  ## Determines the maximum filesystem cache size in bytes when using binary provider type fullDb or cachedFS. Default is 5GB
  ## Supported units are TB (terabytes), GB (gigabytes), MB (megabytes) and KB (kilobytes)
  #binary.provider.cache.maxSize=5GB
  </code></pre>
  
  <p><strong>#Update 3</strong></p>
  
  <p>This is an RPM installation on Red Hat</p>
  
  <p>storage.properties is located in $ARTIFACTORY_HOME/etc (/opt/jfrog/artifactory/etc)</p>
  
  <p>The only file in the etc folder is currently storage.properties</p>
  
  <p>I have restarted the Artifactory service on Red Hat after verifiting the settings in the storage.properties (settings can be found above)</p>