AnsweredAssumed Answered

Error installation Alfresco+jboss+Oracle

Question asked by oxxdi on Jun 12, 2007
Hello!

I´m trying to install alfresco 2.0 with a jboss 4.0.5 app server plus oracle 10. The other day i installed alfresco 2 with tomcat and posted a problem to solve and the solution was succesful.

You can see i´m newbie in alfresco and want to install it with both appz server.

With jboss i've got a :

     'SQLNestedException: Cannot load JDBC driver class org.gjt.mm.mysql.Driver '

when i don´t use mysql, i have to use oracle and i've configured alfresco like 'database configuration' document & 'deploying war jboss' document.

Could anybody help?

thank you so much for your time and effort,

OxxDI

Errors :




…….


16:12:22,101 INFO  [HbmBinder] Mapping collection: org.jbpm.graph.action.Script.variableAccesses -> JBPM_VARIABLEACCESS
16:12:22,148 INFO  [HbmBinder] Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes -> JBPM_SWIMLANE
16:12:22,148 INFO  [HbmBinder] Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks -> JBPM_TASK
16:12:22,507 INFO  [ConnectionProviderFactory] Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
16:12:22,523 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
16:12:22,523 ERROR [JDBCExceptionReporter] Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
16:12:22,523 WARN  [SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:800)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:726)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:203)
   at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:614)
   at org.springframework.context.support.AbstractApplicationContext.registerListeners(AbstractApplicationContext.java:496)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:317)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   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:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)

……..

16:12:23,085 INFO  [Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
16:12:23,101 INFO  [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
16:12:23,117 INFO  [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
16:12:23,117 INFO  [SettingsFactory] Automatic flush during beforeCompletion(): disabled
16:12:23,117 INFO  [SettingsFactory] Automatic session close at end of transaction: disabled
16:12:23,117 INFO  [SettingsFactory] Scrollable result sets: disabled
16:12:23,117 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
16:12:23,132 INFO  [SettingsFactory] Connection release mode: auto
16:12:23,132 INFO  [SettingsFactory] Maximum outer join fetch depth: 10

………

16:12:32,053 WARN  [CacheManager] Creating a new instance of CacheManager using the diskStorePath "C:\DOCUME~1\dromera\CONFIG~1\Temp\" which is already used by an existing CacheManager.
The source of the configuration was URL of file:/C:/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp14027alfresco-exp.war/WEB-INF/classes/alfresco/ehcache-transactional.xml.
The diskStore path for this CacheManager will be set to C:\DOCUME~1\…\CONFIG~1\Temp\\ehcache_auto_created_1181657552053.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
16:12:32,053 INFO  [EhCacheFactoryBean] Creating new EHCache cache region 'org.alfresco.permissionsAccessCache'
16:12:32,084 INFO  [EhCacheFactoryBean] Creating new EHCache cache region 'org.alfresco.ticketsCache'
16:12:32,100 INFO  [EhCacheFactoryBean] Creating new EHCache cache region 'org.alfresco.nodeOwnerCache'
………………………………


Thank you so much

Outcomes