AnsweredAssumed Answered

Alfresco and Firebird 2.0.x

Question asked by gsantosgo on Apr 23, 2007
Latest reply on Apr 26, 2007 by derek
Hello. Good Morning.

  I am installing Alfresco with DBMS Firebird 2.0. But i have a problem.

  MY PROBLEM
  ==============================================
  There is a problem, it can't create Database  Schema,  because  it try to create a table that use RESERVED WORDS of  Firebird, Ej.    month, year, … How can i solve it?
  ———————————————————————————–

  Explanation Steps.

  1. custom-hibernate-dialect.properties

      hibernate.dialect=org.hibernate.dialect.FirebirdDialect
 
  2. custom-db-connection.properties
     
      db.username=sysdba
      db.password=masterkey
      db.pool.initial=10
      db.pool.max=100

      #
      # Firebird connection (requires jaybird-2.1.1.jar or equivalent jar in  shared libraries location)
      #
      db.driver=org.firebirdsql.jdbc.FBDriver
      db.url=jdbc:firebirdsql:localhost/3050:c:/basededatos/alfresco.gdb

  3. Create DATABASE.

      SET SQL DIALECT 3;

      SET NAMES UTF8;


      CREATE DATABASE 'localhost:C:\basededatos\ALFRESCO.GDB'
      USER 'SYSDBA' PASSWORD 'masterkey'
      PAGE_SIZE 8192
      DEFAULT CHARACTER SET UTF8;

   4.  Install driver jaybird2.1.1-full.jar in Tomcat (common/libs)

   4.  Start Tomcat (DEBUT)

        4.1 It create a database script.

      11:24:23,398 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Generating unmodified schema creation script: C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.FirebirdDialect-51389.sql
 
        4.2 Execute Database Schema

        In this point, there is a problem, it can't create Database  Schema,  because  it try to create a table that use RESERVED WORDS of  Firebird, Ej.    month, year, … How can i solve it?
     
11:24:24,132 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL:  create table alf_audit_date ( id numeric(18,0) not null, date_only date not null, day_of_year integer not null, day_of_month integer not null, day_of_week integer not null, week_of_year integer not null, week_of_month integer not null, month integer not null, quarter integer not null, halfYear integer not null, year integer not null, primary key (id) )
   Error: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 238
month
   File: C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.FirebirdDialect-51389.sql
   Line: 435


Someone knows the solution.

   Thanks. Good day.

Outcomes