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(1) not null, primary key (PK)
| 18:34:27,867 ERROR [SchemaUpdate] Length or precision specification
1 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
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user