current license is non-compliant for [jdbc]
try{
Class.forName("org.elasticsearch.xpack.sql.jdbc.jdbc.JdbcDriver");
Connection con=DriverManager.getConnection("jdbc:es://http://localhost:9200/text");
//here sonoo is database name, root is username and password
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from tweet");
while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
con.close();
}catch(Exception e){ System.out.println(e);}
What license are you using? If you look at our subscriptions page, you can see which features that are available with each license level. The JDBC plugin is available with either a Platinum or Trial license.
I thing we are using trial version .
how to check version trial or not
Use the get license API. Based on the error I suspect you may be using the free Basic license.
{
"license": {
"status": "active",
"uid": "ee6d6576-d396-488f-ab3f-70d40359c052",
"type": "basic",
"issue_date": "2018-10-11T06:07:44.444Z",
"issue_date_in_millis": 1539238064444,
"max_nodes": 1000,
"issued_to": "elasticsearch",
"issuer": "elasticsearch",
"start_date_in_millis": -1
}
}
Which version of the stack are you using?
Then you should be able to activate a trial license from within Kibana.
i have a question
1>if we are using elasticsearch as db than we have to do purchase elasticsearch
2>what is use kibana in elastic
Use of the JDBC plugin requires a commercial subscription.
Kibana is the user interface within the Elastic Stack, and is used to analyse data and manage the system.