Cannot create JDBC driver of class '' for connect URL 'null' Oracle

Question

I know this questions has been asked before but the answers does not addressing the problem in my case.

http://stackoverflow.com/questions/11516747/cannot-create-jdbc-driver-of-class-for-connect-url-null-i-do-not-underst

The answer selected by the user talks about the different approach, With the help of the suggested approach my application is working fine but I am want to do it in below manner.

Wanted to put my JNDI xml file containing db connection details in

 tomcat\7.0\conf\Catalina\localhost

and when I am running the tomcat from command prompt It should make a connection with the database. In this case my xml file name is application.xml. Running application from command prompt giving me error as

Cannot create JDBC driver of class '' for connect URL 'null' Oracle

Steps I have tried:

below is the XML file created JNDI resource:

`

 <?xml version="1.0" encoding="UTF-8"?>
    <Context path="/application" reloadable="false">
    <Logger className="org.apache.catalina.logger.FileLogger" prefix="application." suffix=".log" timestamp="true"/>
    <Resource name="jdbc/application" 
    factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
    auth="Container"
    type="javax.sql.DataSource" 
    username="abc"
    password="abc"
    driverClassName="oracle.jdbc.driver.OracleDriver"
    url="jdbc:oracle:thin:@<<server_address>:1522:<<sid>>"
    maxActive="20" maxWait ="10000" maxIdle="10"/>             
    </Context>

` with the information

web.xml have a entry for the above resource as

`<resource-ref>
    <description>Connection Pool</description>
    <res-ref-name>jdbc/application</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

`

Put ojdbc6.jar file in tomcat/lib folder.

I am making sure that I have not put ojdbc6.jar in both tomcat and my project and I am using oracle 12c as a database.

did you try to add '//' like this jdbc:oracle:thin:@//<:1522/<> ? — vincent, Sep 21 '15 at 16:11
12c multitenant? If it is a pluggable db do not use SID. Instead use SERVICE_NAME @hostname:1522/SERVICE_NAME. By the way, always use SERVICE_NAME. Always. — Bjarte Brandt, Sep 21 '15 at 16:58
can you show your java code where you are creating connection? — swapyonubuntu, Sep 21 '15 at 17:17
@BjarteBrandt: As suggested, Tried with service name also...but getting the same error. — Damon, Sep 22 '15 at 09:49
@swapyonubuntu: The problem is not how i am making the connection, since application is working fine when i am creating the "context.xml " inside Meta-inf folder. — Damon, Sep 22 '15 at 09:50

score 0 · Accepted Answer · answered Sep 22 '15 at 12:02

The issue was with the filename. My application WAR name was "TomcatExample.war" and xml name was "tomcatexample.xml" It is case sensitive in tomcat 7 and that is the reason it was not picking up the file. Changes to "TomcatExample.xml" works for me. Thank you so much all for your help. Cheers!!!

Cannot create JDBC driver of class '' for connect URL 'null' Oracle

1 Answers1