topic Using Oracle DB in Alfresco Archive

Using Oracle DB

george_dobson — Wed, 20 Aug 2008 06:20:17 GMT

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 oneCannot load JDBC driver class 'oracle.jdbc.OracleDriver 'java.lan

Re: Using Oracle DB

janv — Wed, 20 Aug 2008 09:55:22 GMT

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

Re: Using Oracle DB

george_dobson — Thu, 21 Aug 2008 00:07:32 GMT

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?

Re: Using Oracle DB

janv — Fri, 22 Aug 2008 13:29:58 GMT

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