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.
