You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by Ryan Samo <on...@gmail.com> on 2018/04/06 15:53:27 UTC

ODBC and JDBC on same Ignite Cluster

Hey guys and gals,
Is it possible to use ODBC and JDBC connections on the same Ignite cluster
in version 2.4? I see that the
org.apache.ignite.configuration.OdbcConfiguration class was deprecated as of
2.1 in favor of 
 ClientConnectorConfiguration and
IgniteConfiguration.setClientConnectorConfiguration(ClientConnectorConfiguration).
I usually have JDBC connections come in on the default 10800 and would like
to add another port for ODBC alongside this one, say 10801. The
ClientConnectorConfiguration class allows for a port range so I tried to use
the following configuration but I am not having any luck. 


<property name="clientConnectorConfiguration">
    <bean
class="org.apache.ignite.configuration.ClientConnectorConfiguration">
        <property name="host" value="127.0.0.1"/>
        <property name="port" value="10800"/>
        <property name="portRange" value="2"/>
    </bean>
</property>

Any tips would be appreciated.

Thanks!



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ODBC and JDBC on same Ignite Cluster

Posted by Ryan Samo <on...@gmail.com>.

It does work as you described. Both JDBC and ODBC use the same 10800 port be
default unless you override it with ClientConnectorConfiguration. Thanks
again!



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ODBC and JDBC on same Ignite Cluster

Posted by Ryan Samo <on...@gmail.com>.

Thanks for the clarification Denis, I will give that a try!



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ODBC and JDBC on same Ignite Cluster

Posted by Denis Mekhanikov <dm...@gmail.com>.

Ryan,

There can only be one client connector on one node. And both JDBC and ODBC
can use the same port.
So, there is no need to configure anything, you can just connect to the
port 10800 from JDBC or ODBC, Ignite will figure out, which one it is.
ConnectorConfiguration is useful if you want to change the default port,
for example.

Denis

пт, 6 апр. 2018 г. в 18:53, Ryan Samo <on...@gmail.com>:

> Hey guys and gals,
> Is it possible to use ODBC and JDBC connections on the same Ignite cluster
> in version 2.4? I see that the
> org.apache.ignite.configuration.OdbcConfiguration class was deprecated as
> of
> 2.1 in favor of
>  ClientConnectorConfiguration and
>
> IgniteConfiguration.setClientConnectorConfiguration(ClientConnectorConfiguration).
> I usually have JDBC connections come in on the default 10800 and would like
> to add another port for ODBC alongside this one, say 10801. The
> ClientConnectorConfiguration class allows for a port range so I tried to
> use
> the following configuration but I am not having any luck.
>
>
> <property name="clientConnectorConfiguration">
>     <bean
> class="org.apache.ignite.configuration.ClientConnectorConfiguration">
>         <property name="host" value="127.0.0.1"/>
>         <property name="port" value="10800"/>
>         <property name="portRange" value="2"/>
>     </bean>
> </property>
>
> Any tips would be appreciated.
>
> Thanks!
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>