I'm trying to use ApacheIgnite to make SQL queries.
Basically I can't connect to my port, which is in execution in docker IP:172.17.0.1 and my SQL port: 3606
POM configurations are the following:
Ignite-core:2.7.6
ignite-indexing: 2.7.6
mysql-connector-java: 8.0.17
private static Connection igniteConnection;
private static Statement sql;
private static ResultSet rs;
public static void main(String[] args) throws Exception
{
Class.forName("org.apache.ignite.IgniteJdbcThinDriver");
IgniteConfiguration conf = new IgniteConfiguration();
Ignite ignite = Ignition.start(conf);
igniteConnection = DriverManager.getConnection("jdbc:ignite:thin://localhost:3606/test;user=root;password=root");
sql = igniteConnection.createStatement();
sql.executeUpdate("CREATE TABLE Employee (" +
" id LONG PRIMARY KEY, name VARCHAR(30), country VARCHAR(30))");
PreparedStatement sql = igniteConnection.prepareStatement("INSERT INTO Employee (id, name, country) VALUES (?, ?, ?)");
sql.setLong(1, 1);
sql.setString(2, "James");
sql.setString(3, "EEUU");
sql.executeUpdate();
rs = sql.executeQuery("SELECT e.name, e.country FROM Employee");
while(rs.next()){
String name = rs.getString(1);
String country = rs.getString(2);
System.out.println(name+"\t"+country);
}
ignite.close();
igniteConnection.close();
rs.close();
}
}
Try to use 10800 to connect
By default, Ignite uses the following local ports: 10800 Default port for thin client connection
11211 Default JDBC port
47100 Default local communication port
47500 Default local discovery port
8080 Default port for REST API
49128 Default port for JMX connection
31100~31200 Default time server port
48100~48200 Default shared memory port