AnsweredAssumed Answered

Using Oracle DB

Question asked by george.dobson on Aug 20, 2008
Latest reply on Aug 22, 2008 by janv
I need help setting Alfrsco up to use an Oracle 10.2.0.1 database.

When I start the Tomcat webserver I get the following:

[size=85]15:28:57,418  WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
Cannot load JDBC driver class 'oracle.jdbc.OracleDriver '
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1359)


        … 57 more
Aug 20, 2008 3:29:00 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Aug 20, 2008 3:29:00 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.[/size]

I've set up my custom-repository.properties to be:
[size=85]db.name=alfresco
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100
db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@<server>:1521:<SID1>[/size]


and  hibernate dislect:
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

and I also copied the classes12.jar and ojdbc14.jar to almost every directory that hints of ../lib

Don't know what more to do…

Outcomes