AnsweredAssumed Answered

3.3.3 to 3.4.2 upgrade failure in development [Solved]

Question asked by michaelc on Jun 27, 2011
Latest reply on Jun 27, 2011 by michaelc
Trying to do an upgrade to 3.4.2 from 3.3.3 in my development region (Windows ) and I failed.
I missed something somewhere as it is still looking for the postgres drivers.

11:47:34,203 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
11:47:36,062 WARN  [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL 'jdbc:mysql://localhost:3306/alfresco?useUnicode=true&characterEncoding=utf8'
   at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)

I changed the alfresco-global.properties

###############################
## Common Alfresco Properties #
## Enterprise overlay         #
###############################

dir.root=C:/Alfresco/V342/alf_data


web.application.context.url=http://localhost/alfresco

### database connection properties ###
db.username=alfresco
db.password=admin
db.name=alfresco
db.url=jdbc:mysql://localhost:3306/${db.name}?useUnicode=true&characterEncoding=utf8

db.schema.update=true
index.recovery.mode=AUTO

Copied the mysql directory over and the alf_data

any idea on where my issue is ?

Outcomes