topic Alfresco and Firebird 2.0.x in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-and-firebird-2-0-x/m-p/100804#M69883 <HTML><HEAD></HEAD><BODY><SPAN>Hello. Good Morning. </SPAN><BR /><BR /><SPAN>&nbsp; I am installing Alfresco with DBMS Firebird 2.0. But i have a problem. </SPAN><BR /><BR /><SPAN>&nbsp; MY PROBLEM</SPAN><BR /><SPAN>&nbsp; ==============================================</SPAN><BR /><SPAN>&nbsp; There is a problem, it can't create Database&nbsp; Schema,&nbsp; because&nbsp; it try to create a table that use RESERVED WORDS of&nbsp; Firebird, Ej.&nbsp;&nbsp;&nbsp; month, year, … How can i solve it? </SPAN><BR /><SPAN>&nbsp; ———————————————————————————–</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp; Explanation Steps. </SPAN><BR /><BR /><SPAN>&nbsp; 1. custom-hibernate-dialect.properties</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hibernate.dialect=org.hibernate.dialect.FirebirdDialect</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; 2. custom-db-connection.properties</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.username=sysdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.password=masterkey</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.pool.initial=10</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.pool.max=100</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # Firebird connection (requires jaybird-2.1.1.jar or equivalent jar in&nbsp; shared libraries location)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.driver=org.firebirdsql.jdbc.FBDriver</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db.url=jdbc:firebirdsql:localhost/3050:c:/basededatos/alfresco.gdb</SPAN><BR /><BR /><SPAN>&nbsp; 3. Create DATABASE. </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET SQL DIALECT 3;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET NAMES UTF8;</SPAN><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CREATE DATABASE 'localhost:C:\basededatos\ALFRESCO.GDB'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USER 'SYSDBA' PASSWORD 'masterkey'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PAGE_SIZE 8192</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEFAULT CHARACTER SET UTF8;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; 4.&nbsp; Install driver jaybird2.1.1-full.jar in Tomcat (common/libs) </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; 4.&nbsp; Start Tomcat (DEBUT) </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.1 It create a database script. </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11:24:23,398 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Generating unmodified schema creation script: C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.FirebirdDialect-51389.sql</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.2 Execute Database Schema </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In this point, there is a problem, it can't create Database&nbsp; Schema,&nbsp; because&nbsp; it try to create a table that use RESERVED WORDS of&nbsp; Firebird, Ej.&nbsp;&nbsp;&nbsp; month, year, … How can i solve it? </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>11:24:24,132 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:</SPAN><BR /><SPAN>&nbsp;&nbsp; SQL:&nbsp; 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) )</SPAN><BR /><SPAN>&nbsp;&nbsp; Error: GDS Exception. 335544569. Dynamic SQL Error</SPAN><BR /><SPAN>SQL error code = -104</SPAN><BR /><SPAN>Token unknown - line 1, column 238</SPAN><BR /><SPAN>month</SPAN><BR /><SPAN>&nbsp;&nbsp; File: C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.FirebirdDialect-51389.sql</SPAN><BR /><SPAN>&nbsp;&nbsp; Line: 435</SPAN><BR /><BR /><BR /><SPAN>Someone knows the solution. </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; Thanks. Good day.</SPAN></BODY></HTML> Mon, 23 Apr 2007 10:24:40 GMT gsantosgo 2007-04-23T10:24:40Z Alfresco and Firebird 2.0.x https://connect.hyland.com/t5/alfresco-archive/alfresco-and-firebird-2-0-x/m-p/100804#M69883 Hello. Good Morning. &nbsp; I am installing Alfresco with DBMS Firebird 2.0. But i have a problem. &nbsp; MY PROBLEM&nbsp; ==============================================&nbsp; There is a problem, it can't create Database&nbsp; Schema,&nbsp; because&nbsp; it try to create a table that use RESERVED WORDS of&nbsp; Firebird, Ej.&nbsp;&nbsp;&nbsp; month, yea Mon, 23 Apr 2007 10:24:40 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-firebird-2-0-x/m-p/100804#M69883 gsantosgo 2007-04-23T10:24:40Z Re: Alfresco and Firebird 2.0.x https://connect.hyland.com/t5/alfresco-archive/alfresco-and-firebird-2-0-x/m-p/100805#M69884 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Thanks for reporting this.&nbsp; I've raised an issue with the workaround in JIRA: </SPAN><A href="http://issues.alfresco.com/browse/AR-1426" rel="nofollow noopener noreferrer">http://issues.alfresco.com/browse/AR-1426</A><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Thu, 26 Apr 2007 16:35:03 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-firebird-2-0-x/m-p/100805#M69884 derek 2007-04-26T16:35:03Z