title: SQLite dialect into Hibernate-Maven project
body: <p>i am a java student and i have to do a small project. I have to use Maven and Hibernate ( no Spring frameworks). I use IntelliJ as IDE. The thing is that my teacher recomended me to use SQLite as RDBMS because its very simple, 1 file and there is no need to implement a server inside my app. ( i have no idea to do the last point). 
  The problem is that when i try to do the "hibernate.cfg.xml " i have no way to configure it because of the lack of information. Seems there is no dialect supported from Hibernate and the info i could find on internet is outdated. Any idea on how i can configure it? Do i really need to use another RDBMS ?
  there is a picture of my <a href="https://i.stack.imgur.com/dsi9F.png" rel="nofollow noreferrer">project structure</a></p>
  
  <p>this is my hibernate.cfg.xml:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"&gt;
  &lt;hibernate-configuration&gt;
      &lt;session-factory&gt;
          &lt;property name="connection.driver_class"&gt;org.sqlite.JDBC&lt;/property&gt;
          &lt;property name="connection.url"&gt;jdbc:sqlite://db/appiculturedb.sqlite3&lt;/property&gt;
          &lt;property name="connection.username"&gt;&lt;/property&gt;
          &lt;property name="connection.password"&gt;&lt;/property&gt;
          &lt;property name="dialect"&gt;org.hibernate.dialect.SQLiteDialect&lt;/property&gt;
          &lt;property name="hibernate.show_sql"&gt;true&lt;/property&gt;
  
          &lt;!--        maping with xml--&gt;
          &lt;mapping resource="Bodega.hbm.xml" /&gt;
  
          &lt;!--        maping with anotations--&gt;
          &lt;!--        &lt;mapping class="com.stephane.Bodega" /&gt;     --&gt;
  
      &lt;/session-factory&gt;
  &lt;/hibernate-configuration&gt;
  </code></pre>