title: HSQLDB ORACLE user lacks privilege or object not found: REGEXP_LIKE
body: <p>i have a little problem with an hsqldb test.</p>
  
  <p>I use oracle 11g as datasource for my project and hsqldb-2.3.2.jar for test.</p>
  
  <p>In one query, i have used this regexp <code>AND REGEXP_LIKE(CODE_SC, '*PL[0-9]_J5[1-9]$')</code></p>
  
  <p>And i can't test it with hsqldb, i have configured my datasource like this :</p>
  
  <pre><code>&lt;bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"&gt;
      &lt;property name="driverClassName" value="org.hsqldb.jdbcDriver" /&gt;
      &lt;property name="url" value="jdbc:hsqldb:mem:castor;sql.syntax_ora=true" /&gt;
      &lt;property name="username" value="sa" /&gt;
      &lt;property name="password" value="" /&gt;
  &lt;/bean&gt;
  </code></pre>
  
  <p>and the sessionFactory with </p>
  
  <pre><code>&lt;prop key="hibernate.dialect"&gt;fr.edf.mpv2.castor.persistance.HsqlOracleDialect&lt;/prop&gt;
  &lt;prop key="hibernate.show_sql"&gt;false&lt;/prop&gt;
  &lt;prop key="hibernate.hbm2ddl.auto"&gt;create&lt;/prop&gt;
  &lt;prop key="hibernate.hbm2ddl.import_files"&gt;import.sql&lt;/prop&gt;
  </code></pre>
  
  <p>i add all what i need in import.sql and it's working fine.</p>
  
  <p>i have create a class with :</p>
  
  <pre><code> public class HsqlOracleDialect extends Oracle10gDialect {
  
      public HsqlOracleDialect() {
          super();
      }
  
      @Override
      protected void registerFunctions() {
              registerFunction("regexp_like", new SQLFunctionTemplate(Hibernate.BOOLEAN,
       "case when (regexp_like(?1,?2)) then 1 else 0 end)"));
      }
  }
  </code></pre>
  
  <p>but i get this error :</p>
  
  <p><code>user lacks privilege or object not found: REGEXP_LIKE</code></p>
  
  <p>does i have forgot to declare something?</p>
  
  <p>thanks a lot.</p>