nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Alfresco Enterprise 2.2 on Sybase ASE 15

jett

Has anyone tried installing Alfresco with Sybase ASE 15 as the database? We are getting the error message below in the JBoss server.log file.

Can anyone point me to a configuration file or code that needs to be altered to make it work with ASE?

Thanks in advance for any help/direction provided.

18:33:59,693 ERROR [[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.hibernate.exception.SQLGrammarException: could not execute query
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.loader.Loader.doList(Loader.java:2214)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
   at org.hibernate.loader.Loader.list(Loader.java:2090)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
   at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:804)
   at org.alfresco.repo.avm.hibernate.IssuerDAOHibernate.getIssuerValue(IssuerDAOHibernate.java:66)
   at org.alfresco.repo.avm.Issuer$1TxnWork.execute(Issuer.java:80)
   at org.alfresco.repo.avm.Issuer$1TxnWork.execute(Issuer.java:76)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:174)
   at org.alfresco.repo.avm.Issuer.initialize(Issuer.java:83)
   at org.alfresco.repo.avm.AvmBootstrap.onBootstrap(AvmBootstrap.java:77)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4361)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
   at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
   at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Find more posts tagged with

Comments

pmonks

This is often caused by forgetting to set the correct Hibernate dialect (property "hibernate.dialect" in file "custom-hibernate-dialect.properties") for your JDBC driver and database. Can you post which JDBC driver and Hibernate dialect you've configured Alfresco to use?

Cheers,
Peter

paulsar

hi pmonks,

thanks for the info. i'm working with jett. anyway, here are other details:

i specified the hibernate dialect in a custom file named as "custom-hibernate-dialect.properties"

hibernate.dialect=org.hibernate.dialect.SybaseDialect‍

and also here is my repository configuration

dir.root=/home/paul/alf_data_sybaseDB
db.schema.update=false
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sybase://192.168.1.127:5000;DatabaseName=alfresco
db.username=alfresco
db.password=alfresco
‍‍‍‍‍‍‍‍

in addition to this, I used the JDBC file and parameters(db.driver and db.url) used by Dbvisualizer program since i was able to connect and try some queries with it.

thanks,

paul

paulsar

hi guys,

In addition again to my last post, i even tried to edit the file "alfresco/domain/hibernate-cfg.properties" specified in the "hibernate-context.xml" file just to make sure i'm using the correct dialect settings.

from the default:

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect‍

i replaced with:

hibernate.dialect=org.hibernate.dialect.SybaseDialect‍

i hope there's some resolution on this.

thanks,

paul

pmonks

I don't have a Sybase database to test with, but I think the correct JDBC driver for Sybase is com.sybase.jdbc3.jdbc.SybDriver, which is part of the Sybase jConnect product (available from http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect).

Are you in a position to download and test with the Sybase jConnect JDBC driver?

Cheers,
Peter

paulsar

hi peter,

too bad i can't download the JDBC driver. since i have no rights for my role. anyway, i saw a JDBC driver filenamed "jTDS3.jar" that is included in Sybase ASE15 installation. I'm not quite sure if it is correct because i tried to use that old driver with no success that why i tried using the free sybase JDBC driver from sourceforge.

i'll be very much grateful if you can download it for me.

thanks very much!

br,
paul

paulsar

hello guys,

I tried a different JDBC driver, this time using the jconn3.jar provided at sybase installer. however, i've been getting the same error:

Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.hibernate.exception.SQLGrammarException: could not execute query‍‍

I think the problem is on hibernate. Are there any particular hibernate parameter that I should set when using a sybase dialect.

my current hibernate-cfg.properties

#

# Hibernate configuration
#
hibernate.dialect=org.hibernate.dialect.SybaseDialect
hibernate.jdbc.use_streams_for_binary=true
hibernate.show_sql=false
hibernate.cache.use_query_cache=true
hibernate.max_fetch_depth=10
hibernate.cache.provider_class=org.alfresco.repo.cache.InternalEhCacheManagerFactoryBean
hibernate.cache.use_second_level_cache=true
hibernate.default_batch_fetch_size=1
hibernate.jdbc.batch_size=32
hibernate.connection.release_mode=auto
hibernate.connection.isolation=2
#hibernate.jdbc.use_get_generated_keys=true
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

and my repository.properties

dir.root=/home/paul/alf_data_sybaseDB
db.schema.update=false
db.driver=com.sybase.jdbc3.jdbc.SybConnectionPoolDataSource
db.url=jdbc:sybase:Tds:192.168.1.123:5000/alfresco
db.username=alfresco
db.password=alfresco
‍‍‍‍‍‍‍

thanks,

Paul

steve

Hi,

Our last supported version of Sybase was v12 - so you could be finding some differences in the way hibernate handles Sybase 15 that's causing your problems.
We have not yet tested Alfresco on Sybase 15 so I can't offer any guidance on what might be causing this problem.

Steve

jonathanb

Can you post the complete stack trace (and any other data) around your problem? I'm hoping it will have more detail, which could help point towards a solution.

Also, I suggest using com.sybase.jdbc3.jdbc.SybDriver, rather instead of the pooled source, as Hibernate has it's own caching system.