如何在Jaspersoft Studio中设置InterSystems缓存数据源 [英] How do I setup an InterSystems Cache Data Source in Jaspersoft Studio

问题描述

我正在尝试建立与Intersystems Cache数据源的新JDBC连接，而我正努力知道是否可以完成.

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.

由于JDBC驱动程序下拉列表中没有系统间缓存"选项，因此我手动添加了驱动程序字符串-> com.intersys.jdbc.CacheDriver

Since there was no Intersystems Cache option in the JDBC driver drop down, I added the driver string manually -> com.intersys.jdbc.CacheDriver

然后我以以下格式手动添加URL-> jdbc:Cache://123.123.123.123:12345/namespace

I then added the URL manually in the following format -> jdbc:Cache://123.123.123.123:12345/namespace

我还找到了JDBC驱动程序并将其添加到Jar文件路径-> cachedb.jar

I also found the JDBC driver and have added it to the Jar File Path -> cachedb.jar

基于错误消息，我想知道是否甚至可以使用JDBC连接器连接到系统间数据库.你怎么认为?

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?

当我尝试连接时，出现以下错误:

例外，如果您想查看更多信息，请查看详细信息. 原因:java.lang.ClassNotFoundException:net.sf.jasperreports_6.2.1.final

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

详细信息:

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

我已经在JasperReports社区页面上问过这个问题，但是那里没有太多活动.

I have asked this on the JasperReports community page, but it doesn't get much activity on there.

推荐答案

您说找到了cachedb.jar，但是应该使用cachejdbc.jar这个文件，您可以在dev/java/lib/JDK(17 | 18 )在InterSystems安装文件夹中
文档

You say that you found cachedb.jar, but you should use cachejdbc.jar this file you can find at dev/java/lib/JDK(17|18) in InterSystems installation folder
Documentation

这篇关于如何在Jaspersoft Studio中设置InterSystems缓存数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！