Cannot create JBP_CMS tables on SYBASE 12.5
After multiple tries and jconn5.jar and hibernate3.jar when I run jboss, it creates all the tables except:
jbp_cms_version_node
jbp_cms_version_prop
jbp_cms_version_refs
jbp_cms_wsp_node
jbp_cms_wsp_prop
jbp_cms_wsp_refs
I keep getting similar error as:
18:34:27,867 ERROR [SchemaUpdate] Unsuccessful: create table jbp_cms_version_node (PK int identity not null, NODE_ID varchar(36) null, NODE_DATA varbinary(100000000) not null, primary key (PK) 18:34:27,867 ERROR [SchemaUpdate] Length or precision specification 100000000 is not within the range of 1 to 16384.
I tried SybaseDialect, Sybase11Dialect and the auto dialect, but I have the same results as:
18:34:27,961 WARN [ServiceController] Problem starting service portal:service=Hibernate,type=Workflow org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Adaptive Server Enterprise
And
18:34:30,570 INFO [JCRCMS] JBossCache Version=1.4.1 18:34:30,570 INFO [JCRCMS] Starting JCR CMS 18:34:30,758 INFO [RepositoryImpl] Starting repository... 18:34:30,930 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: JZ006 18:34:30,930 ERROR [JDBCExceptionReporter] JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004. 18:34:30,945 ERROR [HibernateStore] failed to create folder entry: / org.hibernate.exception.GenericJDBCException: could not insert: [org.jboss.portal.cms.hibernate.RepositoryEntry]
18:34:31,664 WARN [ServiceController] Problem starting service portal:service=CMS javax.jcr.RepositoryException: failed to create folder for repository meta data: failed to create folder entry: /: failed to create folder entry: /: failed to create folder entry: /
And Finally:
--- MBeans waiting for other MBeans --- ObjectName: portal:service=CMS State: FAILED Reason: javax.jcr.RepositoryException: failed to create folder for repository meta data: failed to create folder entry: /: failed to create folder entry: / I Depend On: jboss.jca:service=DataSourceBinding,name=PortalDS portal:service=JAASLoginModule portal:service=Hibernate,type=CMS cms.pm.cache:service=TreeCache portal:service=AuthorizationManager,type=cms portal:service=InterceptorStackFactory,type=Cms Depends On Me: portal:commandFactory=CMSObject ObjectName: portal:service=Hibernate,type=Workflow State: FAILED Reason: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Adaptive Server Enterprise I Depend On: jboss.jca:service=DataSourceBinding,name=PortalDS Depends On Me: portal:service=Workflow,type=WorkflowService --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: portal:service=CMS State: FAILED Reason: javax.jcr.RepositoryException: failed to create folder for repository meta data: failed to create folder entry: /: failed to create folder entry: / I Depend On: jboss.jca:service=DataSourceBinding,name=PortalDS portal:service=JAASLoginModule portal:service=Hibernate,type=CMS cms.pm.cache:service=TreeCache portal:service=AuthorizationManager,type=cms portal:service=InterceptorStackFactory,type=Cms Depends On Me: portal:commandFactory=CMSObject ObjectName: portal:service=Hibernate,type=Workflow State: FAILED Reason: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Adaptive Server Enterprise I Depend On: jboss.jca:service=DataSourceBinding,name=PortalDS Depends On Me: portal:service=Workflow,type=WorkflowService
I've tried diff combinations of hibernate dialects and Sybase driver without any luck.
I looked up allover and as usual, lot of people dotn use SYBASE and there is very less info on SYBASE and JBOSS.
Please can somebody shed some light on this?
Thanks
