We are evaluating if we want to use Alfresco 2.1.0 as our website's cms, but when we try to deploy against Sybase ASE 1.5.02 with the most recent jConnect jdbc drivers (db.driver=com.sybase.jdbc3.jdbc.SybDriver) the bootstrapping fails. Any suggestions on how to fix this?
11:41:50,796 INFO [domain.schema.SchemaBootstrap] Schema managed by database di
alect org.alfresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect.
11:41:50,968 INFO [domain.schema.SchemaBootstrap] Executing database script D:\
alfresco-community-tomcat-2.1.0\tomcat\temp\Alfresco\AlfrescoSchemaCreate-org.al
fresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect-17293.sql (Ge
nerated).
11:41:51,187 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
SQL: create table JBPM_PROCESSINSTANCE ( ID_ numeric(19,0) identity not null
, VERSION_ int not null, KEY_ text null, START_ datetime null, END_ datetime nul
l, ISSUSPENDED_ tinyint null, PROCESSDEFINITION_ numeric(19,0) null, ROOTTOKEN_
numeric(19,0) null, SUPERPROCESSTOKEN_ numeric(19,0) null, primary key (ID_), un
ique (KEY_, PROCESSDEFINITION_) )
Error: Column 'KEY_' – Can't create index on a column of TEXT, IMAGE or UNIT
EXT data type.
File: D:\alfresco-community-tomcat-2.1.0\tomcat\temp\Alfresco\AlfrescoSchemaC
reate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect-1
7293.sql
Line: 234
11:41:51,203 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
com.sybase.jdbc3.jdbc.SybSQLException: Column 'KEY_' – Can't create index on a
column of TEXT, IMAGE or UNITEXT data type.
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStateme
nt.java:261)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(Sche
maBootstrap.java:700)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(Sch
emaBootstrap.java:675)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBo
otstrap.java:443)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBoo
tstrap.java:767)
at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
