[jboss-user] [JBoss Portal] - Cannot create JBP_CMS tables on SYBASE 12.5

[ssunkara]

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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4201974#4201974

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4201974