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

[raj jaiswal]

Hello everyone,


I want to create connection object inside tomcat .I am using SQL2005.But i am gettting error like

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

Please anyone help me.
My Code is

this is my class

public class ConnectionFactory {
	
	private static ConnectionFactory instance;
	protected ConnectionFactory() {
	}
	public static ConnectionFactory getMSSQLFactory(){
		if(instance == null) 
			instance = new ConnectionFactory();
		return instance;
	}
	public Connection createConnection()throws SQLException, NamingException{
		Context ctx = new InitialContext();
		Context env  = (Context)ctx.lookup("java:comp/env");//"java:comp/env";

		DataSource ds = (DataSource)env.lookup("jdbc/Ilastic");// "jdbc/suntyre";
		Connection con = ds.getConnection();
		return con;
	}
	public Connection getConnection() throws SQLException, NamingException{
		
		
		return createConnection();
	}
}

inside tomcat context.xml i have put that code.
C:\Program Files\Apache Software Foundation\Tomcat 5.5\conf\context.xml

<!-- The contents of this file will be loaded for each web application -->
<Context>

    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
	
    <!-- Uncomment this to disable session persistence across Tomcat restarts -->
    <!--
    <Manager pathname="" />



    -->



<Resource name="jdbc/Ilastic" auth="Container"
		type="javax.sql.DataSource" 
		removeAbandoned="true"
		removeAbandonedTimeout="30"
		maxActive="100"
		maxIdle="30" 
		maxWait="10000" 
		username="sa"
		password="sa"
		driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
		url="jdbc:sqlserver://10.10.5.88:1433;Database=Ilastic Development;"/>


</Context>

	
		System.out.println("hello");
		TestConnectionForm testConnectionForm=(TestConnectionForm)form;
		String username=testConnectionForm.getUser_id();
		String password=testConnectionForm.getPassword();
		System.out.println("hello");
		
		ConnectionFactory db;
		
		Connection con=null;
		Statement stmt=null;
	
		ResultSet rs=null;
		String str=	"select * from login_test where login_id='"+username+"' and password='"+password+"'";
		try
		{
			db=ConnectionFactory.getMSSQLFactory();
			con=db.getConnection();
			
			stmt=con.createStatement();
			
			rs=stmt.executeQuery(str);

			if(rs.next())
			   {
			
				username=rs.getString(1);
		  	
			}
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		
		}finally {
			try {
				rs.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				con.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}


		return mapping.findForward("success");
	}

}

this is web.xml where i put that code

 <resource-ref>
    <description>
      Resource reference to a factory for java.sql.Connection
      instances that may be used for talking to the database
      that is configured in server.xml.
    </description>
    <res-ref-name>jdbc/Ilastic</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

thanks

Raj jaiswal.
MCA SCJP6.0

[amit punekar]

Hi,
Have you placed the required SQL 2005 database driver JAR file in <<tomcat.home>>/lib directory.

You might find this useful.

Regds,
Amit

[raj jaiswal]

hi amit punekar ,
Thanks for reply.
But I have already put driver jar inside tomcat lib .
So please tell me solution.
Thanks in advance
Raj

[Jan Cumps]

I have moved this post to our Tomcat forum for you.

[Misha Ver]

raj jaiswal wrote:hi amit punekar ,
Thanks for reply.
But I have already put driver jar inside tomcat lib .
So please tell me solution.
Thanks in advance
Raj

Where exactly you put jar file? It should be $CATALINA_HOME/common/lib for Tomcat 5, not $CATALINA_HOME/lib

[raj jaiswal]

hello everyone,

Still i am getting below error. Could you please solve it .

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at com.lara.ConnectionFactory.createConnection(ConnectionFactory.java:26)
	at com.lara.ConnectionFactory.getConnection(ConnectionFactory.java:32)
	at com.lara.TestConnection.execute(TestConnection.java:41)
	at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
	at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
	at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:735)
Caused by: java.lang.NullPointerException
	at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:515)
	at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:484)
	at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
	at java.sql.DriverManager.getDriver(DriverManager.java:373)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
	... 29 more
java.lang.NullPointerException
	at com.lara.TestConnection.execute(TestConnection.java:60)
	at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
	at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
	at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:735)
java.lang.NullPointerException
	at com.lara.TestConnection.execute(TestConnection.java:66)
	at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
	at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
	at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:735)

Thanks in advance.
Raj jaiswal

[raj jaiswal]

hi Misha ,
Thanks for reply.

Where exactly you put jar file? It should be $CATALINA_HOME/common/lib for Tomcat 5, not $CATALINA_HOME/lib

I have put driver jar file that location C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\sqljdbc4.jar.

please find the Solution.


Thanks

[raj jaiswal]

Hi all,


Still i am waiting for solution.

please anybody solve it.



Thanks

[Tim Holloway]

raj jaiswal wrote:
please anybody solve it.

Raj, the way the JavaRanch works is that people don't pay us, and we don't solve things. We help people solve things, and - since we don't get paid, it may sometimes take some time before someone who can help gets online.

The important part of your error message is "driver of class ''". There's an empty string where the classname should be in that message, so somehow you've mis-specified part of your database connection pool definition. To be able to tell you more than that, I'd have to take time away from things I do get paid to do, but I can say that overall, it looks like you're doing everything right. Except, obviously for the 5% of the work that's going to take 95% of the time. Which, sadly is how it usually goes for all of us.

Anyway, do a fine-grained comparison of your application Context database pool definition against the Tomcat docs with special attention to the driver class and JDBC URL and I think you'll find your problem.

[raj jaiswal]

Hi Tim,

quote] please anybody solve it.

Sorry for this ,But this is not mean i am forcefully saying you have to solve it .I wrote please anybody solve it .So please don't take wrong meaning.I know we don't pay at all .anyway If you are hurted by my words i saying sorry for that.


Thanks.
Raj jaiswal

[amit punekar]

Hi again,
Upon looking again at your configuration

url="jdbc:sqlserver://10.10.5.88:1433;Database=Ilastic Development;"

Can you check if we really need the ";" in the above URL?
I did not remember I putting it when I connected to Oracle. This might be even correct for the database you are using but just noticed this.

regds,
amit

[raj jaiswal]

thanks all of you,

I have solved this problem by the help of javaranch team.
The problem was i kept this code

<resource-ref>   
    <description>   
      Resource reference to a factory for java.sql.Connection   
      instances that may be used for talking to the database   
      that is configured in server.xml.   
    </description>   
    <res-ref-name>jdbc/Ilastic</res-ref-name>   
    <res-type>javax.sql.DataSource</res-type>   
    <res-auth>Container</res-auth>   
  </resource-ref>  

inside context.xml but we need to keep inside server.xml
now my program is working fine.

Thanks once again
Raj jaiswal
MCA SCJP1.6

[Tim Holloway]

raj jaiswal wrote:thanks all of you,

I have solved this problem by the help of javaranch team.
The problem was i kept this code

<resource-ref>   
    <description>   
      Resource reference to a factory for java.sql.Connection   
      instances that may be used for talking to the database   
      that is configured in server.xml.   
    </description>   
    <res-ref-name>jdbc/Ilastic</res-ref-name>   
    <res-type>javax.sql.DataSource</res-type>   
    <res-auth>Container</res-auth>   
  </resource-ref>  

inside context.xml but we need to keep inside server.xml
now my program is working fine.

Thanks once again
Raj jaiswal
MCA SCJP1.6

Actually, that's not true. Normally you would put it in server.xml if you wanted the connection pool to be common to multiple webapps, and you would put it in a context.xml if you wanted to it to be in a single webapp.

If you put it in both places, that could be a conflict. You can also get a conflict if you created a META-INF/context.xml file in your WAR and also had defined a context XML file in the TOMCAT_HOME/conf/Catalina/localhost directory. Finally, just to make life really challenging, if you change a WAR file and re-deploy it, you must delete the exploded version of the previous WAR file if it is present in the TOMCAT_HOME/webapps directory because if you do not, not only will you have out-of-date database connections, you will have out-of-date code and data resources!