[jboss-user] [JBoss Portal] - 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
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4201974#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...