topic Issue with Installing Alfresco on a proprietary database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/issue-with-installing-alfresco-on-a-proprietary-database/m-p/181073#M134203 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><SPAN> I was redirected to the forums here from the Alfresco support group, because they don't provide support for proprietary dbs for the Labs/Community release.</SPAN><BR /><BR /><SPAN>&nbsp; Here's the issue that i am running into. Any help/pointers in this area would be very helpful.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp; I am trying to install Alfresco to run against our proprietary database using the corresponding JDBC connector and i am running into an issue when i bring up the Alfresco server.</SPAN><BR /><BR /><SPAN> The snippet of the log is towards the bottom.</SPAN><BR /><SPAN> The issue we are running into, is that one of the columns used in the Alfresco DB's schema is named 'class'. But 'class' happens to be a reserved word/keyword in our database.</SPAN><BR /><BR /><SPAN> So, the two possible workarounds i have for this after talking to the DBA's are</SPAN><BR /><SPAN>&nbsp; 1) To rename the column "class" to use a non-reserved word like class_1(for example) - This approach would be the least impact one.</SPAN><BR /><SPAN>&nbsp; 2) To wrap the reserved word(class) in double quotes(but this has to be done everywhere the column is used - like selects, creates inserts etc.) - like "class" CHAR(1) not null.</SPAN><BR /><BR /><SPAN> If someone could throw any light on how i can accomplish this, i would very much appreciate it.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Regards,</SPAN><BR /><SPAN>-Venkat.</SPAN><BR /><SPAN>##### Begin log snippet #######</SPAN><BR /><SPAN>10:42:21,006 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:</SPAN><BR /><SPAN>&nbsp;&nbsp; SQL: create table JBPM_ACTION (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID_ NUMERIC(18,0) not null,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; class CHAR(1) not null,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME_ VARCHAR(255),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ISPROPAGATIONALLOWED_ BYTEINT,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACTIONEXPRESSION_ VARCHAR(255),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ISASYNC_ BYTEINT,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REFERENCEDACTION_ NUMERIC(18,0),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACTIONDELEGATION_ NUMERIC(18,0),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EVENT_ NUMERIC(18,0),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROCESSDEFINITION_ NUMERIC(18,0),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TIMERNAME_ VARCHAR(255),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DUEDATE_ VARCHAR(255),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REPEAT_ VARCHAR(255),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRANSITIONNAME_ VARCHAR(255),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TIMERACTION_ NUMERIC(18,0),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXPRESSION_ VARCHAR(4000),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EVENTINDEX_ INTEGER,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXCEPTIONHANDLER_ NUMERIC(18,0),</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXCEPTIONHANDLERINDEX_ INTEGER,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; primary key (ID_)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; )</SPAN><BR /><SPAN>&nbsp;&nbsp; Error: [****My ***** Database] [****My JDBC ****] [Error 3707] [SQLState 42000] Syntax error, expected something like a 'CHECK' keyword between ',' and the 'class' keyword.</SPAN><BR /><SPAN>##### End log snippet #######</SPAN></BODY></HTML> Thu, 19 Mar 2009 14:56:43 GMT venkataraja 2009-03-19T14:56:43Z Issue with Installing Alfresco on a proprietary database https://connect.hyland.com/t5/alfresco-archive/issue-with-installing-alfresco-on-a-proprietary-database/m-p/181073#M134203 Hi All, I was redirected to the forums here from the Alfresco support group, because they don't provide support for proprietary dbs for the Labs/Community release.&nbsp; Here's the issue that i am running into. Any help/pointers in this area would be very helpful. &nbsp; I am trying to install Alfresco to run Thu, 19 Mar 2009 14:56:43 GMT https://connect.hyland.com/t5/alfresco-archive/issue-with-installing-alfresco-on-a-proprietary-database/m-p/181073#M134203 venkataraja 2009-03-19T14:56:43Z Re: Issue with Installing Alfresco on a proprietary database https://connect.hyland.com/t5/alfresco-archive/issue-with-installing-alfresco-on-a-proprietary-database/m-p/181074#M134204 <HTML><HEAD></HEAD><BODY><SPAN>Can I ask why you'd want to do that? Why not use PostgreSQL or MySQL?</SPAN></BODY></HTML> Thu, 19 Mar 2009 17:47:02 GMT https://connect.hyland.com/t5/alfresco-archive/issue-with-installing-alfresco-on-a-proprietary-database/m-p/181074#M134204 zaizi 2009-03-19T17:47:02Z Re: Issue with Installing Alfresco on a proprietary database https://connect.hyland.com/t5/alfresco-archive/issue-with-installing-alfresco-on-a-proprietary-database/m-p/181075#M134205 <HTML><HEAD></HEAD><BODY><SPAN>Because the proprietary database that we use is a massively parallel system with a linear growth curve and we would like to take advantage of it.</SPAN></BODY></HTML> Tue, 24 Mar 2009 19:14:22 GMT https://connect.hyland.com/t5/alfresco-archive/issue-with-installing-alfresco-on-a-proprietary-database/m-p/181075#M134205 venkataraja 2009-03-24T19:14:22Z