Announcement

Collapse
No announcement yet.

Mirth DataWriter does not connect with Oracle 11g

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mirth DataWriter does not connect with Oracle 11g

    Hi All,

    Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
    Mirth Connect Server 3.4.2.8129 64bit
    Java version: 1.8.0_111

    I am unable to connect to an Oracle Database 11g Express. I have installed Oracle Express Edition and the TNSNAMES.ORA contains an entry like this:
    XE = XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = username-txl.city.corp.company.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    I am using a Database Writer with connection string with the service name in the connection template (Javascript disabled):
    jdbcracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(H OST=username-txl.city.corp.company.com)(PORT = 1521))(CONNECT_DATA=(SERVICE_NAME=XE)))

    When i click on the insert=>get tables i do not get any errors and neither does the table list fetched. Same happens when i use the SID or DB name: xe using connection string:
    jdbcracle:thin:@username-txl.city.corp.company.com:1521:xe (or XE)

    I tested the connection string with a Database Reader (Javascript disabled) and on clicking Select button, it doesnt fetch the tables but if I use a SELECT statement it works. Just wanted to know why the fetching of tables doesn't work.

    As part of this question, I also wanted to know if Oracle data types like blob and XMLTypes are supported in Mirth Connect.


    Can anyone help me with this issues? Thanks in advance!
    Last edited by itsjohn; 11-01-2016, 11:44 AM.

  • #2
    So it IS connecting if you can run a select and get data. Am I missing something??

    Comment


    • #3
      Its connecting but the Mirth does not fetch the tables when I click on Get Tables in the database writer connector.

      I also wanted to know if Oracle data types like blob and XMLTypes are supported in Mirth Connect.

      Comment


      • #4
        I've been working with MC and databases for 5 years and I don't think I've ever seen the fetching "feature" work. LOL

        I'm also pretty sure I've used BLOBS before as well.

        Comment


        • #5
          Thanks! Just tried fetching a BLOB and it worked! Do you know how to insert a XMLType in Mirth Connect?

          Comment


          • #6
            Originally posted by itsjohn View Post
            Thanks! Just tried fetching a BLOB and it worked! Do you know how to insert a XMLType in Mirth Connect?
            I do not. I've not had to work with that yet.

            Comment


            • #7
              Has anyone used Oracle data type XMLTypes with Mirth Connect? Do they work with inserts? I would appreciate if you give a code snippet for it. Thanks!

              Comment


              • #8
                Not my answer. From the new Mirth Connect Slack Channel
                http://www.mirthcorp.com/community/f...d.php?t=216581




                hugosoares

                the easy way to do this is just create a statement like:

                "insert into table values (xmlType(?))"

                and then set the parameter like:

                stmt.setString(1, '<xml>Hi there</xml>')

                Comment


                • #9
                  Thanks for your reply!

                  That code doesnt work! The following error is thrown:
                  DETAILS: JavaException: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

                  Comment

                  Working...
                  X