[Using Sakai] Need help to configure sakai CLE 2.7 to connect to oracle

[Anand Mehta]

Hi Chandrika,

Make sure you have Oracle JDBC driver in Tomcat's common/lib directory.


 Thanks,
Anand




________________________________
From: Chandrika Harathi <harathch at umdnj.edu>
To: sakai-user at collab.sakaiproject.org
Sent: Tue, February 1, 2011 11:04:44 AM
Subject: [Using Sakai] Need help to configure sakai CLE 2.7 to connect to oracle

Hi,

I just try to install Sakai binary distribution on Redhat enterprise
Linux 5.6 and using Oracle database. I copied the sample file
sakai.property (
https://source.sakaiproject.org/svn/config/branches/sakai-2.7.x/configuration/bundles/src/bundle/org/sakaiproject/config/bundle/sample.sakai.properties

)in $CATALINA_HOME/sakai/, then edit it to connect to Oracle. Starting
tomcat failed with the error

Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:186)
        at 
org.apache.commons.dbcp.SakaiBasicDataSource.createDataSource(SakaiBasicDataSource.java:129)

        at 
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at 
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:254)

        at 
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1214)
        at 
org.sakaiproject.db.impl.BasicSqlService.dbWriteFailQuiet(BasicSqlService.java:1115)

        at 
org.sakaiproject.db.impl.BasicSqlService.ddl(BasicSqlService.java:2055)
        at 
org.sakaiproject.db.impl.BasicSqlService.init(BasicSqlService.java:227)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:616)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)

        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)





Thanks for your help!





> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
> 
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org 
>with a subject of "unsubscribe"
> 

-- Chandrika Harathi
Programmer Analyst II
IST-AST
1 Worlds Fair Drive, Suite 3900, Somerset, NJ 08873
Ph: (732) 743-2554
Fax:(732) 745-4525


CONFIDENTIALITY NOTICE: This email communication may contain private, 
confidential, or legally privileged information intended for the sole use of the 
designated and/or duly authorized recipient(s). If you are not the intended 
recipient or have received this email in error, please notify the sender 
immediately by email and permanently delete all copies of this email including 
all attachments without reading them. If you are the intended recipient, secure 
the contents in a manner that conforms to all applicable state and/or federal 
requirements related to privacy and confidentiality of such information.


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20110201/5245a12b/attachment-0001.html