title: how to resolve org.apache.commons.dbcp.SQLNestedException
body: <p>I am using hsqldb standalone as my database. i have a <code>hsqldb.jar(hsqldb-2.0.0)</code> which i added on my project build path so my project will find out where is my <code>hsqldb.jar</code>. i am using spring with these. my spring bean is:</p>
  
  <pre><code>&lt;beans xmlns="http://www.springframework.org/schema/beans"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:context="http://www.springframework.org/schema/context"
      xsi:schemaLocation="
          http://www.springframework.org/schema/beans
          http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
          http://www.springframework.org/schema/context
          http://www.springframework.org/schema/context/spring-context-3.0.xsd"&gt;
  
      &lt;bean id="sqlMapClient"
          class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"&gt;
  
          &lt;property name="dataSource"&gt;
              &lt;ref local="adapterDataSource" /&gt;
          &lt;/property&gt;
  
  
          &lt;property name="configLocation"
              value="classpath:/com/hsqldb/example/dao/ibatis/SqlMapConfig.xml" /&gt;
  
  
      &lt;/bean&gt;
  
      &lt;bean id="adapterDataSource"
          class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close"&gt;
          &lt;property name="driverClassName" value="org.hsqldb.jdbcDriver" /&gt;
          &lt;property name="url" value="data/db/hsqldb.jar" /&gt;
          &lt;property name="username" value="SA" /&gt;
          &lt;property name="password" value="password" /&gt;
      &lt;/bean&gt;
      &lt;bean id="testingDao" class="com.hsqldb.example.dao.TestingDao"
          init-method="setTestDao" depends-on="moodleAuthenticationDetails"&gt;
          &lt;property name="sqlMapClient"&gt;
              &lt;ref local="sqlMapClient" /&gt;
          &lt;/property&gt;
  
      &lt;/bean&gt;
      &lt;bean id="moodleAuthenticationDetails"
          class="com.hsqldb.example.HsqlDBAuthentication"&gt;&lt;/bean&gt;
  &lt;/beans&gt; 
  </code></pre>
  
  <p>and i have a method which will return me a data source which is as below :</p>
  
  <pre><code>public static DataSource getDataSource(String filePath){
          String url;
          //url="jdbc:hsqldb:file:"+filePath;
          url = "jdbc:hsqldb:file:D:/EclipseWorskpace/ew-pg/lmexadapter/hsqldb-example/src/main/webapp/WEB-INF/data/db/hsqldb.jar";
          BasicDataSource basicDataSource = new BasicDataSource();
          basicDataSource.setUsername("SA");
          basicDataSource.setPassword("password");
          basicDataSource.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
  //      basicDataSource.setUrl("jdbc:mysql://IP/moodle");
          basicDataSource.setUrl(url);
          System.out.println("$$$$$$$$ URL is : " + url);
          return basicDataSource;
      }
  </code></pre>
  
  <p>but while running my test case by junit test it's giving me an exception :</p>
  
  <pre><code>org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.hsqldb.jdbcDriver' for connect URL 'data/db/hsqldb.jar'
      at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1273)
      at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1192)
      at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:884)
      at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
      at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:213)
      ... 35 more
  Caused by: java.sql.SQLException: No suitable driver
      at java.sql.DriverManager.getDriver(DriverManager.java:264)
      at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1266)
      ... 39 more
  </code></pre>
  
  <p>please help to resolve this.</p>
  
  <p>Thank you</p>