Cannot load JDBC driver class

[abcdef987]

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

[kasmit44 · Accepted solution]

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.

[abcdef987]

That was it! Thanks!