SnappyData-1.3.0 JDBC connection is not working. #1569
Description
Connecting to JDBC from client gives below error:
java.sql.SQLException: (SQLState=40XD0 Severity=30000) ([hostname[1527]]) Container has been closed or has moved from 'hostname[1528]' {failed after trying all available servers: {hostname[1528]=hostname[1528], 10.49.3.107[1528]=10.49.3.107[1528], hostname[1527]=DEV-BDSP-Worker-07[1527]}, secondary-locators=[hostname[1528]]}.
Where as connection works if we run the program locally.
Below is the code snippet.
`try
{
private static final String JDBC_URL = "jdbc:snappydata://%1$s:%2$s/";
Connection connection = DriverManager.getConnection(String.format(JDBC_URL, "ip", "1527"));
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(
"select IMSI,MSISDN,IMEI,LMPARTNAME,LATITUDE,LONGITUDE,UNCERTAINTY,DATEPART,EVENTNAME,CELLID,RATNAME,CARRIER,SUBSCRIBERTYPE,SUBEVENTNAME,BPARTY,DOMAIN,MSC,MME,SGSN,MCCNAME,MAC from SA_bdspInternal_1640846360399");
while(rs.next()){
String a = rs.getString("IMSI");
System.out.println(a);
}
connection.close();
}
catch (SQLException ex)
{
ex.printStackTrace();
}`
1.Tried with both 1527 and 1528 ports.
2.Please find the below locator log
21/12/30 04:44:36.961 PST main<tid=0x1> INFO LocatorImpl: Starting Thrift locator on: DEV-BDSP-Worker-07/10.49.3.107[1527]
21/12/30 04:44:37.038 PST main<tid=0x1> INFO LocatorImpl: Started Thrift locator (Compact Protocol) on: DEV-BDSP-Worker-07/10.49.3.107[1528]
It is trying to start Locator on port 1527 as well as 1528
3.Connection used to work with snappydata-1.1.0.
4.Connection on same machine works if we switch to SnappyData 1.1.0.
5.OS info as below
NAME="Red Hat Enterprise Linux Server"
VERSION="7.7 (Maipo)"
6.Another observation in new snappydata is clicking on members on 5050 UI gives below error:
HTTP ERROR 400
Problem accessing /dashboard/memberDetails/. Reason:
Missing memId parameter
7.No error are seen on startup.
Please let us know the solution.