-
1. What are differences of JDBC connections with port 31000 and port 31443?
rareddy Jan 24, 2011 9:06 AM (in response to meltedmetal)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 Jan 26, 2011 10:44 PM (in response to rareddy)Thanks for your clean answer.
-
3. What are differences of JDBC connections with port 31000 and port 31443?
rareddy Jan 27, 2011 6:30 AM (in response to meltedmetal)Designer 7.2-Final is now released, I highly recommend this version as this fixes lots of issues related to above.
Ramesh..