title: How do I setup an InterSystems Cache Data Source in Jaspersoft Studio
body: <p>I am trying to set up a new JDBC connection to an Intersystems Cache data source, and I'm struggling to know if it can even be done.  </p>
  
  <p>Since there was no Intersystems Cache option in the JDBC driver drop down, I added the driver string manually -> <strong>com.intersys.jdbc.CacheDriver</strong>  </p>
  
  <p>I then added the URL manually in the following format -> <strong>jdbc:Cache://123.123.123.123:12345/namespace</strong>  </p>
  
  <p>I also found the JDBC driver and have added it to the Jar File Path -> <strong>cachedb.jar</strong>  </p>
  
  <p>Based on the error message, I am wondering if it's even possible to connect to intersystems databases with the JDBC connector. What do you think? </p>
  
  <p><strong>When I try to connect, I get the following error:</strong></p>
  
  <p>Exception, if you want to see more information look into the details.
  Reason: java.lang.ClassNotFoundException: com.intersys.jdbc.CacheDriver cannot be found by net.sf.jasperreports_6.2.1.final</p>
  
  <p><strong>The Details:</strong></p>
  
  <pre><code>net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: com.intersys.jdbc.CacheDriver cannot be found by net.sf.jasperreports_6.2.1.final
  
  at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:173)
  at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)
  at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)
  at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:162)
  at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:59)
  at java.lang.Thread.run(Thread.java:745)
  Caused by: java.lang.ClassNotFoundException: com.intersys.jdbc.CacheDriver cannot be found by net.sf.jasperreports_6.2.1.final
  at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:439)
  at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:352)
  at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:344)
  at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:160)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
  at java.lang.Class.forName0(Native Method)
  at java.lang.Class.forName(Class.java:348)
  at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:174)
  at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:145)
  ... 5 more
  </code></pre>
  
  <p>I have asked this on the JasperReports community page, but it doesn't get much activity on there. </p>