Clovertech

SQL JDBC Database Connection

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › SQL JDBC Database Connection

  • Creator
    Topic
  • March 13, 2015 at 4:34 pm #54612
    Femina Jaffer
    Participant

      Hello Folks,

      When connecting to a SQL Server database via JDBC connection in CL (Database Configuration), is the username and password different then the windows authentication username and password?  

      I was able to get this to work at one point; but now I am using a different Server.  Do I need to set create a separate credentials?

      Please advise.  I have attached a screenshot.

      Thanks,

      Femina

    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • March 13, 2015 at 9:31 pm #82215
        Femina Jaffer
        Participant

          Okay, so I figured out that I needed the SQL login credentials independent of windows auth, and was able to connect and import the schema.  I have build two threads – Database Inbound and the other (outbound) protocol file.   I build a small translation two write three fields (hl7).  When I turn the thread on, I do not get any output.  Any Ideas?  I have attached the screen shots.

          Thank you,

        • March 24, 2015 at 3:28 pm #82216
          kirt noel
          Participant

            It appears the table schema is identical to the table name in your query.

            I suggest you confirm this is correct.

            You may be well served by simply using the most basic of queries without even referencing a table.

            In SQLServer I believe it would be something akin to:

            SELECT ‘Test Field 1’, ‘Test Field 2’, ‘Test Field 3’

            If you get this to work you can move onto querying a given table.

          • May 29, 2015 at 10:12 pm #82217
            Femina Jaffer
            Participant

              Thanks Kirt.  Sorry for the late response.  I did finally get that too work as it had to do with a silly user error by yours truly….I had the outbound tab checked in the inbound thread.  Anyway, it is working now.

              Trial and error 🙂

              Thanks!

            • June 3, 2015 at 3:21 pm #82218
              Femina Jaffer
              Participant

                Kirt,

                I am able to retrieve records from a table and write to a file.  However, this is a continuous read/write to the file as the thread is on.  I realized that it was doing this when I left the thread on over the weekend – I guess because the thread was constantly listening.  Would I need to write another query in the Read Success tabl?  Any ideas anyone?  suggestions?

                Thank you,

                Femina

              • June 5, 2015 at 3:22 pm #82219
                Femina Jaffer
                Participant

                  Got that working now.  The reason behind that was my update was not being called as I had to actually reference the entire database and table.  For example, UPDATE  [COMMON_DEV].[dbo].[ABQHP_HL7Output]

                  Thanks for your assistance!

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