has anyone installed jdbc to use instead of cloverleaf odbc

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf has anyone installed jdbc to use instead of cloverleaf odbc

  • Creator
    Topic
  • #48384
    Nancy McDaniel
    Participant

      We are wanting to take a couple of fields from an HL7 message and pass them to a stored procedure that will update an Informix db with the information passed.

      We have found out that the odbc piece of cloverleaf is an add on and we are trying to find out what it will provide us.  

      It seems like we could use jdbc which we can get for free and call it via java from the engine.  Has anyone done this or have an idea of why we would be better off going with the odbc add on.  The quote was fairly high considering that there are lots of free odbc drivers out there and I am having difficulty trying to justify the cost.

      I would appreciate thoughts on both, cloverleaf odbc vs using jdbc.

      thanks,

      Nancy

    Viewing 4 reply threads
    • Author
      Replies
      • #58476
        Scott Folley
        Participant

          I have not tried it from within the engine (I intend to do that but have not had the time).  I have done it from outside the engine and was able to make connection to our sybase database via jdbc (no great surprise there).  I can see nothing in the java upoc’s that would prevent it from working equally well within the engine.  With that in mind, I can see no reason to purchase the odbc driver if you have the java expertise necessary.

        • #58477
          Rick Martin
          Participant

            Hi Nancy,

            Another possibility is to look for an Informix TCL extension.  I’m currently using an Oracle TCL extension (OraTCL) in several places and it works great.

            Rick

          • #58478
            garry r fisher
            Participant

              Hi,

              Quick 2 cents worth…

              Quovadx provide an extension to Tcl that allows ODBC calls to be made using the Tcl language. The package also includes a set of ODBC drivers from Data Direct (Merant). If you use Tcl then this is a good option and we use it at a number of different hospital sites.

              On the other hand if you are using Java for your upocs then JDBC is a good option because there is no need to purchase the extension library from Quovadx but you will need to either find a free or open source JDBC driver or purchase one.

              I haven’t used JDBC is Cloverleaf because we have standardised on Tcl for our upocs and when you purchase the library to also purchase support which was very useful when we first started. Having said that I use Java and JDBC for my personal projects and I’m quite happy with the features and performance.

              Regards

              Garry

            • #58479
              Anonymous
              Participant

                Hello Rick,

                I’m a new user on  Cloverleaf. I want to use Oratcl to retrieve data and send them to a simple file.

                Do you have a example proc that is doing that ? And where do you use it in Cloverleaf ?

                Thanks a lot.

                Regards,

                Rick Martin wrote:

                Hi Nancy,

                Another possibility is to look for an Informix TCL extension.  I’m currently using an Oracle TCL extension (OraTCL) in several places and it works great.

                Rick

              • #58480
                Ga
                Participant

                  Hi Mikael ,

                  We use Cloverleaf 5.4 Rev 1 with WinXP for the client and Aix 5.2 (Unix) for the server and using Oratcl and it’s working great. But you willl need to do a specific setup to use Oratcl. I can send you and example of TCL proc if you contact me directly to my email address : gaetan.michaud.chum@ssss.gouv.qc.ca

                  That proc read and update in Oracle database.

                  Bye

                  Ga

              Viewing 4 reply threads
              • The forum ‘Cloverleaf’ is closed to new topics and replies.