AnsweredAssumed Answered

Error installation Alfresco+jboss+Oracle

Question asked by oxxdi on Jun 12, 2007

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 '

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,


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 ''
16:12:22,523 WARN  [SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ''
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(
   at org.apache.commons.dbcp.BasicDataSource.getConnection(
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(
   at org.hibernate.cfg.SettingsFactory.buildSettings(
   at org.hibernate.cfg.Configuration.buildSettings(
   at org.hibernate.cfg.Configuration.buildSessionFactory(
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(
   at org.apache.catalina.core.StandardContext.listenerStart(
   at org.apache.catalina.core.StandardContext.start(
   at org.apache.catalina.core.ContainerBase.addChildInternal(


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