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.
Here's the issue that i am running into. Any help/pointers in this area would be very helpful.
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.
The snippet of the log is towards the bottom.
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.
So, the two possible workarounds i have for this after talking to the DBA's are
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.
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.
If someone could throw any light on how i can accomplish this, i would very much appreciate it.
Regards,
-Venkat.
##### Begin log snippet #######
10:42:21,006 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
SQL: create table JBPM_ACTION (
ID_ NUMERIC(18,0) not null,
class CHAR(1) not null,
NAME_ VARCHAR(255),
ISPROPAGATIONALLOWED_ BYTEINT,
ACTIONEXPRESSION_ VARCHAR(255),
ISASYNC_ BYTEINT,
REFERENCEDACTION_ NUMERIC(18,0),
ACTIONDELEGATION_ NUMERIC(18,0),
EVENT_ NUMERIC(18,0),
PROCESSDEFINITION_ NUMERIC(18,0),
TIMERNAME_ VARCHAR(255),
DUEDATE_ VARCHAR(255),
REPEAT_ VARCHAR(255),
TRANSITIONNAME_ VARCHAR(255),
TIMERACTION_ NUMERIC(18,0),
EXPRESSION_ VARCHAR(4000),
EVENTINDEX_ INTEGER,
EXCEPTIONHANDLER_ NUMERIC(18,0),
EXCEPTIONHANDLERINDEX_ INTEGER,
primary key (ID_)
)
Error: [****My ***** Database] [****My JDBC ****] [Error 3707] [SQLState 42000] Syntax error, expected something like a 'CHECK' keyword between ',' and the 'class' keyword.
##### End log snippet #######
