Using Oracle DB

[george_dobson]

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=jdbcracle: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…

[janv]

I assume you're using Tomcat 5.5.x. Have you tried coping "ojdbc14.jar" file (you do not need "classes12.jar") into "…/tomcat/common/lib" directory ?

Regards,
Jan

[george_dobson]

Yes, it's Tomcat 5.5. Came with the alfresco-labs-tomcat-3a.1032.tar.gz download. And yes, I also copied ojdbc14.jar to ..common/lib, and several other ../lib directories (thought it couldn't hurt having it all over the place). Should I have CLASS_PATH or LD_LIBRARY_PATH environment vars set when starting Tomcat? I got it to work on the MySQL Database but we'd like to use Oracle.

Actually we have Tomcat 6 installed on the same server (separate directory and not running) and that would be the choice if we're going to put it in production but risking spending too much time trying to get that working , I've abandoned the WAR file only distribution in favour of getting something working to test the application functionality before worrying about the infrastructure.

Would it be wise to rather go down to Alfresco 2.1 at this stage if the plan was to put it in production and would that work with Oracle 10.2.0.1?

[janv]

Please double-check your custom-repository.properties, it looks as if you may have an extra space at the end of the db.driver … cut-and-paste from above:

Cannot load JDBC driver class 'oracle.jdbc.OracleDriver '‍

Regards,
Jan