Intersystems Cache connect to MIRTH Error

Livi

unread,

Mar 4, 2016, 3:56:18 AM3/4/16

to Caché, Ensemble, DeepSee

Hi,

I tried to connect MIRTH with intersystems cache

The following Steps will be i done

1. Copy CacheDB.jar into lib/custom in your Mirth installation directory.
2. Edit conf/custom/dbdrivers.xml and add a line defining the driver class (see below):
3. Restart Mirth

</drivers>

When I select GET TABLES The Error will be showing

could not retrieve Database Meta data

I attached Screen shot of my Error any one Face this ISSUE ? Please Help...

Thanks advance

LIVI

MIRTHCONNECT.PNG

ERROR.PNG

Ron Sweeney

unread,

Mar 4, 2016, 7:28:08 AM3/4/16

to intersystems...@googlegroups.com

I have used these instructions to connect to Talend...

http://www.cachemonitor.de/intersystems-documentation-cache-jdbc-driver/

JDBC URL:

Driver Class = com.intersys.jdbc.CacheDriver

The URL syntax is

jdbc:Cache://machine:port/namespace

Mirth Driver would be:

<driver class="com.intersys.jdbc.CacheDriver" name="TRYCACHE" template="jdbc:Cache://127.0.0.1:1972/VISTA" />
</drivers>

-Ron

--
--
Caché, Ensemble, DeepSee

---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

RON SWEENEY | ARCHITECT | INTEGRATION REQUIRED

285 THIRD STREET | CAMBRIDGE, MA 02142

DIR: 616-303-1375 | MOB: 616-217-6516 | SKYPE: SWEEN6412

UPCOMING DAYS OUT OF THE OFFICE:

2/29 - 3/2 - HIMSS

4/11 - 4/14 - InterSystems Global Summit

PRIVILEGED AND CONFIDENTIAL: This document and the information contained herein are confidential and protected from disclosure pursuant to Federal law. This message is intended only for the use of the Addressee(s) and may contain information that is privileged and confidential. If you are not the intended recipient, you are hereby notified that the use, dissemination, or copying of this information is strictly prohibited. If you received this communication in error, please erase all copies of the message and its attachments and notify the sender immediately.

Infant Livingston

unread,

Mar 4, 2016, 2:01:19 PM3/4/16

to intersystems...@googlegroups.com

Hi Ron ,

I spend three days I do know what is issue
I configure correctly
Please tell if I change any steps

Thanks,
LIVI

Kevin Mayfield

unread,

Mar 4, 2016, 2:16:31 PM3/4/16

to Caché, Ensemble, DeepSee

Have you tried a odbc connection? Should be easier to setup and prove SQL is configured correctly in Caché.

Java/jdbc config looks correct.

Mikko Laitamäki

unread,

Mar 7, 2016, 2:21:50 AM3/7/16

to intersystems...@googlegroups.com

With newer Cache the jdbc driver is in different jar file, cachejdbc.jar.
Could this be the issue here?
-Mikko

4.3.2016, 14:28, Ron Sweeney kirjoitti:
>
> I have used these instructions to connect to Talend...
>
> http://www.cachemonitor.de/intersystems-documentation-cache-jdbc-driver/
>
> JDBC URL:
>

> DriverClass= com.intersys.jdbc.CacheDriver

>
> The URL syntax is
>
> jdbc:Cache://machine:port/namespace
>
> Mirth Driver would be:
>
> <driver class="com.intersys.jdbc.CacheDriver" name="TRYCACHE"
> template="jdbc:Cache://127.0.0.1:1972/VISTA

> <http://127.0.0.1:1972/VISTA>" />

> </drivers>
>
>
> When I select GET TABLES The Error will be showing
>
> could not retrieve Database Meta data
>
> I attached Screen shot of my Error any one Face this ISSUE ?
> Please Help...
>
>
>
> Thanks advance
>
> LIVI
> --
> --
> Caché, Ensemble, DeepSee
>
> ---
> You received this message because you are subscribed to the Google
> Groups "Caché, Ensemble, DeepSee" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to
> intersystems-publi...@googlegroups.com

> <mailto:intersystems-publi...@googlegroups.com>.

> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
> --
> RON SWEENEY | ARCHITECT | INTEGRATION REQUIRED
> 285 THIRD STREET | CAMBRIDGE, MA 02142
> DIR: 616-303-1375 | MOB: 616-217-6516 | SKYPE: SWEEN6412
>
> UPCOMING DAYS OUT OF THE OFFICE:
>
> 2/29 - 3/2 - HIMSS
> 4/11 - 4/14 - InterSystems Global Summit
>

> /*PRIVILEGED AND CONFIDENTIAL:* This document and the information

> contained herein are confidential and protected from disclosure
> pursuant to Federal law. This message is intended only for the use of
> the Addressee(s) and may contain information that is privileged and
> confidential. If you are not the intended recipient, you are hereby
> notified that the use, dissemination, or copying of this information
> is strictly prohibited. If you received this communication in error,
> please erase all copies of the message and its attachments and notify

> the sender immediately./

>
> --
> --
> Caché, Ensemble, DeepSee
>
> ---
> You received this message because you are subscribed to the Google
> Groups "Caché, Ensemble, DeepSee" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to intersystems-publi...@googlegroups.com

> <mailto:intersystems-publi...@googlegroups.com>.

> For more options, visit https://groups.google.com/d/optout.

--

Mikko Laitamäki
mikko.l...@mediware.fi 040-7772109

Livi

unread,

Mar 7, 2016, 2:48:06 AM3/7/16

to Caché, Ensemble, DeepSee

Hi MIKKO,

I am Paste cachejdbc.jar into lib/custom in My Mirth installation Directory

Still the same error will be come.

Thanks,

LIVI

Andreas

unread,

Mar 9, 2016, 3:01:31 AM3/9/16

to Caché, Ensemble, DeepSee

I think a good way to evaluate your connection string is to use a jdbc query tool first. As descriped in other posts above the connection string has to be start with "jdbc:Cache://" and not "jdbc:TRYCACHE://".

Andreas

Livi

unread,

Mar 9, 2016, 4:42:40 AM3/9/16

to Caché, Ensemble, DeepSee

Thanks All

Specifically Andreas,ronsween

now i solve the error

Sean Connelly

unread,

Mar 14, 2016, 11:02:19 AM3/14/16

to Caché, Ensemble, DeepSee

Hi Livi,

The name in the config is just for Mirth (for the drop down list), so putting TRYCACHE into the jdbc connection string as you have...

template="jdbc:TRYCACHE://127.0.0.1:1972/VISTA"

is probably your first problem, replace TRYCACHE with Cache, like this...

You did not mention which version of Mirth or Cache you are using?

It could be that you are also using an older version of the driver, its been mentioned above a few times.

I have a driver here, cachejdbc.jar that is dated 2013 and is working fine for me in Mirth.

This is not a fix, but you might also want to add a select Limit...

without this, the "Get Tables" button might take a while on a large Vista database, as it might have to traverse each and every table, and not just the first row from each table (to get the table meta data).

If you are at the evaluation stage of Mirth, then I would recommend looking at Ensemble / Healthshare as well. Mirth can be hard-work to scale. I know because I have replaced Mirth with Ensemble at several Hospitals now because Mirth was running out of steam.

Sean.

Infant Livingston

unread,

Mar 17, 2016, 11:41:35 AM3/17/16

to intersystems...@googlegroups.com

Ok seen thanks for your replay
I love that error

--

--
Caché, Ensemble, DeepSee

---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.

To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.

Kevin Mayfield

unread,

Mar 17, 2016, 4:06:19 PM3/17/16

to Caché, Ensemble, DeepSee

Agree about using ensemble over mirth, most of our poor performing interfaces are mirth.

If your after open source have a look at Apache camel - it also uses the HAPI libs like mirth. Had no problems with ensemble hammering it. We use camel to do small integration tasks with ensemble at the hub orchestrating them.

Reply all

Reply to author

Forward