Expand my Community achievements bar.

Nomination window for the Adobe Community Advisor Program, Class of 2025, is now open!
SOLVED

Cannot load JDBC driver class

Avatar

Former Community Member

Hi,

I've successfully installed Flash Builder 4 (FlashBuilder_4_LS10.exe) with Data Model plugin (Adobe_Application_Modeling_plugin_v102_eclipse35.zip). On my local pc (XP Professional) I'm running tomcat with LS (lcds31-win.exe). I can run all the examples but when I try to add oracle DB as a data service I keep getting
"Data source not found: java:/comp/env/jdbc/ORCL"
"Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver"

I copied ojdbc6.jar (tried ojdbc5.jar as well, but to no avail) into C:\lcds\tomcat\webapps\lcds-samples\WEB-INF\lib directory. I also uncommented RDS servlets in C:\lcds\tomcat\webapps\lcds-samples\WEB-INF\web.xml and changed useAppserverSecurity to false. Finally I added the following to C:\lcds\tomcat\conf\Catalina\localhost\lcds-samples.xml:

    <Resource name="jdbc/PUF" type="javax.sql.DataSource"
        driverClassName="oracle.jdbc.driver.OracleDriver"
        maxIdle="2" maxWait="5000"
        url="jdbc:oracle:thin:@oradbsrv:1521:ORCL" username="atest" password="aaa123" maxActive="4"
    />           

Any idea what I could be missing or doing wrong?

Thanks,
Julius

Add topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 2

I have an Oracle datasource running in LCDS31 from lcds-samples.  I have my Oracle driver in tomcat/lib not WEB-INF/lib.  I am connecting to an Oracle 10.2 server.  I also am running the odbc14.jar

I would start by moving your driver to tomcat/lib.  Try ojdbc5.jar first.  I believe I went back to ojdbc14 because the newer drivers were not working.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

I have an Oracle datasource running in LCDS31 from lcds-samples.  I have my Oracle driver in tomcat/lib not WEB-INF/lib.  I am connecting to an Oracle 10.2 server.  I also am running the odbc14.jar

I would start by moving your driver to tomcat/lib.  Try ojdbc5.jar first.  I believe I went back to ojdbc14 because the newer drivers were not working.

Avatar

Former Community Member

That was it! Thanks!