3 Replies Latest reply on Jan 27, 2011 6:30 AM by rareddy

    What are differences of JDBC connections with port 31000 and port 31443?

    meltedmetal

      Hi all,

       

      I am use the Teiid7.2 Final with default port configuration.

      17:25:12,282 INFO  [RUNTIME] Teiid JDBC =  mm://localhost:31000
      17:25:12,282 INFO  [RUNTIME] Teiid Admin mm://localhost:31443
      

       

      I found that I can create a JDBC connection with below two kinds of URLs with different port:

      One way is

      jdbc:teiid:vdbName@mm://hostname:31443
      

      Another is

      jdbc:teiid:vdbName@mm://hostname:31000
      

       

      Is there any differences of those two kinds of JDBC connections?

       

      I read below content in document of teiid_client_developers_guide.pdf

      1.5.1. Fail Over
      Post connection fail over will be sued if you're using an admin connection (such as what is used
      by AdminShell) or if the autoFailover connection property is set to true. Post connection failover
      works by sending a ping, at most every second, to test the connection prior to use. If the ping fails,
      a new instance will be selected prior to the operation being attempted. This is not true "transparent
      application failover" as the client will not restart the transaction/query/recreate session scoped
      temp tables, etc. So this feature should be used with caution by non-admin connections.
      

       

      What is the admin connection? What is the non-admin connection?

      I think that:

      a JDBC connection with port 31443 is a admin connection

      and a JDBC connection with port 31000 is non-admin connection.

       

      Is it right?

       

      Thank you.



       


        • 1. What are differences of JDBC connections with port 31000 and port 31443?
          rareddy

          S.Q.R,

           

          Teiid offers two separate connections for JDBC and Administration.

           

          JDBC: With default port on 31000, is used to make JDBC connections to Teiid VDB to issue SQL queries. The URL format for this is "jdbc:teiid:vdb@mm://host:port"

           

          Admin: With default port on 31443, is used to make admin connections that can be used to make administrative calls to Teiid Server. Like deploying a VDB, creating a data source or checking current sessions etc. For more information about all the supported admin calls check out "org.teiid.adminapi.Admin" class. The URL format for this is "mms://host:port". "mms" instead of "mm" for protocol because this is a secure connection using anonymous SSL by default.

           

          I know that the above two URLs you provided in your post work currently in 7.2, however starting 7.3, they will not work. Only respective connections will be awarded on given ports.

           

          There is some confusion introduced by Designer in creating these connections from Designer to Teiid server (it does not make explicit that which connection you are making), however these issues are now fixed and will be part of forth coming 7.2 Designer to be released very very soon (like this week).

           

          Ramesh..

          • 2. What are differences of JDBC connections with port 31000 and port 31443?
            meltedmetal

            Thanks for your clean answer.

            • 3. What are differences of JDBC connections with port 31000 and port 31443?
              rareddy

              Designer 7.2-Final is now released, I highly recommend this version as this fixes lots of issues related to above.

               

              Ramesh..